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

%3CLINGO-SUB%20id%3D%22lingo-sub-377527%22%20slang%3D%22en-US%22%3EAdding%20rows%20to%20a%20table%20based%20on%20text%20in%20another%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377527%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI'm%20using%20Excel%20for%20project%20management%20in%20a%20single%20workbook.%3C%2FP%3E%3CP%3EI%20set%20up%20one%20sheet%20for%20all%20Site%20data%20(named%20General)%20which%20includes%20Site%20ID%20(the%20master%20key)%2C%20Address%2C%20Contact%20details%2C%20etc.%20These%20are%20all%20the%20locations%20we%20may%20be%20required%20to%20perform%20work%20at.%3C%2FP%3E%3CP%3EThe%20other%20sheets%20are%20for%20each%20type%20of%20Work%20that%20may%20need%20to%20be%20performed%20at%20a%20site%2C%20e.g.%20Survey%2C%20Remedial%20Work%2C%20Cable%20Audit%2C%20etc.%3C%2FP%3E%3CP%3ENot%20all%20sites%20require%20all%20types%20of%20Work%2C%20so%26nbsp%3BI%20need%20a%20way%20to%20automatically%20add%20a%20Site%20to%20a%20specific%20Work%20sheet.%3C%2FP%3E%3CP%3ETo%20do%20this%2C%20in%20the%20General%20tab%20I've%20added%20columns%20for%20each%20type%20of%20Work%20and%20entered%20%22Yes%22%20in%20the%20cell%20if%20that%20type%20of%20Work%20is%20required.%3C%2FP%3E%3CP%3EHow%20do%20I%20get%20Excel%20to%20automatically%20add%20a%20site%20to%20a%20table%20in%20the%20relevant%20Work%20sheet%3F%3C%2FP%3E%3CP%3EI%20have%20experience%20using%20IF%2C%20THEN%20and%20VLOOKUP%20statements%2C%20but%20struggling%20to%20find%20the%20right%20combination%20to%20make%20this%20work.%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-377527%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377671%22%20slang%3D%22en-US%22%3ERe%3A%20Don't%20count%20empty%20cells%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377671%22%20slang%3D%22en-US%22%3EPlease%20attach%20the%20sample%20file%20so%20that%20my%20suggested%20formula%20won%E2%80%99t%20be%20riddled%20with%20plenty%20of%20assumptions.%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted
Please attach the sample file so that my suggested formula won’t be riddled with plenty of assumptions.