Hi guys,
Need your help with a macro.
I have a sheet called "Data" and it has data in the following columns (A:AB) with blank rows in between. Firstly I want the blank rows to be removed. Then I want the macro to copy the data in mentioned column (A:AB) which follows the following condition:
Column B <> "*5500*" (Column B has employee id eg: 5500124 or 2201876 { id starting from 5500 are for temp employees while id starting from any other number is for permanent employees}
to a new sheet from cell A2 which will be named on today's date like "16-Oct-22"
Once that is done, I want the macro to copy the data from the "Data" sheet that follows the following condition below in a new sheet named "Temp Drivers"
Column B = "*5500*"
Need your help with a macro.
I have a sheet called "Data" and it has data in the following columns (A:AB) with blank rows in between. Firstly I want the blank rows to be removed. Then I want the macro to copy the data in mentioned column (A:AB) which follows the following condition:
Column B <> "*5500*" (Column B has employee id eg: 5500124 or 2201876 { id starting from 5500 are for temp employees while id starting from any other number is for permanent employees}
to a new sheet from cell A2 which will be named on today's date like "16-Oct-22"
Once that is done, I want the macro to copy the data from the "Data" sheet that follows the following condition below in a new sheet named "Temp Drivers"
Column B = "*5500*"