Updating data using a macro

[Guest]

A worksheet contains a large amount of data, part numbers, descriptions, price, etc. I am trying to build a separate worksheet to look up, display and update the information for a given part number. Looking up and displaying the information for a given part number hasn't been a problem (VLOOKUP). However, modifying the information and then saving the changes in the original list has been problematic. I can't find a way to copy and paste the data in the correct row in the original list. GOTO would work if I could use the contents of a cell as the reference, but I can't figure out how to do that. Any suggestions?

 

[Anders S]

Using worksheet functions in the macro, one way is to use MATCH() and INDEX() to
get the reference to the cells in the original list. You may try MATCH() and
INDEX() on the worksheet first to get the hang of it.

HTH
Anders Silven

A worksheet contains a large amount of data, part numbers, descriptions,

price, etc. I am trying to build a separate worksheet to look up, display and
update the information for a given part number. Looking up and displaying the
information for a given part number hasn't been a problem (VLOOKUP). However,
modifying the information and then saving the changes in the original list has
been problematic. I can't find a way to copy and paste the data in the correct
row in the original list. GOTO would work if I could use the contents of a cell
as the reference, but I can't figure out how to do that. Any suggestions?

 

[Guest]

Thanks, I'll give it a try.