consolidate over 50 sheets by Macro

[Khoshravan]

I have same set of data for 50 runs of a program, each stored in a sheet. so
I have 50 sheets naming sheet1 to sheet50. Column headings are same for all.
I have to consolidate them into one sheet. Instead of going over 50 sheets to
add them in consolidation window, is it possible to perform it by MAcro to go
over 50sheets?

 

[Debra Dalgleish]

What happened when you tried the macro from Ron de Bruin's web site?

http://www.rondebruin.nl/copy2.htm

 

[Khoshravan]

Ron solution puts columns beside eachother. I want them to appear beneath
eachother (continiously) like the result when I use consolidate command.
Ron solution is good as far as having data in one sheet beside each other
not beneath each other. It might be possible to modify Ron Macro to do what I
want but I am a novice in Macro and don't know how to modify it. One more
point, number of my raws in sheets are not same they change from sheet to
sheet and I think I have to use dynamic range for them in Macro which add to
the difficulty of the task.

 

[Ron de Bruin]

I think you start 5 threads now

What do you want do exactly ?

not beneath each other

There is code for that on my site
http://www.rondebruin.nl/copy2.htm

 

[Khoshravan]

sorry for too many post and possible confusion. My last request is as I
mentioned in the previous post of this thread (qouted below).
I couldn't find a Macro in your site for this purpose (to copy beneath each
other not beside each other). If I am wrong and there is a Macro in your site
to perform this task, let me know.

 

[Ron de Bruin]

Use this

http://www.rondebruin.nl/copy2.htm#rows

 

[Khoshravan]

Yes that was very nice solution. I totally ignored it.
Can you introduce a site to master understanding of Macro?

 

[Ron de Bruin]

Buy this book
http://www.amazon.com/gp/product/0764540726/103-9184603-1794218?n=283155


More books here
http://www.contextures.com/xlbooks.html