Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste
Hello all,
I am using the following macro and it works great if data is in every cell. If there is not data in a cell then nothing in that row is copied over to the other sheet. How can I make it work with out data in some cells? Sub Last_four() Sheets("Last Four").Select Dim lastrow As Long Dim myrow As Long Dim mycol As Long lastrow = Sheets("test database").Cells(Rows.count, "A").End(xlUp).Row myrow = 1 mycol = 1 For i = 12 To 9 Step -1 Do Until Sheets("test database").Cells(lastrow, mycol) = "" Sheets("last four").Cells(i, mycol) = Sheets("test database").Cells(lastrow, mycol) mycol = mycol + 1 Loop lastrow = lastrow - 1 mycol = 1 Next End Sub I would appreciate all your help thanks Eric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste
I could certainly be over-simplifying this, but it looks/sounds to me
like you want to copy the entire row of the last 4 rows containing data in the Test Database sheet and place them in rows 9:12 of the Last Four sheet, correct? If so, this will do the trick: Sub Last_four() Dim lastrow As Long lastrow = Sheets("test database") _ .Cells(Rows.Count, "A").End(xlUp).Row Sheets("test database").Rows(lastrow - 3 & _ ":" & lastrow).Copy _ Sheets("last four").Cells(9, 1) End Sub Eric wrote: Hello all, I am using the following macro and it works great if data is in every cell. If there is not data in a cell then nothing in that row is copied over to the other sheet. How can I make it work with out data in some cells? Sub Last_four() Sheets("Last Four").Select Dim lastrow As Long Dim myrow As Long Dim mycol As Long lastrow = Sheets("test database").Cells(Rows.count, "A").End(xlUp).Row myrow = 1 mycol = 1 For i = 12 To 9 Step -1 Do Until Sheets("test database").Cells(lastrow, mycol) = "" Sheets("last four").Cells(i, mycol) = Sheets("test database").Cells(lastrow, mycol) mycol = mycol + 1 Loop lastrow = lastrow - 1 mycol = 1 Next End Sub I would appreciate all your help thanks Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Automating copy/paste/paste special when row references change | Excel Programming | |||
help w/ generic copy & paste/paste special routine | Excel Programming | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming |