macro to copy data from 3 worksheets in one worksheet

**iscar_marius** · 02-06-2009, 12:08 PM

I need a macro to copy data from "sheet1" "sheet2" "sheet3" / column E and F
to the worksheet "final".
The number of rows in "sheet1", "sheet2", "sheet3" etc. is variable.

Please open attached file!

Thanks for your help!

**StephenR** · 02-06-2009, 12:24 PM

You could do it like this:

Please Login or Register  to view this content.

**iscar_marius** · 02-06-2009, 01:36 PM

this is exactly what I need

Thanks!

**iscar_marius** · 02-07-2009, 02:35 PM

Originally Posted by StephenR

You could do it like this:

Please Login or Register  to view this content.

I am a beginer to VBA and I don't really understand the code

This code it's working very well but I don't understand how it's working.
If I need to copy data from column F and G how can I modify the code to work. Now the code copies data from column E and F.

Thanks!

**VBA Noob** · 02-07-2009, 02:48 PM

This locks in the starting cell. Change to F

Please Login or Register  to view this content.

and this part shows it ending in Col F, Change to G

Please Login or Register  to view this content.

and finally this parts find the last cell in Col F

Please Login or Register  to view this content.

So if the last cell in Col F is F100 the full code would copy the range E2:F100

HTH

VBA Noob

**iscar_marius** · 02-09-2009, 03:15 AM

Thank you!

**stevenoob** · 05-30-2013, 10:52 PM

This is almost what I am looking for, all I need to change is have the row count on the first column and for what ever reason I cant get the starting row to work. I want it to start in A3 and finish in CB (column A will always have cells filled where CB may have empty cells).

**protonLeah** · 05-30-2013, 11:39 PM

stevenoob,
Please do not resurrect old threads. Further, do not post your question in the thread someone else has started - this is known as thread hijacking and is against the Forum Rules.
Always start your own thread and, if it helps to clarify your needs, provide a link back to other threads.

I suggest you take the time to read the Forum Rules so that you can avoid infractions that will impact your posting privileges.