How to auto link columns from different sheets for a template
I am trying to setup a template that will auto work with our Revit exported spreadsheet. I have had no problem with it until I get to linking the quantities per room. I want to have it search for the right item number and then proceed to list the quantities and the room names down the list in order and then not put in "0" or miscellaneous text from somewhere else, I only want it to read each item's info and not skip to another. See attached images for a better understanding. Is this possible?
Attachment | Size |
---|---|
Capture.PNG | 22.02 KB |
Capture2.PNG | 47.27 KB |
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago