Macro to copy columns from several sheet into one sheet

[ddd93]

Hi

I have a spreadsheet that has 20 sheets with stock information. From each sheet i would like to copy the daily return (column g) into one summary sheet that shows each company and there daily return next to each other.
Thus basically in row one you can read the company data and from row 2 onwards you can see the stock returns.

Any help on how I can build a macro to loop through each worksheet and do this would be greatly appreciated.

Thanks for your help.

[xladept]

Something like this:

Please Login or Register  to view this content.

[ddd93]

Hi xladept

Thank you for your help, i will use your code

[xladept]

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.