I made an inventory workbook. Sheet 1 has all the data on all the items for all locations. Sheet 2 has an advance filter that brings in from sheet 1 all the data from a specific location. Is there anything I can write to automatically update sheet 2 when I add data to Sheet 1? Thanks
Bookmarks