I am using number to track sale and deduct them from inventory. I have over 30 product I am using a spreadsheet list, they have to enter quanity sold on each row to reduce from inventory. I want to create a pop up menu, with the name of items and link to cell with the amount of current stock.
Hi PRINTSTOP,
See if this works for you.
In the Inventory table, Column B shows your last stocktake. We must start somewhere, and I used 100 for each product. I included only 6 products to make a smaller screenshot.
In the In/Out table is where you type your daily sales and deliveries.
Column B has Pop-Up Menus:
In the Inventory table,
Formula in C2 is SUMIF('In/Out'::B,A2,'In/Out'::C)
Formula in D2 is SUMIF('In/Out'::B,A2,'In/Out'::D)
Formula in E2 is B2−C2+D2
Fill down.
Please call back with questions.
Regards,
Ian.
Hi PRINTSTOP,
See if this works for you.
In the Inventory table, Column B shows your last stocktake. We must start somewhere, and I used 100 for each product. I included only 6 products to make a smaller screenshot.
In the In/Out table is where you type your daily sales and deliveries.
Column B has Pop-Up Menus:
In the Inventory table,
Formula in C2 is SUMIF('In/Out'::B,A2,'In/Out'::C)
Formula in D2 is SUMIF('In/Out'::B,A2,'In/Out'::D)
Formula in E2 is B2−C2+D2
Fill down.
Please call back with questions.
Regards,
Ian.
NUMBER ADDING VALUE TO NAMES in pop up menu
