Hi folks,
Spreadsheet with 3 tabs: Position By Location, Hold, Vacancies
All three have identical headers in A1:M1.
Raw data is entered in the Position By Location tab starting with row 2, and may extend to 1000+ rows.
1. I would like help with code:
Position By Location tab:
If there is ANY content in Column K, starting with row 2...
"COPY" entire row to the Vacancies tab
beginning A2:M2 and copying down as needed.
Keep all rows copied to the Vacancies tab sorted by Column E (A-Z).
2. I would like help with code:
Position By Location tab:
If the word "HOLD" in Column J, starting with row 2...
"COPY" entire row to the Hold tab
beginning A2:M2 and copying down as needed.
Keep all rows copied to the Hold tab sorted by Column E (A-Z).
Thanks!!!!!!!
Spreadsheet with 3 tabs: Position By Location, Hold, Vacancies
All three have identical headers in A1:M1.
Raw data is entered in the Position By Location tab starting with row 2, and may extend to 1000+ rows.
1. I would like help with code:
Position By Location tab:
If there is ANY content in Column K, starting with row 2...
"COPY" entire row to the Vacancies tab
beginning A2:M2 and copying down as needed.
Keep all rows copied to the Vacancies tab sorted by Column E (A-Z).
2. I would like help with code:
Position By Location tab:
If the word "HOLD" in Column J, starting with row 2...
"COPY" entire row to the Hold tab
beginning A2:M2 and copying down as needed.
Keep all rows copied to the Hold tab sorted by Column E (A-Z).
Thanks!!!!!!!