Let's say I have a table like the following:
Worksheet1
----------
Table1:
Column1 .... Column15 Column16
Serial Number .... Value1 Value2
Now on some other worksheets, I'll have data like the following:
Column1 Column2 Column3
Serial Number Value1 Value2
I'd like to come up with a macro that on one of those random worksheets, when I have the Serial Number highlighted, it would go to WORKSHEET1 and update Column15 and Column16 with the data from the Column2 and Column3 from the worksheet that the macro was initiated from.
I can't use a Vlookup on WORKSHEET1 because different Serial Numbers get their data from different sheets.
I need to do something like an update query in Access.
Any ideas guys?
Steve
Worksheet1
----------
Table1:
Column1 .... Column15 Column16
Serial Number .... Value1 Value2
Now on some other worksheets, I'll have data like the following:
Column1 Column2 Column3
Serial Number Value1 Value2
I'd like to come up with a macro that on one of those random worksheets, when I have the Serial Number highlighted, it would go to WORKSHEET1 and update Column15 and Column16 with the data from the Column2 and Column3 from the worksheet that the macro was initiated from.
I can't use a Vlookup on WORKSHEET1 because different Serial Numbers get their data from different sheets.
I need to do something like an update query in Access.
Any ideas guys?
Steve