Hello,
I am looking for help with pulling data from various sheets and combining into one summary worksheet.
I have attached the file for reference.
For this example, what I am trying to achieve is list all glass tag #’s (with width, height) on the summary sheet but for Floor 7 only. In the various worksheets, the quantity of each tag on floor 7 is listed in column N. Currently, I have a Macro that lists all glass tags on the summary sheet and then have a lookup in Column F of the summary sheet to populate the order qty based on the Column input. However, this of course lists ALL glass tags from each sheet, even the tags with quantity of 0 on floor 7 (rows 11 through 31 on summary worksheet, for example)
Is there a way to have the summary worksheet populate with only glass tag’s that have quantities required for that specific floor? (in this case, only paste glass tag if the value in column N of that row is non-zero) I would like it so that once it is set up the same template file can be used to retrieve the order quantities from different floors
Apologies in advance if any of the above is unclear, I have done my best to describe the situation.
Thanks so much for the assistance!
Bookmarks