Hello,
How can I make columns A and B fill up automatically when I write down something in column C ?
The date in column A should be like: 27/02/2019, 28/02/2019, 01/03/2019 etc
thank you
Hello,
How can I make columns A and B fill up automatically when I write down something in column C ?
The date in column A should be like: 27/02/2019, 28/02/2019, 01/03/2019 etc
thank you
You would need a Worksheet Change Event handler to cater for this requirment.
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
It works but it is a problem:
when writing in column D, the date in column A is repeated: 28/02/2019
The event handler doesn't do anything with data typed in column D. It is only monitoring column C. It then puts the current date in both column A and column B and the formats the date in coumn B as "ddd" rather than using a TEXT formula.
You happy with this now?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks