Hi, New poster here so apologies if this has already been posted.



I have a BI report I run which feeds different sheets split by department. The department sheets sums values from the BI tab dependant on a combination of factors (Account/Project/Cost Centre).
There are hundreds of thousands of possible combinations but only perhaps a hundred that relate to each department so in order to keep the department tabs as concise as possible I don't want to include every possible combination on each one.
I have a lookup on the BI tab which looks up all the sheets to tell me which rows from the BI data are not included anywhere in the workbook but is there any quick way to add these rows onto the department sheets without me having to enter all the missing entries manually?
TIA,
Vic

Can you post your project here?