Compare three data sets with in a workbook to find missing account with the help of VBA

[Anand307]

Hello,

I am looking for a specific problem to resolve via VBA.

· We have a excel workbook that is attached , Whichever accounts are there on “PMAN Data(Static)” tab they should be hidden from “eGlue Report” tab. (first step)

· Then we need a comparison check between “eGlue Report” tab & “Monitors Data” tab to figure out the missing account in “Monitors Data” tab, once this is done via vlookup just highlight the missing account cell (second step)

Notes -

· On “eGlue Report” tab column A and B will be manually input and number of rows might vary daily.

· On “Monitors Data” tab column A will be manually input and number of rows might vary daily.

· “PMAN Data(Static)” tab is constant for a month, it changes only once a month – However the format of the sheet would remain same ie data will remain in A column only.

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[Anand307]

Perfectly working fine, just that one more additional amendment needed is any account that is present only on “eGlue Report” tab and not on “Monitors Data” tab that particular cell needs to be highlighted in “eGlue Report” tab. Please use attached which shows an example of highlighted cell.

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[Anand307]

Excellent ...it worked perfect....