Daily repetitive import and sort, macro, lookup or am i totally on the wrong track.

[jordiman]

I have started a capacity planning workbook, and am tring to structure it such that fixed data, such as product codes and descriptions are input into one sheet, thereafter only touched for maintainence. Otherwise this data is read into the appropriate production lines.
Daily data(non fixed) such as inventory by item, and demand by item are imported daily. I am aware that there are many import types into excel, but assume that this is already in excel format. On a daily basis I will want to populate multiple sheets with the standing data and non fixed data, ie allocate the products to lines, update available inventory and changes in demand. It is my intention that the sheets to be populated will be identical in layout, but that the standing data may have additional items added, and that the inventory and demand may be in varying product sequence.
As this is repetitive, but possibly sequenced differently daily, any suggestions of the most disciplined method of structuring this will be greatly appreciated.

[tek9step]

Hi

Have you got an example workbook to understand your problem exactly as to what you are trying to achieve.



tek9step

[jordiman]

test reply ....pls ignore

[jordiman]

Hi tek9step,
sorry for the delay, problems posting, locked out since yesterday, no idea why.
I attach an example file and will try to explain what I want to do.

overall, building a front page with standing data, which I will use daily to update other sheets, ie to ensure newly added products, machines etc are not omitted, then, and this is the real question, update the "variables" table with data from the FCASTORDERS sheet, and INVENTORY sheet, such that each day I can draw in new data. The two tables are only in the sheet for ease, and in the real world would be on another machine. So I want to simplify the update process, amd have tried Vlookup to date, and have had my code corrected byNBVC(many thanks), but I guess I am really wondering what is the correct way to do this in as few steps as possible.....ie open file each morning, change the date(somewhere), press enter and it updates.
any advice....brill