Good day and hopefully someone can help. I know for an easy way to transfer data entered in a column from one tab to another, I could just enter "=Sheet2!A1". However, in my situation I have an excel spreadsheet with Column A on the first tab having different approval statuses already entered (i.e. deactivated, hold, FCRA approved, etc...) I need a formula so that whenever I change an approval status on my first sheet (FCRA wave received) in column A to Non-FCRA approved or FCRA approved, that entire line will automatically transfer to the 2nd sheet (Approved).
I have attached an example spreadsheet for assistance. Basically, if I change line 23 to FCRA approved (which I have done on this example spreadsheet attached), I want that entire line to automatically be entered on the 2nd sheet (approved) on the next available line (in this instance, line 16).
Any help is much appreciated and hopefully this makes sense.
Bookmarks