Hi all, So im having troubles coding this and was wondering if someone could just help! Copies column A of Sheet `Crew Members` to whatever the sheet name is entered in cell B1 Some parameters`: First, the sheet `Crew Members` will check the sheet `Terminated 75 days` to see if any names in both column A`s correspond and if a name is listed in `Terminated 75 days` then it will update the status (B column of Crew Members) to `Terminated BEFORE 90 days`` Then it will I guess sort all of the `Terminated BEFORE 90 days``, `Terminated AFTER 90 days`` and `Resigned` and make sure the statuses that say Àctive`or LOA will always be above. Lastly, it will move just the name listed in column A to column A of whatever the sheet in B1 is – only If the crew member is Àctive or LOA.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Copying items to another sheet if a cell equals something

Hi all,

So im having troubles coding this and was wondering if someone could just help!

Copies column A of Sheet `Crew Members` to whatever the sheet name is entered in cell B1
1. Some parameters`:
  1. First, the sheet `Crew Members` will check the sheet `Terminated 75 days` to see if any names in both column A`s correspond and if a name is listed in `Terminated 75 days` then it will update the status (B column of Crew Members) to `Terminated BEFORE 90 days``
  2. Then it will I guess sort all of the `Terminated BEFORE 90 days``, `Terminated AFTER 90 days`` and `Resigned` and make sure the statuses that say Àctive`or LOA will always be above.
  3. Lastly, it will move just the name listed in column A to column A of whatever the sheet in B1 is – only If the crew member is Àctive or LOA.