Macro Copy and Paste

  • Thread starter Thread starter mstover34
  • Start date Start date
M

mstover34

I am currently trying to copy from one workbook that has 7 differen
tabs and paste into one worksheet on a separate master workbook. M
problem is that when I set up the macro to copy from one of the tabs i
the workbook and paste to the other work book, I only want the the row
to come in where there is data. Currently I am having to run a macr
that takes every 100 lines, but ideally I only want the informatio
copy and pasted where there is only data.

In addition, once I have copy and pasted everything from the first tab
my next step is to copy and paste information from the second tab t
the master on the same sheet. How do I create the macro to make sur
that it pastes the information from the second tab on the next blan
line in the master workbook that already has the information paste
from the first workbook?

Any help with this would be awesome.

Best Regards,
Mar
 
use x to copy the desired cells from the source workbook and y to know where
to place in the destination workbook.
x=workbooks("source.xls").sheets("source").cells(rows.count,"a").end(xlup).r
ow
y=workbooks("destination.xls").sheets("destination").cells(rows.count,"a").e
nd(xlup).row+1
 
Back
Top