Hello All,
1 - I have 3 sheets ( User, PROUDCT, MARKET)
2 - I want to mask the data in all the three sheets.
Logic 1- On the User TAB i want to mask the all four fields
ID,FIRST NAME,LAST NAME,EMP ID
Where STATE ='ST1' OR 'ST2'
Logic 2 - I want to search in other tabs (PRODUCT and MARKET) and apply the same Logic as above by which means
On PRODUCT TAB the Below two rows should be masked
PROD ID PROD NAME DESC
P1 RICKY PONTING XXASD
P2 RICKY PONTING ;MARK WESLEY REDT
On MARKET TAB the Below two rows should be masked
MARKET ID PROD USER ID INFO
M1 111;222 ZZZZZ
M2 333 EEEE
I want this to be more Dynamic as we have multiple sheets in the same excel file which needs to be masked.
I can think of Multi Field formula works but i want some help around how to build a Macro which uses a Multi Field Formula so that it checks for each sheet and apply the masking rules where STATE ='ST1' OR 'ST2.
Attached the sample Data for reference any help would be much appreciated.
