Hello and thanks for taking the time to look at my problem.
I have an invoicing workbook for merchandise. Each invoice is a separate worksheet that includes data from a master worksheet.
The "master" inventory is about 300 line items in rows with the delivery of new product being in rows 9 through 309 and Columns C:R with dates of delivery (C3:R9).
The invoicing is pretty straight forward. there is a a cell (B4) that has the invoice date and there is a column marked "delivery" to change the inventory as product becomes added in inventory.
I would like to be able to automatically add to the delivery column for each invoice based on data I enter in the master so I'm not having to cut and paste each time.
Example sheet "9455" cell b4 is June 6 and based on any deliveries for June 6 from Master will auto populate the delivery column based on info from the master.
I have tried Hlookup to no avail and am a bit at a loss.
Thanks for your time.
I have an invoicing workbook for merchandise. Each invoice is a separate worksheet that includes data from a master worksheet.
The "master" inventory is about 300 line items in rows with the delivery of new product being in rows 9 through 309 and Columns C:R with dates of delivery (C3:R9).
The invoicing is pretty straight forward. there is a a cell (B4) that has the invoice date and there is a column marked "delivery" to change the inventory as product becomes added in inventory.
I would like to be able to automatically add to the delivery column for each invoice based on data I enter in the master so I'm not having to cut and paste each time.
Example sheet "9455" cell b4 is June 6 and based on any deliveries for June 6 from Master will auto populate the delivery column based on info from the master.
I have tried Hlookup to no avail and am a bit at a loss.
Thanks for your time.