Company Address Phone Contact Data Validation Abc 20 Hill St 054 7895 Fred B OzGrid Business Applications: Specialists in all aspects of Microsoft Excel From Training to Consultancy: www.ozgrid.com /www.MicrosoftExcelTraining.com 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.Company Address Phone Contact Abc 20 Hill St 054 7895 Fred B Def 147 Glide Rd 236 15478 Jane D hij 548 George St 0215 879 John D klm 1254 Canning Hwy 124 5478 Gary R Dynamic Range Names Nop 12 Fit St 021 35698 Mary W AllCompanies Qrs 187 Dam Cr 0415 25478 Jill G AllData Tuv 5879 Albany Hwy 0145 45879 Frank C Wxy 548 Long St 124 5698 Harry R To hide the sheet go to Format>Sheet>Hide To make sheet very hidden change it's Do this in it's Property Window Sub HideMe() Sheets("This Sheet should be hidden").Visble=xlVeryHidden End SubRefers 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),COUNTA('Format>Sheet>Hide change it's Visible Property to: xlVeryHidden. Property Window within the VBE (Alt+F11) or run this code: should be hidden").Visble=xlVeryHiddenbe hidden'!$A$2:$A$300),1) be hidden'!$A$2:$A$300),COUNTA('Data Sheet'!$1:$1))