Hi all! So, I am certainly not an advanced user but take pride in the fact that I can usually figure something out on my own but am stumped here.
Please see my attached spreadsheet. My table in the 'Property Openings' tab will be filled in manually, some by data validation lists and others by formulas or manual entries. The 'Titles' tab has all of the Property job titles in column A. Now, the tab 'Summary' has all of the statistical information. I would want a section for 'Property Summary - By Job Title'. I provided an example at the bottom of this sheet. My problem is that I only want the chart/table to appear and/or calculate if the opening for the job title exists on the 'Property Openings' tab or if it is created it should automatically be created. I am trying to avoid having 15 tables for each job title when only 6 of them are currently open. I already have some code on the 'P O' tab so any suggestion are welcomed. It may help to mention that I will be printing and producing this as a 'report' to distribute so I need it to look as neat and clean as what I already have on the 'Summary' tab. Also, I may need to add and/or remove some stat elements on the Summary tab so I am hoping I would be able to manipulate the coding, if necessary, without being a pro.
Thank you in advance for any help provided!
Bookmarks