PDA

View Full Version : I Need A Macro That Moves Entire Row To Sheet2 If Cell=X



scarlettw123
08-25-2014, 04:20 PM
I need help with a Macro. I would like to move an entire row to a different spread sheet if cell contains information. I would also like to create a button on the sheet that will help me run the macro from the sheet.

Scenario:
Sheet1:"Past Due Shipments"
Sheet2: "Orders In Transit"
If column "K" in Sheet1 "Past Due Shipments" contains a number move entire row to sheet 2 "Orders In Transit".

I would also like to create a Macro that moves an entire row to Sheet1 if cell contains today() +35.
I have a sheet for each month that I use to keep track of all my purchase orders. (Sheets3-6) Ex: July 2014, August 2014.