Master List across multiple tabs
Within one workbook, I have a products list with unique IDs. Each month new inventory comes in and at the end of the month inventory is counted. There is a tab for each month.
COL A- product unique ID
COL B- product name
COL C- starting count (same as end of month count, COL F from previous month)
COL D- incoming count
COL E- formula of amount distributed
COL F- end of month count
For simplicity let’s say in January there are 3 products. Rows:
ROW 1- headers
ROW 2- product 1
ROW 3 -Product 2
ROW 4- Product 3
ROW 5- TOTALS
PROBLEM: every month we get 1 or 2 new products (adding a row or 2). I am trying to figure out how to maintain a master products list of the product and unique IDs that will update across all months. This would need to push the total row down (I’m not opposed to moving total to the top) AND keep the formulas in COL C and E (COL D and F are manual input).
is this possible?
Within one workbook, I have a products list with unique IDs. Each month new inventory comes in and at the end of the month inventory is counted. There is a tab for each month.COL A- product unique IDCOL B- product name COL C- starting count (same as end of month count, COL F from previous month) COL D- incoming countCOL E- formula of amount distributed COL F- end of month count For simplicity let’s say in January there are 3 products. Rows: ROW 1- headersROW 2- product 1ROW 3 -Product 2ROW 4- Product 3ROW 5- TOTALS PROBLEM: every month we get 1 or 2 new products (adding a row or 2). I am trying to figure out how to maintain a master products list of the product and unique IDs that will update across all months. This would need to push the total row down (I’m not opposed to moving total to the top) AND keep the formulas in COL C and E (COL D and F are manual input). is this possible? Read More