Roy Cox has helped me with constructing a WS that passes and maps data to another WS as a place to store and retrieve data. Most recently, I've begun to scale the original WS and have come across a slight problem. I have additional data in the original INPUT WS that is in another column that also needs to be mapped into the Data Table in the DATA_STORE WS. While I have tried to fix this myself, I cannot figure out how to appropriately map it in the VB code and thus I have also not properly modified the Range Name associated with the data on the INPUT WS.
Worksheet is attached.
Any assistance would be appreciated.