Consolidating Worksheet Data

[rj_yan]

Hi I need some help.

Anyone knows how to consolidate all data from all worksheets into a single worksheet(master sheet)?

Attachment 292841

In the attachment, data for worksheet 1 will be added to the masterlist and worksheet 2 will follow.

[jmac1947]

Hi, and welcome to the forums

firstly, you didnt actually manage to get your spreadsheet uploaded, you will need to try again form the "Go Advanced" button on the lower right side of the "posting" window.

Secondly, have you looked at your post after you made it and seen the "similar threads" area where you are pointed to other threads that sound like yours.

In that way you quickly see others have had very much the same request and you can see the solutions offered by the volunteers on this forum

my personal experience with the forum users is that they are happy to assist someone with their knowledge of excel and VBA macros in particular but maybe no so keen on providing a "code to request service".

Please post your spreadsheet and explain exactly what you are expecting the result to look like.

Take the time to show us what the result you expect from the input data should look like, it will help us and that generally get you a response sooner

again,welcome and please read the forum rules, they help you and us

Jmac1947

[rj_yan]

Do I have the authority to delete this one?
I actually don't know where my question should belong that's why I posted it on two topics.

Sorry for my ignorance.

[jmac1947]

Hi,

no problem

If it is a macro / VBA issue then you are in the right place. Please reread my post and see that if you explain your problem clearly we can help
'in the meantime there is a thread you may like to look at:

http://www.excelforum.com/excel-prog...worksheet.html

cheers
Jmac

don't panic,