Best Way to Implement Data Mapping?
 

What is the best way to data map? I need to do it all in VB...
Sheet1 columns: key1, data1 (this is data produced weekly by 3r
party)
Sheet2 columns: key1, key2 (this is hardcoded)
Sheet3 columns: key2, data (blank, but the order of key2 cannot b
changed)

so i am copying data from Sheet1 to Sheet3.
i need to take key1 from sheet1, figure out it's mapped key2 fro
sheet2, then using that key, enter the data into the correct place i
Sheet3.

I could use a gigantic Case Select but was wondering if there is a
"pretty" solution?? specific code please.. someone said there ar
class objects in Excel but i am not aware of the syntax at al
(links?). thanks.

;

--
UofMo
-----------------------------------------------------------------------
UofMoo's Profile: http://www.excelforum.com/member.php...fo&userid=2648
View this thread: http://www.excelforum.com/showthread.php?threadid=39752