$$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file
Dear Expert, Is there any way to find out how much memory is being used by a excel sheet in particular excel file . Like I have a file named XYZ (5mb memory used ) and in this file have three sheet (sheet1, sheet2, sheet3) then how much memory used by sheets , sheet1-??? sheet2-??? sheet3-??? Total-5MB Regards Lakshman Prasad Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ CTRL+D macro
Hi Experts I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in attached file. Pls help me providing this macro code. Regards Amit -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com CTRL+D.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file
:) As your question as my answer. Ek Bucket thi usme pani, patthar , aur lakdi ka tukda tha, uska weight 10 kg tha. ab Shanta ne poocha Pani,pathar aur lakdi ka weight kitna hai, to banta bola pehale pathar nikal do fir weight karo, ab jitna weight kam hoga wo pathar ka weight hoga. aur same lakdi ke liye karo. last tumhe pathar, lakdi aur pani ka weight pata chal jayega. hope you will got your answer. just take it as fun. Divaker On Tue, Jul 3, 2012 at 1:02 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear Expert, Is there any way to find out how much memory is being used by a excel sheet in particular excel file . Like I have a file named XYZ (5mb memory used ) and in this file have three sheet (sheet1, sheet2, sheet3) then how much memory used by sheets , sheet1-??? sheet2-??? sheet3-??? Total-5MB ** Regards *Lakshman Prasad* Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?
Hi Asa thank you very much for your help, let me see if i can explain better, I answered below the questions in yellow :) 2012/7/2 Asa Rossoff a...@lovetour.info Hi Jorge, I am happy to help you. * the table in the example transporter AA the volumes are the columns 1, 2 to 3, and 4 to 5, the column below is the weight, but there are some rules, imagine we have zone 1, but the kg are 8 but the volumes are 1, i´m must charge 2 instead of one, because the rule weight overules the other, whenever one rule is bigger than the other, we charge considering the highest value.* No problem. I think I understand all the values on the Transporter (e.g. AA) tables now. You didn't explicitly state so, but I understand now that the value being lookup up on this table (in B4:D7) is the Cost. I also understand that the correct cost to select is the highest of the two costs, for the given Volumes or Weight. ** ** ***1) ***Question, though; In your original message you said:** * i have a sheet where I every month i calculate the costs for logistics, there are 3 conditions (KM, Weight in KG, and Volumes), where i have to calculate depending on the data put in the columns B,C,D* Here you stated that the Distance (KM) is a criteria for cost. **a. **Please tell me, on the Transporter AA table, where is the Distance? Or in any case, please explain how you want the distance to be considered. Perhaps the Cost is Cost per KM, and gets multipled as such in the cost table…? I only put the distance in column B if my Order of purchase is in zone 4, in zone 1,2,3 i leave that column blank, the zone column is the E **2) **The ranges of values on your Transporter table are somewhat unclear to me. **a. **Volumes: 1, 2-3, 4-5. If the Volumes number used for your lookup is always a whole number with no fraction, this is clear, but.. ** i. **If it might contain a fraction, such as 1.3 or 1.9, what should happen? Should it be rounded up to 2 for the lookup in both cases? Should 1.3 be rounded down and 1.9 be rounded up? The volumes are whole number because we designate pallets as volumes. ** ii. **If Volumes is 5 or 1 what should happen? (below the first range or above the last range) if volume is smaller than 1 then error if 5 goes to above the last range. **b. **Weight: 1-5, 5-10, 10-100. Here your ranges actually overlap at the edges -- this is different from how you defined your ranges for Volumes. ** i. **Which range should be used if the weight is exactly 5? The first range or the second? Here you should use the first range, my mistake sorry ** ii. **What about 5.1 (if your data might contain fractions)? Would that be the first range or the second? should use first range until 5.99** ** iii. **What about 1 or 100? (below the first range or above the last range) ** smaller than 1 error, bigger than 100 should give ask for budget, if you wish i can put here my if formulas that i used for one transporter. ** Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Jorge Marques *Sent:* Monday, July 02, 2012 2:34 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups? ** ** HI, the table in the example transporter AA the volumes are the columns 1, 2 to 3, and 4 to 5, the column below is the weight, but there are some rules, imagine we have zone 1, but the kg are 8 but the volumes are 1, i´m must charge 2 instead of one, because the rule weight overules the other, whenever one rule is bigger than the other, we charge considering the highest value. ** ** i´m trying to do this with a table concatenating all the values and then using lookups, let´s see if I can succeed. 2012/6/29 Asa Rossoff a...@lovetour.info Hi Jorge, Looks like this can be handled using lookup formulas. One good way to perform lookups is to have a number representing each of your criteria each alone in their own cell, preferably all in the same table for all transporters. You can use pivot tables to generate the cross referenced charts you have now for easy human-reading for each shipper, and your Cost table can use lookup formulas to do its calculation. I'm a bit confused about a few details, and don't have a lot of time right now, but will try to take another look in the coming days if you haven't a solution yet. Some questions though: You refer to 6
Re: $$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file
Well enjoyed the example the story of santa banta. good fun. Thanks Regards, *Deba Ranjan P* On Tue, Jul 3, 2012 at 1:54 PM, Divaker Pandey divake...@gmail.com wrote: :) As your question as my answer. Ek Bucket thi usme pani, patthar , aur lakdi ka tukda tha, uska weight 10 kg tha. ab Shanta ne poocha Pani,pathar aur lakdi ka weight kitna hai, to banta bola pehale pathar nikal do fir weight karo, ab jitna weight kam hoga wo pathar ka weight hoga. aur same lakdi ke liye karo. last tumhe pathar, lakdi aur pani ka weight pata chal jayega. hope you will got your answer. just take it as fun. Divaker On Tue, Jul 3, 2012 at 1:02 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear Expert, Is there any way to find out how much memory is being used by a excel sheet in particular excel file . Like I have a file named XYZ (5mb memory used ) and in this file have three sheet (sheet1, sheet2, sheet3) then how much memory used by sheets , sheet1-??? sheet2-??? sheet3-??? Total-5MB ** Regards *Lakshman Prasad* Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file
Dear Lakshman, pls see below link.. http://www.excelforum.com/excel-general/501493-sheet-size-in-workbook.html On Tue, Jul 3, 2012 at 1:02 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear Expert, Is there any way to find out how much memory is being used by a excel sheet in particular excel file . Like I have a file named XYZ (5mb memory used ) and in this file have three sheet (sheet1, sheet2, sheet3) then how much memory used by sheets , sheet1-??? sheet2-??? sheet3-??? Total-5MB ** Regards *Lakshman Prasad* Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
Congratulations *Ashish **koul* and *Dilip Pandey*. The help, the second great forum you will make more and better. 2012/7/3 Deba Ranjan drdeva...@gmail.com Dear Ashish and Dilip. Sorry for the delay, its a really awesome stage. heartiest congratulate to both and please keep helping to this group. Thanks Regards, *Deba Ranjan P* On Mon, Jul 2, 2012 at 9:23 PM, vijayajith VA vijayajith...@gmail.comwrote: CongratsASHISH *DILIP... On Mon, Jul 2, 2012 at 9:18 PM, chhajersand...@gmail.com wrote: ** Congratulation Ashish and Dilip. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- *From: *Sam Mathai Chacko samde...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Mon, 2 Jul 2012 21:01:24 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Cc: *Dilip Pandeydilipan...@gmail.com *Subject: *Re: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip Pandey !! Excellent achievement once again by Ashish and Dilip. Kuddos to both. Regards, Sam Mathai Chacko On Mon, Jul 2, 2012 at 7:32 PM, ashish koul koul.ash...@gmail.comwrote: Thank you all... On Mon, Jul 2, 2012 at 4:39 PM, Amol Shrivastava shri.a...@gmail.comwrote: *Congratulations Ashish and Dilip...!!* -- Thanks Regards, Amol Shrivastava +91 99671 18180 On Mon, Jul 2, 2012 at 4:35 PM, Aindril De aind...@gmail.com wrote: Congratulations Ashish and Dilip!! Your Contributions have always been an asset to our group.. Hard Luck Don...!! Your contributions have always been really helpful in our group.. Better luck next time!! Cheers Andy On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.comwrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul* and *Dilip Pandey*and thanks for their big support to this forum. Keep posting ! Best regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Warm Regards, Aindril De Ph: 9811300157 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Amol Shrivastava +91 99671 18180 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add
Congratulations *Ashish koul* and *Dilip Pandey* . 2 you wish to continue to contribute increasingly good forum. 2012/7/3 pankaj gmail account pankaji...@gmail.com Dear Moderator, Please also Ban these kinds of Promotional/Advertisements in this forum. They are not related to Excel Help. Please advice Thanks and Regads, Pankaj Michael On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and thanks for their big support to this forum. Keep posting ! Best regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Pankaj Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
Congrats..Ashish Dilip *Best Regards,* *Venkat * *Chennai* On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and thanks for their big support to this forum. Keep posting ! Best regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * * * * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Macro to populate Output file
Hi its working fine at my place On Tue, Jul 3, 2012 at 1:38 AM, OJEMENI Uzoma uojem...@gmail.com wrote: Ashish, If i were to change the input from numbers too letters as in the *attached file*, what changes to the code would be necessary as i am having an error Run-time error '13' Type Mismatch. Thank you to a prompt response. On Mon, Jul 2, 2012 at 4:25 PM, OJEMENI Uzoma uojem...@gmail.com wrote: Thank you Ashish. The macro worked perfectly. On Mon, Jul 2, 2012 at 3:02 PM, ashish koul koul.ash...@gmail.comwrote: try this see if it helps Sub create_txtfile() Dim arv, st1 As String Dim s As Long, j As Long, k As Long MyFile = C:\Documents and Settings\user\Desktop\sample\ouputfile.txt 'set and open file for output With Sheets(Sheet1) .Range(x:x).Clear .Range(a1:a .Range(a1048576).End(xlUp).Row).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range( _ k1), Unique:=True End With fnum = FreeFile() Open MyFile For Output As fnum Write #1, For i = 2 To Sheets(1).Range(k65356).End(xlUp).Row j = Application.WorksheetFunction.Match(Sheets(1).Range(k i).Value, Sheets(1).Range(a:a), 0) k = Application.WorksheetFunction.CountIf(Sheets(1).Range(a:a), Sheets(1).Range(k i).Value) + j - 1 st1 = arv = Sheets(1).Range(b j :b k) For s = LBound(arv) To UBound(arv) st1 = st1 arv(s, 1) Next st1 = Application.WorksheetFunction.Trim(st1) Print #1, Chr(34) Sheets(1).Range(k i).Value Chr(34) Chr(9) Chr(34) st1 Chr(34) Next i Close #fnum End Sub On Mon, Jul 2, 2012 at 12:00 PM, Ojemeni Uzoma uojem...@gmail.comwrote: ** Hello Everyone, Kindly assist with a Macro. Thanks. Uzoma Ojemeni Uzoma | Call 08060700717 -- *From: * OJEMENI Uzoma uojem...@gmail.com *Date: *Sun, 1 Jul 2012 19:02:25 +0100 *To: *excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Macro to populate Output file Hello Everyone, I would appreciate some assistance in creating a macro to export the content in the file input to the file output. The spacing, tabs and apostrophe should remain the same way as it is in the output file. Thank you everyone. Ojemeni Uzoma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ CTRL+D macro
Sub sample() Sheets(Sheet1).Range(d4:d20).FillDown End Sub On Tue, Jul 3, 2012 at 1:35 PM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in attached file. Pls help me providing this macro code. Regards Amit -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******
Show group already have 03 users received decode of the Microsoft, real absolute. I am tham community this because it very useful to add comments expression cho me also like all all user. Sorry, I was busy at the work group, wish all the members of this forum to achieve important event, I hope that in future other members can achieve as Ashish koul and Pandey Dilip, hope you two continue to contribute to better forum. 2012/7/3 Dilip Pandey dilipan...@gmail.com Congratulations Ayush . . . . !! This is a wonderful group with full of energy and learning. Thanks to all the members for achieving this milestone. :) Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi -62, India On Mar 22, 2012 4:25 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members,** I am proud to announce that the forum has completed 5 years today. This is really great milestone of the forum. My sincere thanks to each one of you who keep this forum alive by asking questions and helping others by providing solutions. Over the last five years, I have seen decent growth in the number of posts and quality of solutions provided by the experts here. I have learned many things from this forum and experts. In my view, Learning never stops and the discussion forum is the best place to learn and share the skills. I hardly get time to resolve the excel queries after office hours but I try my best to moderate the forum closely. I visit the forum 2-3 times daily to approve the messages and to check everything is ok. Please let me know the improvements and changes you want to see in the forum. I would be happy to hear your feedback. Some key achievements of this forum in numbers: 1) In last 1.5 years, we have seen three people receiving the Microsoft MVP award from this forum. This is itself a big achievement for forum and I hope to see more deserving people get this award in future. 2) This is spam free forum and we hardly get spam messages. In last 5 years, 1000 members are banned for sending spam messages 3) We are 8400+ members with diversity in expertise, experience and location. 4) Over 7600+ topics discussed in five years Once again many thanks and congratulations to all of you. Keep posting and together we will achieve more milestones. Regards, Ayush Jain Microsoft MVP Forum Owner jainayus...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
Congrats..Ashish Dilip.pls keep helping group Cheer's, Chandrabhan On Tue, Jul 3, 2012 at 6:29 PM, Venkat CV venkat1@gmail.com wrote: Congrats..Ashish Dilip -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
Congrats both of them. God bless.. On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and thanks for their big support to this forum. Keep posting ! Best regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: CTRL+D macro
Hi Amit, Please see the attachment. regards Prince Dubey. On Tuesday, 3 July 2012 13:35:23 UTC+5:30, Mitr wrote: Hi Experts I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in attached file. Pls help me providing this macro code. Regards Amit -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com CTRL+DSolved.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Is there any way to find out how much memory is being used by a excel sheet in particular excel file
Hi Lakshman, I think you should copy or Move your each sheets into a new work book this help you to know the size of each sheets in your workbook. hope this will help you. regards prince On Tuesday, 3 July 2012 13:02:48 UTC+5:30, lakshm...@yahoo.com wrote: Dear Expert, Is there any way to find out how much memory is being used by a excel sheet in particular excel file . Like I have a file named XYZ (5mb memory used ) and in this file have three sheet (sheet1, sheet2, sheet3) then how much memory used by sheets , sheet1-??? sheet2-??? sheet3-??? Total-5MB Regards *Lakshman Prasad* Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Is there any way to find out how much memory is being used by a excel sheet in particular excel file
type name of file into a cell and run this macro to determine file size Sub filesize() 'FOR SELECTED MsgBox FILE SIZE IS Format(FileLen(ActiveCell .xls) * 0.0009767, 0) KB End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Prince Dubey Sent: Tuesday, July 03, 2012 11:48 AM To: excel-macros@googlegroups.com Cc: LAKSHMAN PRASAD Subject: $$Excel-Macros$$ Re: Is there any way to find out how much memory is being used by a excel sheet in particular excel file Hi Lakshman, I think you should copy or Move your each sheets into a new work book this help you to know the size of each sheets in your workbook. hope this will help you. regards prince On Tuesday, 3 July 2012 13:02:48 UTC+5:30, lakshm...@yahoo.com wrote: Dear Expert, Is there any way to find out how much memory is being used by a excel sheet in particular excel file . Like I have a file named XYZ (5mb memory used ) and in this file have three sheet (sheet1, sheet2, sheet3) then how much memory used by sheets , sheet1-??? sheet2-??? sheet3-??? Total-5MB Regards Lakshman Prasad Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ range formatting
Hi Pawel, You can accomplish this simply by using conditional formatting. You can either: 1. Use a default format and a conditional format. a. Format D5:J22 with one of the two formats. This would be your default format regarldess on the value in C2. b. Use a conditional format rule based on a formula. The formula would be =$C$2=1 (or $C$2=2) then set the appropraite format to go with the formula chosen. 2. Use two conditional format rules. a. one for the formula =$C$2=1 b. another form the formula $C$2=2 Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: Tuesday, July 03, 2012 1:34 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ range formatting Hi All, I'd hope that you'd help me on this one. I'd like to change range formating depending on the number in cell C2. So if I'll pick 1 formating for range D5:J22 should be change to britsh pounds like in sheet2 So if I'll pick 2 formating for range D5:J22 should be change to formating like in sheet3 Can you please help me on this? Thanks Pawel see attachment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)
Hi Members / Experts I need a macro to change the background color of a cell as soon as i change the value (alphanumeric). The background is originally yellow and as soon I change a value it should become no fill (or white ). Sometimes the changed value might be same as previous value ..in that case what should be done so that the background color changes to white ? like should I enter the cell and write the value again or any other option Please help me in this regard Vijay yadav -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)
Dear Vijay, For this you may use conditional formatting. There is no need to make macro. Thanks Regards, Gawli Anil On Wed, Jul 4, 2012 at 11:00 AM, vijay yadav wrote: Hi Members / Experts I need a macro to change the background color of a cell as soon as i change the value (alphanumeric). The background is originally yellow and as soon I change a value it should become no fill (or white ). Sometimes the changed value might be same as previous value ..in that case what should be done so that the background color changes to white ? like should I enter the cell and write the value again or any other option Please help me in this regard Vijay yadav -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com