"Excel Help please" Topic

I've been tasked with tracking the location of (lets says Widgets) The widgets(with Unique ID's) location can change every day. Several hundred at a time.

Basically we would have a master sheet that would need to be updated daily with the location of the widgets. To go into the sheet, one widget at a time and change the location would be a monumental task, on a daily basis.

So is there a way to create a snapshot of the existing location, then import lists of the changes? To overwrite the previous location? We can scan the widgets as they move, into text or excel sheets.

I know this is really DB territory, but I have to work with what I got.

Thanks for any advice. Xin

If you have 2 speadsheets (master and current locations) you could do a VLOOKUP to get the current location of the widget. Then Copy and Paste Special (Values) to voerwrite the location in the master.

PM if you need more ideas

Are you comfortable writing excel macros? If so, I would write a macro that would import a text file in a fixed format into a new spreadsheet, and then read through the imported data updating your master spreadsheet with the correct data. It would be under a day to program if you have the experience -- a lot longer if you need to learn as you go.