Flag Check Scenario in VBA

[Rajesh_Tup]

Hi

Flag Check Scenario in VBA.png

Consider sheet 1 and sheet 2 in above screen shot. If sheet 2, accountflag="accnum" then update sheet1 as 'Y' in Account flag. Rest other table account flag should update as 'N' in sheet1. can anyone help.

Regards,
Rajesh

[Kaper]

Sheet1
cell B3
try:

Please Login or Register  to view this content.

and copy down

or may be

Please Login or Register  to view this content.

Or, as the question is in Macro forum (but I'd suggest formula solution anyway)

Please Login or Register  to view this content.