I have created a merchandise inventory workbook with seperate spreadsheets for each item, ie. certain t-shirt in white and another for the shirt in green. To make the process of entering the daily sales into the individual item's spreadsheet I created another spreadsheet that has every item listed, including each size. Right now, the quantity of item sold are entered into this sheet, then printed, then entered into the individual items' sheets. The fields in the individual item sheets are just organized by colums for each size, date of transaction, and event.
Is there a way I can make the cells sync from the sheet that has all the items listed to the individual item sheets? Maybe by date on the sheet that shows all the items to a date field in the individual sheets?
Thanks for all the help!!
Stevens
Bookmarks