collecting data from many sheets to one sheet

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
>
>

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

Hi Rasoul

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

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



"Khoshravan" <khoshravan@discussions.microsoft.com> wrote in message news:4A6BCE11-6CED-4B98-B4CC-CADB023F2F90@microsoft.com...
>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
>>
>>