Keep and Update History of Prices of products in Excel

[fleyd]

Hi,

I have a Excel file (kind of like a Database) with some books in it:

1- DB Products (here are some aspects of the products that dont usually change, like the code, tax, measures etc...)
2- History of Prices (the ideia here is to save the prices i ask suppliers during the year)
3- NEW Prices to be Inserted (the ideia here, is to place new prices i ask, and they be place "automatically" in the previous bokk with a vlookup formula)
4- Boxes (just some data, ignore...)


I am a warehouse of products and i am asked many quotations of products, some of those quotations i answer clients with "old" prices from my Database and other Clients i first ask suppliers for updated prices and answer Clients with those.

I would like some advice on how to keep all those prices i ask suppliers, organized in my Database with minimal efford from me. Currently i am using the attached file, but do anyone think there is a better and easier way?

This method i am using works good when i want to insert new prices, but it fails when i want to upgrade existing prices... I dont see a easy way when i want to upgrade/replace existing prices... Can anyone advise me on a better way of keeping new prices and updating/replacing "old" prices easily?


Thanks.



I tried to upload the file normally but i couldnt... So i uploaded to my Dropbox.

https://dl.dropboxusercontent.com/u/...%20-%20En.xlsx

[etaf]

in your history of prices I would not set-out horizontally
I would have a new row for each new price - with a field for Date / Supplier

then you can use a lookup for the code and pull off prices by certain suppliers or dates

[fleyd]

Hi and thanks for the suggestion

I will think better, but since my currently database as +- 1200 items perhaps it would be complicated to change everything now.... But i will consider it

Thanks