Hi Frds
I wanna create a separate excel books based on status of the column F(Status). If contains pending completion, then the respective rows needs to be copied to new excel workbook along with the existing headers. and these excel file needs to be saved in folder and folder and excel work book name should be the saved with the current date
Separate excel needs to be created for if account start with c56
and for the accounts start with c92 needs to copied to different excel
Name of the excels and folder should be the current date.
Can anyone help me Please
I wanna create a separate excel books based on status of the column F(Status). If contains pending completion, then the respective rows needs to be copied to new excel workbook along with the existing headers. and these excel file needs to be saved in folder and folder and excel work book name should be the saved with the current date
Separate excel needs to be created for if account start with c56
and for the accounts start with c92 needs to copied to different excel
Name of the excels and folder should be the current date.
Can anyone help me Please