Adding rows to a table based on text in another table.

Regular Visitor

Hi All,

I'm using Excel for project management in a single workbook.

I set up one sheet for all Site data (named General) which includes Site ID (the master key), Address, Contact details, etc. These are all the locations we may be required to perform work at.

The other sheets are for each type of Work that may need to be performed at a site, e.g. Survey, Remedial Work, Cable Audit, etc.

Not all sites require all types of Work, so I need a way to automatically add a Site to a specific Work sheet.

To do this, in the General tab I've added columns for each type of Work and entered "Yes" in the cell if that type of Work is required.

How do I get Excel to automatically add a site to a table in the relevant Work sheet?

I have experience using IF, THEN and VLOOKUP statements, but struggling to find the right combination to make this work.

Thanks in advance.

1 Reply
Please attach the sample file so that my suggested formula won’t be riddled with plenty of assumptions.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies