where/how to insert a function

K

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

Ron de Bruin

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. Insert>Module from the Menubar
3. Paste the Code there
4. Alt-Q to go back to Excel
5. Alt-F8 to run the subs
 
K

Khoshravan

Hi Ron
It worked. Thanks a lot. I have a question.
You mentioned: sh.Columns("A:C").Copy
How it would be if want to copy non-adjacent columns like: Colums A,B,D,E,G?
 
K

Khoshravan

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

Khoshravan

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
 
Top