Anthony's VBA Forum

[WorkeRiley]

Hello,

I have a small challenge with Excel that I would like to solve. I have many many sheets of data from a series of tests. They are all in a similar format. What I would like to do is extract a single column from each of these sheets and input them into a brand new worksheet such that I may compare all of the data. I feel like there should be a simple and modular way to do this, so that I may avoid copy and pasting every column I need, every time I wish to do this.

Any help would be greatly appreciated. Many thanks!

Cheers,
Riley

[mohan.ankur]

Yes,

There is a simpler way out.
May be you can simply try to record a macro and see what code you get.

Customise it a bit and you should be good to go.
Let me know if U need further help

Thanks
_________________
http://www.exceldepot.com
http://www.xlmacros.com
http://www.learnexcel.org