Copy and Paste

  • Thread starter Thread starter Db1712
  • Start date Start date
D

Db1712

Is there a way to create a macro that copies a cell to the next empt
cell in a given column on a different sheet
 
Try this to copy Sheets("sheet1").Range("A1") to Sheet2 in the A column

Sub test()
Sheets("sheet1").Range("A1").Copy _
Sheets("sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End Sub
 
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

Undeletable mark--amazing properties 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I insert a copied the row to multiple places in Excel? 1
Excel Macro to creat & send email 2
Macro to create newsheets 3
Macro to paste x number of times 4
copy and paste macro 2
Copying & Pasting with recorded macros 9

Back
Top