Hi all,
Tried looking around for this one but can't find something that works.
I have data in columns A - D that a macro pre-populates, only column B has data in every cell. The macro copies a date from one sheet but what I want it to do is find the first empty cell in column E to start pasting into and then go down as far as the last populated cell in column B.
Thanks in advance
Karl.
Tried looking around for this one but can't find something that works.
I have data in columns A - D that a macro pre-populates, only column B has data in every cell. The macro copies a date from one sheet but what I want it to do is find the first empty cell in column E to start pasting into and then go down as far as the last populated cell in column B.
Thanks in advance

Karl.