Hi I would appreciate help here please
Is there a one liner to add the date in first blank cell in K col
and copy down to data in J column
Thanks for any help here
Regards
Graham
Hi I would appreciate help here please
Is there a one liner to add the date in first blank cell in K col
and copy down to data in J column
Thanks for any help here
Regards
Graham
How about this?
=IF(J1="","",TODAY())
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Are you sure that is all there is to this ???
I pasted that in a macro and got a compile error ???
Thanks for helping
Regards
Graham
Actually i have managed to find first empty cell in K Column and added todays date there
but i now need to copy that down to last data in column J
I think you mean:
Please Login or Register to view this content.
Rory
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks