Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mapping data on a world map | Excel Discussion (Misc queries) | |||
Mapping Data from one Excel file to Another | Excel Discussion (Misc queries) | |||
Mapping Geographic Data | Charts and Charting in Excel | |||
Mapping Data from One worksheet to Another | Excel Discussion (Misc queries) | |||
how do i design/ implement a spread sheet to input live data | Excel Programming |