link run data sheets into inventory sheet

[Minnesota_Knice]

what i would like to do is this...


every lot we run there is a "data run sheet" that gets filled out in excel. what i would like is to be able to do is create an "inventory sheet" in a different excel workbook that pulls the (lot#, product1, product2, product3, product4, good, and scrap.)

the opperators fill out the run sheet and i have to fill out an inventory report daily. I have both sheets set up, but i currently have to bounce back and forth and fill in each blank manuely, how do i like the 2, work smarter not harder.

[Mel_Martinez]

Hi,

Could you please attach your sample workbook.

Mel

[Minnesota_Knice]

Mel,

my work books are run confidential and i can not.

what i need is to be able to link the same cells in newly created worksheets to 7 collums in my inventory worksheet.

im getting caught up with the templet being saved as a different file every time

[Minnesota_Knice]

drs.xlsxinventory.xlsx


MEl,


here is teh just of what im working with

[Mel_Martinez]

I think you could use vlookup function. If you could provide me just a sample not the actual data, I could make a sample template for you.

[Minnesota_Knice]

mel look above your name in my last post

[Mel_Martinez]

Please see sample attachment if it pass your requirement.


On that sample I used Pivot table.