automatic

  • Thread starter Thread starter swain.s
  • Start date Start date
S

swain.s

is it possible to write something to automatically save info to the next
empty cell on another sheet
 
Lots of ways, here's one.

Sub copytonextsheet()
Set destsht = Sheets("sheet12")
With destsht
lr = .Cells(Rows.Count, "a").End(xlUp).Row + 1
ActiveCell.Copy .Cells(lr, "a")
End With
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

automatic sheet selection 2
Copying from different files into 1 1
Automatically adding additional rows 3
Fixed date with IF-function (or any other ideas?) 2
Save Today() in cell 3
Copy text from one worksheet to another 5
Possible? Copy/paste to&from moving sources/destinations 2
Transfer of data on mouse click – Urgent!!! 4

Back
Top