I don't know how to do this but I want to add this to a macro.
In cell a1 there is a date (the rest of the column is blank) and in the column next to it, column b, there is text, about 200 rows.
How would I get the date to automatically fill in the cells, when there is text to the right of it?
Thanks
In cell a1 there is a date (the rest of the column is blank) and in the column next to it, column b, there is text, about 200 rows.
How would I get the date to automatically fill in the cells, when there is text to the right of it?
Thanks