automatically updating inventory sheet

[dc44724]

Hi all,

I am trying to develop a macro that would update an inventory sheet with over hundreds of items. To make this easier, I have a master sheet that I will enter the information in as I go through each item. I basically need to look up a certain i.d. in the inventory sheet and update it with the current information i've obtained. I am new to excel, any and all help is greatly appreciated.

Thanks.

 

[rdw72777]

So you'll have a master template with data (presumably from the last time you updated it) and then a sheet you will have created that you'd like updated into the Master?

If so, a few questions:

1. What columns will be in the files (i.e. columns you want updated and those you want left alone should be specified.
2. Which column or value is the driving force to match the 2 files (part #, item #, sku, cost center, etc.)?
3. What should be done if there is a row of data in one file not found in the other?
4. Are the master and the file you maintain before updating the Master be found in the same Excel file?