VBA to copy and paste data based on lookup criteria to select and position data

[BvDA]

Hi,

Outline of required code relating to the attachment. I managed small sections of the code but not the lookup and position based on criteria.

For each cell in Col F

<On Chk log test tab>
Check if Col F is blank.
If yes go to Col C and copy date.
Check site number and

On Tracker Test tab
Match to site number in Col A on Tracker test tab.
Find next empty cell on matched row
Paste the date copied

On Chk log test tab
Place "logged" in Col F.

Else if Col F = "logged"
Then move to next cell.

[Tinbendr]

You didn't give any complete examples in your book, so I hope this is what you wanted.

Please Login or Register  to view this content.