=INDEX('MASTER INV'!F$4:$F$5055,MATCH(C30,'MASTER INV'!$C$4:$C$5055,0))
Ok this pulls part# & description from inv list on 'MASTER INV' Sheet.
C4 column F4 column
Part# Description Over to 'SALES INVOICE' Sheet.
Then I need to be able to change the instock number in the 'MASTER INV' Sheet. G4 column to the value in the 'SALES INVOICE' Sheet
F4 column
Qty
Where the 'SALES INVOICE' Sheet is where I want to reduce the inventory stock level in 'MASTER INV' Sheet based on the above.
Yikes hope you can decipher as to I'm new at this.
I have an inventory that I ebay the items in stock. And have an invoice sheet where i produce an invoice for the office and need it to reduce the stock levels in the master inv sheet from inputs on the invoice sheet. With the index from above it pulls the part# & Description perfectly to my invoice, but how can I change the inventory stock levels from the invoice sheet sold qty?
Ok this pulls part# & description from inv list on 'MASTER INV' Sheet.
C4 column F4 column
Part# Description Over to 'SALES INVOICE' Sheet.
Then I need to be able to change the instock number in the 'MASTER INV' Sheet. G4 column to the value in the 'SALES INVOICE' Sheet
F4 column
Qty
Where the 'SALES INVOICE' Sheet is where I want to reduce the inventory stock level in 'MASTER INV' Sheet based on the above.
Yikes hope you can decipher as to I'm new at this.
I have an inventory that I ebay the items in stock. And have an invoice sheet where i produce an invoice for the office and need it to reduce the stock levels in the master inv sheet from inputs on the invoice sheet. With the index from above it pulls the part# & Description perfectly to my invoice, but how can I change the inventory stock levels from the invoice sheet sold qty?
