consolidate over 50 sheets by Macro

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?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

consolidate over 50 sheets by Macro

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

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

Khoshravan wrote:
> 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
Contextures
http://www.contextures.com/tiptech.html

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.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Debra Dalgleish" wrote:

> What happened when you tried the macro from Ron de Bruin's web site?
>
> http://www.rondebruin.nl/copy2.htm
>
> Khoshravan wrote:
> > 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
> Contextures
> http://www.contextures.com/tiptech.html
>
>

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Khoshravan" <[email protected]> wrote in message news:[email protected]...
> 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.
> --
> Rasoul Khoshravan Azar
> Civil Engineer, Osaka, Japan
>
>
> "Debra Dalgleish" wrote:
>
>> What happened when you tried the macro from Ron de Bruin's web site?
>>
>> http://www.rondebruin.nl/copy2.htm
>>
>> Khoshravan wrote:
>> > 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
>> Contextures
>> http://www.contextures.com/tiptech.html
>>
>>

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.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Ron de Bruin" wrote:

> 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
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Khoshravan" <[email protected]> wrote in message news:[email protected]...
> > 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.
> > --
> > Rasoul Khoshravan Azar
> > Civil Engineer, Osaka, Japan
> >
> >
> > "Debra Dalgleish" wrote:
> >
> >> What happened when you tried the macro from Ron de Bruin's web site?
> >>
> >> http://www.rondebruin.nl/copy2.htm
> >>
> >> Khoshravan wrote:
> >> > 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
> >> Contextures
> >> http://www.contextures.com/tiptech.html
> >>
> >>
>
>
>

Use this

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




--
Regards Ron de Bruin
http://www.rondebruin.nl



"Khoshravan" <[email protected]> wrote in message news:[email protected]...
> 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.
> --
> Rasoul Khoshravan Azar
> Civil Engineer, Osaka, Japan
>
>
> "Ron de Bruin" wrote:
>
>> 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
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Khoshravan" <[email protected]> wrote in message news:[email protected]...
>> > 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.
>> > --
>> > Rasoul Khoshravan Azar
>> > Civil Engineer, Osaka, Japan
>> >
>> >
>> > "Debra Dalgleish" wrote:
>> >
>> >> What happened when you tried the macro from Ron de Bruin's web site?
>> >>
>> >> http://www.rondebruin.nl/copy2.htm
>> >>
>> >> Khoshravan wrote:
>> >> > 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
>> >> Contextures
>> >> http://www.contextures.com/tiptech.html
>> >>
>> >>
>>
>>
>>

Yes that was very nice solution. I totally ignored it.
Can you introduce a site to master understanding of Macro?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Ron de Bruin" wrote:

> Use this
>
> http://www.rondebruin.nl/copy2.htm#rows
>
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Khoshravan" <[email protected]> wrote in message news:[email protected]...
> > 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.
> > --
> > Rasoul Khoshravan Azar
> > Civil Engineer, Osaka, Japan
> >
> >
> > "Ron de Bruin" wrote:
> >
> >> 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
> >>
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >>
> >> "Khoshravan" <[email protected]> wrote in message news:[email protected]...
> >> > 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.
> >> > --
> >> > Rasoul Khoshravan Azar
> >> > Civil Engineer, Osaka, Japan
> >> >
> >> >
> >> > "Debra Dalgleish" wrote:
> >> >
> >> >> What happened when you tried the macro from Ron de Bruin's web site?
> >> >>
> >> >> http://www.rondebruin.nl/copy2.htm
> >> >>
> >> >> Khoshravan wrote:
> >> >> > 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
> >> >> Contextures
> >> >> http://www.contextures.com/tiptech.html
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Buy this book
http://www.amazon.com/gp/product/076...94218?n=283155


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



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Khoshravan" <[email protected]> wrote in message news:[email protected]...
> Yes that was very nice solution. I totally ignored it.
> Can you introduce a site to master understanding of Macro?
> --
> Rasoul Khoshravan Azar
> Civil Engineer, Osaka, Japan
>
>
> "Ron de Bruin" wrote:
>
>> Use this
>>
>> http://www.rondebruin.nl/copy2.htm#rows
>>
>>
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Khoshravan" <[email protected]> wrote in message news:[email protected]...
>> > 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.
>> > --
>> > Rasoul Khoshravan Azar
>> > Civil Engineer, Osaka, Japan
>> >
>> >
>> > "Ron de Bruin" wrote:
>> >
>> >> 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
>> >>
>> >>
>> >> --
>> >> Regards Ron de Bruin
>> >> http://www.rondebruin.nl
>> >>
>> >>
>> >>
>> >> "Khoshravan" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > 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.
>> >> > --
>> >> > Rasoul Khoshravan Azar
>> >> > Civil Engineer, Osaka, Japan
>> >> >
>> >> >
>> >> > "Debra Dalgleish" wrote:
>> >> >
>> >> >> What happened when you tried the macro from Ron de Bruin's web site?
>> >> >>
>> >> >> http://www.rondebruin.nl/copy2.htm
>> >> >>
>> >> >> Khoshravan wrote:
>> >> >> > 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
>> >> >> Contextures
>> >> >> http://www.contextures.com/tiptech.html
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>