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