Thanks Mick for the new code.
When I tested it it didnt give me always the correct date for the made date col, howvever I Changed
To
It seemed to work great however further testing highlighted that Column A was not always showing the latest date.
I tried to mod the code but havent got it to work or even run as I dont fully understand it.
Can the code leave the latest dates for both the Made Date in column O & the shipped date in column A ?
If not then I am quite happy with the help you have given.
Many Thanks
Regards, Elaine
Bookmarks