under sheet 'count lookup' i have a results table displaying values from the same row based on a given value. this however is only looking at one sheet. how can i change the value to look at all the sheets.
-i have 5 different building sites
-each site has the number of how many bricks have been laid in each house
i would like to be able to search across all sites by typing in the site and plot number to return the amount of bricks laid
Thanks
sorry protection code '6504'
Bookmarks