Solved Excel - Auto Copy A Row To Another Sheet

Microsoft corporation Office 2010 profes...
February 12, 2017 at 21:19:19
Specs: Windows 64
I have a worksheet contains Sheet1 and Sheet2:
Sheet1: contains Data about foreign workers, my reference to each worker is the Passport Number, some passports will expire soon or later,
So, the main question is (How can i copy full row to Sheet2) when the passport is less than 1 year or less than 365 days

Passport expiry date identified as "pp_expiry" & start from cell No. (L7)
Passport number identified as "pp_no" & start from cell No. (K7)

thank you very much

See More: Excel - Auto Copy A Row To Another Sheet

February 13, 2017 at 03:44:57
✔ Best Answer
A macro could be written to copy the rows but something would need to trigger it. That would be based on when you want the copy to occur. The code could be run manually or it could be triggered by an "event" such any change to the worksheet, the opening of the worksheet, the saving of the worksheet, etc.

In addition, since this a copy, and not a "move" (cut/paste) we would need a way to prevent the code from copying the same rows multiple times. This could be easily accomplished by putting a "flag" in unused column of Sheet1 once the row is copied.

Any additional information you could provide related to how you use the worksheet might be helpful.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question