Database update/extract/add/search form

Copper Contributor

Hi

I am using Excel 2019 on windows 10.

 

I have database which contains 2 fixed columns (Product Name and ID) and 6 other columns (Products Prices like Cost, Sale Price,...) which are to be updated with time with respect to each product.

It currently contains 700 products as rows and more products will be added in the future.

 

I want to create a form through which I am able to search these produts and view their prices and in future update the existing price of that product. Also, i want to link every update in the price with a date and maintain a record of changes in prices of that product.

 

I am not very familier with VBA and need help in figuring this out.

 

Thank You So Much!

1 Reply

Hi @lohit24a,

 

You said:

in future update the existing price of that product. Also, i want to link every update in the price with a date and maintain a record of changes in prices of that product.

 

Question: How are the updates done.  When you say link every update, are the updates being updated using a url link? or a query perhaps?  Can you elaborate on what you update procedure is?

 

cheers