consolidating multiple workshheets

deuxo · Mar 28th, 2002, 06:14 PM

I need to add data from multiple worksheets into one large sheet on aregular basis. i have been copyiny data and pasting, I am trying to see if there is a way to automate this process by naming the sheets. thanks for any help.

robfo0 · Mar 28th, 2002, 06:25 PM

Try recording a macro. Then you can use this macro to do the same thing in the future (assuming your future worksheets will be formatted the same)

Yogi Anand · Mar 28th, 2002, 08:41 PM

Quote:

On 2002-03-28 17:14, deuxo wrote:
I need to add data from multiple worksheets into one large sheet on aregular basis. i have been copyiny data and pasting, I am trying to see if there is a way to automate this process by naming the sheets. thanks for any help.

Hi deuxo:
In addition to robfo0's suggestion, you should also explore DATA|CONSOLIDATE featue built in Excel for a purpose like yours!

_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature

[ This Message was edited by: Yogi Anand on 2003-01-19 14:20 ]

nisht · Mar 28th, 2002, 08:48 PM

Yes there are lots of way to do that.

First it depends how you are putting the logic..

Well your question interest me..

Can you explain me more in detail..or send workbook to me at

nisht@pexcel.com

please send me the zip file.

May i can help you.

nishith desai

deuxo · Mar 29th, 2002, 10:52 AM

Thanks for responses. To clarify what I m trying to do,I have multiple sheets of data in the exact same format. I want to append the set of data from each sheet to the end of a data list in one large sheet. I do not want to add cells together, as you do under DATA>consolidate. I have been copying and pasting, which works fine but is taking to much time as I add more worksheets. I am trying to see if there is a way to do without a macro, or if someone has a macro I could look at. thanks,

Xeon · Apr 1st, 2002, 01:46 AM

I have similar problems
anyone got a macro code on this.. Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 06:14 PM	#1
deuxo New Member Join Date: Mar 2002 Posts: 13	I need to add data from multiple worksheets into one large sheet on aregular basis. i have been copyiny data and pasting, I am trying to see if there is a way to automate this process by naming the sheets. thanks for any help.

Mar 28th, 2002, 06:25 PM	#2
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	Try recording a macro. Then you can use this macro to do the same thing in the future (assuming your future worksheets will be formatted the same)

Mar 28th, 2002, 08:48 PM	#4
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	Yes there are lots of way to do that. First it depends how you are putting the logic.. Well your question interest me.. Can you explain me more in detail..or send workbook to me at nisht@pexcel.com please send me the zip file. May i can help you. nishith desai

Mar 29th, 2002, 10:52 AM	#5
deuxo New Member Join Date: Mar 2002 Posts: 13	Thanks for responses. To clarify what I m trying to do,I have multiple sheets of data in the exact same format. I want to append the set of data from each sheet to the end of a data list in one large sheet. I do not want to add cells together, as you do under DATA>consolidate. I have been copying and pasting, which works fine but is taking to much time as I add more worksheets. I am trying to see if there is a way to do without a macro, or if someone has a macro I could look at. thanks,

Apr 1st, 2002, 01:46 AM	#6
Xeon New Member Join Date: Mar 2002 Posts: 1	I have similar problems anyone got a macro code on this.. Thanks