Copying Data

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I am trying to set up a macro to copy info from one sheet
to multiple sheet but in the next available slot. Example
Copy sheet1 data A5 to d5 and paste it to sheet 2 & 3 for
the next available A? on sheets 2 & 3
 
worksheets("A4:D5").Copy _
Destination:=worksheets("Sheet2").Cells(rows.count,1).End(xlup)(2)
worksheets("A4:D5").Copy _
Destination:=worksheets("Sheet3").Cells(rows.count,1).End(xlup)(2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting and copy or copy and formatting ?? 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Range(sheet2) = Range(sheet1) 11
Excel Move or Copy Stopped Working? 0
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Copy and Paste Loop 2
Macro to Combine Data from Multiple Sheets with Cell References 4
My Never ending ARRAY code problems 18

Back
Top