Hello:
I need help on how to write a macro to do the following . Here are the details:
In the workbook there are 2 sheets. I need to copy data from columns P and Q on Sh2 to Sheet 1 columns Y and Z . Data in column P is text but Q is a date (which needs to be automatic when data is entered into P).
This copy-paste event is triggered when data is placed into Column P (Sh2), but only if cell C says, “Task Summary Line”. Also note that in that same row on Sh2 is a unique Log No. in Cell A.
When the macro pastes info (data from P and the date from Q)from sh2 to columns Y and Z on Sh1 it does so only if the Log No from Sh2 matches the Log no on Sh1 Cell A.
If the data is later removed from Sh2 column P the entry on Sh1 will disappear.
The range needs to handle ( for example) P3 through P1000.
Thank you.