Troubleshooting a Macro and Range Name for fixing a Data Store Macro

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.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
You haven't extended the Case) range. Is that what you wanted to do?

Are you trying to copy COG, etc figure?
Roy CoxGroup Finance ManagerCommented:
I think I see the problem.

You've changed the case_Initial to include the percentages. You cannot copy and paste that range to one column, because it is not sourced from the same column.

I've added another named range. I need to change the code  now.
Roy CoxGroup Finance ManagerCommented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bright01Author Commented:
Roy, Spot On!  We're getting really good working together on these improvements.  Now I'm going to scale this out to be multi-Year using the code you sent me.

I'll post something else tonight.

Thank you for some great work!

Have a great Saturday.

Roy CoxGroup Finance ManagerCommented:
It's Sunday here, back to work tomorrow so I might not have as much time.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.