Zeeman
Registered User

i am trying to develop a code that will maintains my worksheet, i want todays date to display in colum A autiomatically and staff will add data to in colum B, C, D etc, i want a code to, first input the date in colum A and secondly a code that will remove all data more than 6 months old from the the row that is more than 6 months old, i know i can use the today () function to set todays date but on the next day the information in colum B, C, D do not follow the date.

thanking all in advance