I am looking to write a macro that simply cut/paste an entire row from sheet1 to sheet2 if the cell value in row i (Elevation) is greater than 5.
ExcelForumMoveRow.xlsx
Thank you!!
I am looking to write a macro that simply cut/paste an entire row from sheet1 to sheet2 if the cell value in row i (Elevation) is greater than 5.
ExcelForumMoveRow.xlsx
Thank you!!
Last edited by michaelpair; 06-18-2013 at 02:16 PM.
I had to unmerge the cells in rows1 and 2. By cut you mean, you want to copy and delete it from sheet1
Thank you - yes, copy and delete from sheet1...I noticed that there is a Sheet1, Sheet1 (2), and Sheet 2?
Sheet1 (2), copy of the original sheet, just delete it. The code does copy and delete.
Awesome!! It works perfectly, thank you again!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks