Hi everyone,

I have an excel macro that I think is pretty complicated for a newb like me, so I was hoping for some help/guidance

I have 2 sheets:
(1) Carrier - Current Location (attached)
(2) Carrier Specific

Here is what I'm hoping the macro will accomplish:
1) Copy the sheet called Carrier Specific
2) Name the new sheet based on the value in Carrier - Current Location (starting at C4)
3) Input that same value into cell D1 of the new sheet
4) Go down the list in Carrier - Current Location and create new sheets like this until it hits a 0 value

Ex. Carrier - Current Location C4 = CKUO
--I want this to copy Carrier Specific, re-name is CKUO, and input "CKUO" into cell D1 of the new sheet called CKUO
--Then repeat this for every item in the list until it hits a value of 0

I attached my spreadsheet to this as well, please let me know if you can help me out / lead me in the correct direction!
(It's a smaller version of my real workbook, so there's a bunch of REF errors)

Thanks so much!!