asked on

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.

B.
SaveProfilesToo.xlsm

Roy Cox

You haven't extended the Case) range. Is that what you wanted to do?

Are you trying to copy COG, etc figure?

Roy Cox

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.

ASKER CERTIFIED SOLUTION

Roy Cox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bright01

ASKER

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.

B.

Roy Cox

It's Sunday here, back to work tomorrow so I might not have as much time.