I think I got the answer to my own question.
I think the consolidate command will do what I want. Add data to end of
previous raws
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Khoshravan" wrote:

Your solution puts columns next to each other. Is there a solution to add
columns to end of previous columns.
In other words, in master sheet, number of columns remain same but number of
raws increase?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Ron de Bruin" wrote:

Hi

See my reply in one of your other threads

On my site you an read this

Where do I place the code and the functions?
1. Alt-F11
2. InsertModule from the Menubar
3. Paste the Code there
4. Alt-Q to go back to Excel
5. Alt-F8 to run the subs



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



"Khoshravan" wrote in message ...
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