collecting data from many sheets to one sheet

[Khoshravan]

I have same structure of data (same column headings) in different sheets.
Each sheet name is a cityname.
What is the easiest way to bring all data from all sheets to a single sheet?
In the new sheet I should also add a new column and put city name (sheet
name).
Is there any written macro in the Internet to do this job?
Some people may ask the reason that I want to merge already separeted data,
but I need to have data in a single sheet.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

collecting data from many sheets to one sheet

[raypayette]

An easy way is to click on Data, Consolidate.

[Khoshravan]

Thanks. I haven't heard or used consolidate command. I checked the help.
sounds good and will help want I want to do. But like other commands, help is
not easy to follow at least for me. Is there any tutor in MVP for this
command?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"raypayette" wrote:

>
> An easy way is to click on Data, Consolidate.
>
>
> --
> raypayette
>
>
> ------------------------------------------------------------------------
> raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
> View this thread: http://www.excelforum.com/showthread...hreadid=565914
>
>

[Khoshravan]

One more question about following link:
http://www.excelforum.com/showthread...hreadid=565914
I post my question to microsoft ng but it appears in above link as well.
Could you please explain about this procedure?
Is it automatic or is your setting? What is benefit. Generally what do you
call this technique in web?
will be happy to know more about above technique.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"raypayette" wrote:

>
> An easy way is to click on Data, Consolidate.
>
>
> --
> raypayette
>
>
> ------------------------------------------------------------------------
> raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
> View this thread: http://www.excelforum.com/showthread...hreadid=565914
>
>

[raypayette]

As stated:
"These forums are gateways to selected excel related usenet newsgroups. "
More info:
http://www.newsadmin.com/bit/gatewayfaq.asp

[Debra Dalgleish]

Ron de Bruin has code that will copy data from worksheets onto a master
sheet, and includes an option to insert the sheet name in a column.

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

Khoshravan wrote:
> I have same structure of data (same column headings) in different sheets.
> Each sheet name is a cityname.
> What is the easiest way to bring all data from all sheets to a single sheet?
> In the new sheet I should also add a new column and put city name (sheet
> name).
> Is there any written macro in the Internet to do this job?
> Some people may ask the reason that I want to merge already separeted data,
> but I need to have data in a single sheet.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

[Khoshravan]

I am trying to copy a macro with a function from www.rondebruin.nl/copy2.htm
site.
It has explained how to enter the MAcro but not mentioned how/where to
insert the function. how should I do this? sorry for simple question but it
is my first time use function command in excel.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

where/how to insert a function


"Debra Dalgleish" wrote:

> Ron de Bruin has code that will copy data from worksheets onto a master
> sheet, and includes an option to insert the sheet name in a column.
>
> http://www.rondebruin.nl/copy2.htm
>
> Khoshravan wrote:
> > I have same structure of data (same column headings) in different sheets.
> > Each sheet name is a cityname.
> > What is the easiest way to bring all data from all sheets to a single sheet?
> > In the new sheet I should also add a new column and put city name (sheet
> > name).
> > Is there any written macro in the Internet to do this job?
> > Some people may ask the reason that I want to merge already separeted data,
> > but I need to have data in a single sheet.
>
>
> --
> Debra Dalgleish
> Contextures
> http://www.contextures.com/tiptech.html
>
>

[Debra Dalgleish]

Perhaps Ron will explain in the other thread, where you're working with
him on the same problem. (Re: Consolidate different worksheets into one
worksheet)

Khoshravan wrote:
> I am trying to copy a macro with a function from www.rondebruin.nl/copy2.htm
> site.
> It has explained how to enter the MAcro but not mentioned how/where to
> insert the function. how should I do this? sorry for simple question but it
> is my first time use function command in excel.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

[Ron de Bruin]

Hi Rasoul

See
http://www.cpearson.com/excel/codemods.htm

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



"Khoshravan" <[email protected]> wrote in message news:[email protected]...
>I am trying to copy a macro with a function from www.rondebruin.nl/copy2.htm
> site.
> It has explained how to enter the MAcro but not mentioned how/where to
> insert the function. how should I do this? sorry for simple question but it
> is my first time use function command in excel.
> --
> Rasoul Khoshravan Azar
> Civil Engineer, Osaka, Japan
>
> where/how to insert a function
>
>
> "Debra Dalgleish" wrote:
>
>> Ron de Bruin has code that will copy data from worksheets onto a master
>> sheet, and includes an option to insert the sheet name in a column.
>>
>> http://www.rondebruin.nl/copy2.htm
>>
>> Khoshravan wrote:
>> > I have same structure of data (same column headings) in different sheets.
>> > Each sheet name is a cityname.
>> > What is the easiest way to bring all data from all sheets to a single sheet?
>> > In the new sheet I should also add a new column and put city name (sheet
>> > name).
>> > Is there any written macro in the Internet to do this job?
>> > Some people may ask the reason that I want to merge already separeted data,
>> > but I need to have data in a single sheet.
>>
>>
>> --
>> Debra Dalgleish
>> Contextures
>> http://www.contextures.com/tiptech.html
>>
>>