I'm creating a budgeting template that consists of 10 identical sheets (labeled Sheet1, Sheet2, etc.). Each sheet allows me to enter staff, materials, etc. for each phase of a project.
I need to create a client report sheet, which pulls data from each sheet. That's easy. What I can't figure out is...
How can I have the client report sheet ignore sheets that don't have anything on them? The algorithm is something like this:
if cell g38 on sheet1 = 0 then ignore this one and go to the next sheet, else pull the data into the report.
I'm hoping that the report sheet will flow smoothly (without gaps for missing sheets).
Any suggestions?
I need to create a client report sheet, which pulls data from each sheet. That's easy. What I can't figure out is...
How can I have the client report sheet ignore sheets that don't have anything on them? The algorithm is something like this:
if cell g38 on sheet1 = 0 then ignore this one and go to the next sheet, else pull the data into the report.
I'm hoping that the report sheet will flow smoothly (without gaps for missing sheets).
Any suggestions?