Thanks, georgiboy.

The challenge is, I want the name range to be whatever is in D3 on the Task Entry tab, but each time they put a new task in D3, it would create a new named range.

Say you're on the Task Entry tab and you enter "Bake Cookies" in D3 and it fills in subsequent tasks automatically below (the point of the Task Entry tab is to save time with known subsequent tasks). You hit the button and it puts "Bake Cookies" in cell D4 on the Task List followed by the subsequent tasks. All this works, but where I need help is: I want D4 on the Task List tab to show up in the name box as "Bake_Cookies".

So then you go back to the Entry Form and enter "Measure Cupcakes" in D3 and it fills in all subsequent tasks for measuring cupcakes. You hit the button, and the spreadsheet finds the next empty row, skips it (so there's a space between tasks) and places Measure Cupcakes in cell D12 (again, all this works), and then creates named cell D12 on the Task List tab as "Measure_Cupcakes".

So in my Name Box, if I hit "Bake_Cookies" it goes to D4, if I click on "Measure_Cupcakes" it goes to D12.

So for each task you enter, it creates the named range for that task. Again, this could happen dozens of times, if not hundreds of times, for a project.

I have everything working in regards to transferring the data, all that works. I'm just not sure how to 1) get excel to create a new name range each time a new task is entered. 2) how to call out that named range on the Task List tab, even though it's pulling data from the Entry Tab (that's why I'm trying to add it where I'm trying to add it ... because it's pulling D3 "InstalDesc" and adding the word "Summary" to the end of it... so I'm trying to tell it to take that same cell and add it to the Name Range). 3) How to get rid of the spaces so the Named Range can actually work, but not get rid of the spaces when it pastes the value into the Task List.

Again, as I said, I'm in way over my head here... this may not even be possible. What I have in my code may be not even be close to what I need to get this to work, it's just where I'm at.

I have found plenty of articles showing me how VBA can USE named cells, but not many on how to create them. The few that showed how to create them were static in what they were showing (i.e., change XYZ cell to "this set variable"), but I'm looking for something more dynamic where it CREATES the named cell for EACH task as they enter it.

Thanks for your time though. I do really appreciate it.