hello,
i have attached relevant excel sheet with this.
what i want to do is find the previous working date from a column and filter that column by removing blanks
as an example
if it's 22-Mar today, i need to filter the Kth column(relevant to the 21-Mar) and remove the blanks from kth column .
ash color columns are holidays.so they should be ignored,that means
if today is 27-Mar, i need to filter the Mth column relevant to the 22-Mar(i don't need to filter those ash colored columns )
I'd prefer to this using a macro.but i have no idea how to do it
could you please help me to to this task
thanks very much
Bookmarks