Company Address Abc 20 Hill St
Phone 054 7895
Contact Fred B
Data Validation
All grey cells within the table have a LookUp formula to a dynamic named range called "AllData". They also have a COUNTIF formula to ensure the company name chosen exists. OzGrid Business Applications: Specialists in all aspects of Microsoft Excel From Training to Consultancy: www.ozgrid.com / www.MicrosoftExcelTraining.com
Company Abc Def hij klm Nop Qrs Tuv Wxy
Address 20 Hill St 147 Glide Rd 548 George St 1254 Canning Hwy 12 Fit St 187 Dam Cr 5879 Albany Hwy 548 Long St
Phone 054 7895 236 15478 0215 879 124 5478 021 35698 0415 25478 0145 45879 124 5698
Contact Fred B Jane D John D Gary R Dynamic Range Names Mary W AllCompanies Jill G AllData Frank C Harry R
To hide the sheet go to Format>Sheet>Hide
To make sheet very hidden change it's Visible Property to Do this in it's Property Window within the VBE (Alt+F11) Sub HideMe() Sheets("This Sheet should be hidden").Visble=xlVeryHidden End Sub
Refers To: =OFFSET('This Sheet should be hidden'!$A$2,0,0,COUNTA('This Sheet should be hidden'!$A$2:$A$300),1) =OFFSET('This Sheet should be hidden'!$A$2,0,0,COUNTA('This Sheet should be hidden'!$A$2:$A$300),COUN
go to Format>Sheet>Hide
y hidden change it's Visible Property to: xlVeryHidden. erty Window within the VBE (Alt+F11) or run this code: should be hidden").Visble=xlVeryHidden
be hidden'!$A$2:$A$300),1) be hidden'!$A$2:$A$300),COUNTA('Data Sheet'!$1:$1))