Move data from specific cell to other cells within that group in the adjacent column

Hi everyone,

Hoping someone can help me with this.

In my file the name of every person is in the cell right below the cell with "(Unaudited)" (See column A below). What I'd like to do is to add the name of the person in all cells up to the next "(Unaudited)" in column B (see column B below). I don't think there's a formula for this, but maybe with VBA this is possible? I'm attaching the file with the current and desired tabs also if it helps.

Capture excel.JPG

Thanks in advance!

Hi Maras,

Thanks for the response. I see you conditioned it to the "name", but it's always going to be a different person's name, and won't have the actual word "name" in there. So I can't tie the formula to that. I just know that the name will always be below the "Unaudited"

Thanks Mara. Last question and sorry as I know it's my fault for not being clear. All the data in the file is just for example purposes. The only thing that will always appear is "Unaudited", but Name 1, Name 2, etc will be an actual name and A1, A2, B1, B2... will be actual text which is always different.. It won't say "A1" or "A2" specifically.. It's confidential data so I just added those as examples. Is there a way to have this formula still work?

This works great! Thank you so much for the help!

Great formula maras