I need help.. A function that uses one column to find the values in another column, to then find the corresponding headers in two other sheets...

spyrule

Board Regular
Joined
Aug 21, 2015
Messages
114
Hello,

I'm tripping over my brain on this one...

I'll pain(t) the situation:

a workbook with 9+ worksheets. One is used for Reference Data, another holds Data from an online source (that I cannot control the headers location and format), and then another sheet that is effectively an aggregate copy of this online source data (I actually have multiple different sources, so that is why I'm trying to make this a re-usable function).

I've created a bunch of other functions that I think should support this final "piece" of work. I just need help with this last piece.

In the Reference Data sheet (Called RefData), I have several columns that are transpositions of the headers from the other worksheets. They are called "MainData_ColNames", "OnlineSrc1" and "OnlineSrc2". The MainData_ColNames stores all of the existing column names that WONT change location. I then have transposed the headers from Online Source 1 and 2 respectively, and removed the Headers that don't have a corresponding "destination" in the MainData worksheet.

I need to step through each OnlineSrc column, and if a cell has a value, Record that value, and then lookup the matching value by row in the MainData_ColNames column, and then record that matching headername into a value. Once I have that working, copying the data and whatnot I actually have working.

I've created a bunch of code that takes care of most of what I need it to do, but I'm trying to make it one-step further dynamically speaking.

Here is a sample worksheet with that I'm talking about (this should help clear up a lot of what I'm trying to do)...

https://www.dropbox.com/s/nrxadfm4f1e9q0z/Testing.zip?dl=0

The password to the .zip file is "mrexcel" (I have triple scanned this file for any virus's/trojans, should be clean).

Thanks very much in advance.

-Spyrule.
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top