G
Guest
Hello,
First of all I am quite unfamiliar with VBA, I know where it goes and how it
works but the coding is not something I am familiar with.
I have a sheet that I paste data (using a simple macro) collected from a
word doc into a cell (L2) through to (L26)
The macro pastes the data, removes blank cells, copies the combined data,
moves it to a cell (C2) through to (C26) then deletes the pasted data in
Cell (L2:N26)
I would like to have a timestamp create when only 1 cell has changed (C7)
and put the resulting timestamp into cell (K7)
I have tried a few different examples I have found on the net abut they all
seem to clash with my original macro.
Any help with this is greatly appreciated.
Andrew
First of all I am quite unfamiliar with VBA, I know where it goes and how it
works but the coding is not something I am familiar with.
I have a sheet that I paste data (using a simple macro) collected from a
word doc into a cell (L2) through to (L26)
The macro pastes the data, removes blank cells, copies the combined data,
moves it to a cell (C2) through to (C26) then deletes the pasted data in
Cell (L2:N26)
I would like to have a timestamp create when only 1 cell has changed (C7)
and put the resulting timestamp into cell (K7)
I have tried a few different examples I have found on the net abut they all
seem to clash with my original macro.
Any help with this is greatly appreciated.
Andrew