Hi,

In Sheet1, I want to get following: -

1. find yesterday's date
2. address of first cell containing yesterday's date
3. row number of first cell containing yesterday's date
4. column number of first cell containing yesterday's date
5. using column number from step 4, I want to remove all values from cells in that column, which do not contain any time.

I have clues about Step 1, 3 and 4.

But, I am not able to link Step 1 to 5 together.

With thanks,
Sukumar