I'll try to explain this the best I can.

I want to produce an interface to track personal items, I'd like to scan a barcode and see all the info pop up (easy enough). However I'd then like to be able to adjust the data.

Example, let's say I scan my tent and all the info pops up via Hlookup or Vlookup. I can see date purchased, price, brand, etc. but I also see a cell for last date used. I'd like to be able to click that cell and change that information without digging into the data table to change it. With the lookup functions that cell is only mirroring the data from the table. Is there a command/function or even a pre written macro for this?

Thanks!