Cell Referencing
Can you give some daa example it make it a lot easier to understand.
It sounds as if you want multiple vlookups.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.
"Bismark" wrote:
I am working on a workshheet that looks up values from a different worksheet
within same workbook, containing approx 1000 records which is used as a
database.
There is a field which requires updating on the database and I want to be
able to update it from my lookup sheet.
The cell to be updated has a constant column #(Say Column D ) but the row
number is variable based upon which record is being looked up at the time.
My ideal solution is a macro that will pick up the cells were I can manually
type the new value on the lookup sheet and place it into the database in
column "D" Row "...".
Any help will be greatly appreciated.
Regards,
Bismark
|