consolidating multiple workshheets

deuxo

New Member
Joined
Mar 25, 2002
Messages
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.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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)
 
Upvote 0
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
 
Upvote 0
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.

ni****h desai
 
Upvote 0
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,
 
Upvote 0

Forum statistics

Threads
1,213,528
Messages
6,114,154
Members
448,553
Latest member
slaytonpa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top