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

New Member
Joined
Mar 19, 2019
Messages
2
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
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
74,658
Office Version
  1. 365
Platform
  1. Windows
Is this what you're after


Excel 2013/2016
AB
2Account1Account1
3Account11
4Account12
5Account13
6Account14
7Account15
8Account16
9Account2Account2
10Account21
11Account22
12Account23
13Account4Account4
14Account45
15Account46
16Account47
Sheet1
Cell Formulas
RangeFormula
A2=IF(LEFT(B2,7)="Account",B2,A1)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
74,658
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,826
Messages
5,855,868
Members
431,771
Latest member
CoryMelth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top