copy / paste -- vlookup combo ???
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? |
All times are GMT +1. The time now is 03:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com