VBA code. Copy certain cells with a number of conditions

[mjc]

Hi all!

using Excel 2016 and am new to VBA.
after something that can do the following -

search worksheet “report” cell J3 in worksheet “completed SB wksps” col F:F

where true copy col”S” and paste in worksheet “Report” M3 if “S” blank paste in col “P”

In Worksheet “Report” N3 where “S” has values paste col P,Q
Or if “S” blank paste “Q” only

is this possible?

I can’t post a file with example data until I’m back at home on my own PC

thank you for any help or comments!

[mjc]

7