onefastmx5
New Member
- Joined
- Sep 13, 2012
- Messages
- 12
Help!
Im using Excel 2010 and want to create a macro that allows me to cut the cells A:S and U in the current active row and paste in the same locations on the next page, at the bottom of a growing list. I would like formulas to be copied also.
Alternatively, cut and paste the entire row, but do not paste over the data already in column T on the destination page.
Ive got this so far:
ActiveSheet
Range(Cells(.Row, "A"), Cells(.Row, "S")).Select.Copy
Selection.Sheets("Work Commenced").Range("a", "S").End(xlUp).Offset(1, 0).Paste
ActiveCell.EntireRow.Delete
Application.CutCopyMode = False
and im sure its totally wrong.
Help please!
Adam.
Im using Excel 2010 and want to create a macro that allows me to cut the cells A:S and U in the current active row and paste in the same locations on the next page, at the bottom of a growing list. I would like formulas to be copied also.
Alternatively, cut and paste the entire row, but do not paste over the data already in column T on the destination page.
Ive got this so far:
ActiveSheet
Range(Cells(.Row, "A"), Cells(.Row, "S")).Select.Copy
Selection.Sheets("Work Commenced").Range("a", "S").End(xlUp).Offset(1, 0).Paste
ActiveCell.EntireRow.Delete
Application.CutCopyMode = False
and im sure its totally wrong.
Help please!
Adam.