Hi,

i spent couple of days with VBA code with no luck. the code must to find empty cell from sheet1("registration") - (this sheet is for new registration columnA->name, columnB->surname and columnC->date of birth) this must be deleted after time period 6 months (it is for security reason), but thatīs OK i sucessfully programed it.
And now on based this deleted values from sheet("registration") in column A,B and C i am looking for some code where at other sheet("prihlaska")- (this is for statistics) must be that value deleted or renamed to "unregistered" or something like "not registered" but not delete values which are still at sheet("registration") - (less than 6 months period).

I have this code but it doesnīt work. Just renamed some randomly values at column A.

Please Login or Register  to view this content.
Than you for any help.