mjc
08-23-2018, 06:41 PM
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!
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!