spittingfire
04-10-2018, 03:25 PM
Hi All,
I have attached a sample workbook.
What I'm looking to do in the sample workbook is I have 3 sheets. One sheet is Sales SOD, one is Sales and the other is Sales Bilingual.
What I want to do in the Sales SOD sheet I will like to hide a row dynamically if certain conditions are matched.
Each name in Sales SOD will have a matching sheet with the same name.
So for Sales Bilingual in the Sales SOD sheet I want to hide that row if cell AE56 in the Sales Bilingual sheet = 0
Since I have many SODs with many sheets I will like to do this dynamically. All matches will however be based on cell AE56 of the individual sheet name.
Any assistance would be appreciated.
I have attached a sample workbook.
What I'm looking to do in the sample workbook is I have 3 sheets. One sheet is Sales SOD, one is Sales and the other is Sales Bilingual.
What I want to do in the Sales SOD sheet I will like to hide a row dynamically if certain conditions are matched.
Each name in Sales SOD will have a matching sheet with the same name.
So for Sales Bilingual in the Sales SOD sheet I want to hide that row if cell AE56 in the Sales Bilingual sheet = 0
Since I have many SODs with many sheets I will like to do this dynamically. All matches will however be based on cell AE56 of the individual sheet name.
Any assistance would be appreciated.