Copy ranges of cells using names from the Name Manager - Macro Needed

Please see the attached spread sheet. Is it possible to have a macro that can use the list on the sheet "Items List" and match what it finds to a "Name" in excels Name Manager (this would select the range of cells I am needing) then run the macro "Copy_to_Takeoff" then go to the next item in the list and do the same, and so on, and so on until there is nothing left in the list?
This would give me the ability to create any list I need and only run one macro.

Step one: Open Sheet "Items List"
Step Two: Use Cell B3 to match to a Name in Excels Name Manager
Step Three: Run the macro "Copy_to_Takeoff"

Step Four: Repeat Step one
Step Five: Use Cell B4 to match to a Name in Excels Name Manager
Step Six: Repeat Step Three

and so on and so on...

Thanks in advance to anyone willing to help. This will be a huge time saver for me.

Try this.

I use an array to stop going back to the list of named ranges.

Please Login or Register  to view this content.

Wow, that worked great! Thank you. Since I have your attention can you help me with one more thing? Is there a way to insert that underscore in front of those numbers in the list either through some excel function or macro? The reason I ask is I want to just be able to type those numbers and then add the underscore after. Maybe this is worth another thread, just let me know.

Try this.

I added one line of code. Modify it if it isn't exactly what you need.

Presently it inserts an underscore at the start of the name if it isn't already an underscore.

Please Login or Register  to view this content.

Thanks again. I am getting a run time error I think due to the decimal places. When there is a zero at the end it is dropped when the underscore is added. Any way to fix that?