Small table with formulas for each data element but only when the element exists in table on another tab

[STEVEMILLS04]

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.

I have a table in the 'Property Openings' tab which has a data list in column A for job title. 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'. My problem is that I only want the stat chart/table on the summary tab 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.

How do I have a small table only appear when the job title is entered on a different tab? There is a pre-determined list of job titles so the user cannot just enter any random title. I posted this to a different excel forum and nobody is able to answer the question. I was able to attach my spreadsheet so if you would like me to email it I would be happy to!

Thank you in advance for any help provided!

 

[ca.moazzam]

hi pls email me your file at ca.moazzam@gmail.com to have a look