copy down a cell value in a different column with a specific text in until a new cell with the same specific text is seen then copy that down

[Blackpanfer]

Hi All,

I believe a macro is the only way to resolve this. I need to copy a cell with the text "Account" in column B and copy that in column A next to the numbers in column B until I reach the next cell with text "Account" in column B and then copy that cell down next to the numbers in column B, like you can see in the image from A6 to A8

Thanks

 

[Fluff]

Is this what you're after

Excel 2013/2016
	A	B
2	Account1	Account1
3	Account1	1
4	Account1	2
5	Account1	3
6	Account1	4
7	Account1	5
8	Account1	6
9	Account2	Account2
10	Account2	1
11	Account2	2
12	Account2	3
13	Account4	Account4
14	Account4	5
15	Account4	6
16	Account4	7
Sheet1

Cell Formulas
Range	Formula
A2	=IF(LEFT(B2,7)="Account",B2,A1)

 

[Blackpanfer]

That worked great. Thanks mate

 

[Fluff]

You're welcome & thanks for the feedback