Is there a way to paste a copied cell to a cell that may change location, but
the cell to the left of the will always have the same value. I have a DB
that will shift cells down as a new entry is added. If I need to edit a
record in the DB from another sheet and use a macro to update the new
information.

is there a way to do a "reverse vlookup"? basically find the item and paste
the new data in the cell to the right of it?