Excel Macro

[tpmuser2]

Below is a sample of our payment register. Our check register prints the total of the check on the first line and then the account breakdown of the checks on the lines below. I need the check number and the Check Name to show up on every line of the account breakdown. I would like to create a macro that will copy the text from columns "A" and "B" and paste it to the rows below it that correspond to that particular check. I would like for the macro to continue copying the information until there are no more checks. This example has only three checks. Sometimes our payment registers have 50 checks or $100 checks. The number can vary. Can the macro continue to run until it detects no more checks in column "A"? A B C D E 1 Check Number Check Name Total Check Amount Account Split Amount per Account 2 100 Sears $500 3 845 $225 4 760 $275 5 200 Vons $2,500 6 260 $500 7 375 $1,400 8 460 $600 9 300 Best Buy $4000 10 720 $4,000 <tbody> </tbody> The final result should look like the table below: A B C D 1 Check # Check Name Total Check Account Split Amount per Account 2 100 Sears $500 3 100 Sears 845 $225 4 100 Sears 760 $275 5 200 Vons $2,500 6 200 Vons 260 $500 7 200 Vons 375 $1,400 8 200 Vons 460 $600 9 300 Best Buy $4000 10 300 Best Buy 720 $4,000 <tbody> </tbody> Thank you <tbody> </tbody>

<tbody>
</tbody>

 

[Fluff]

Hi & welcome to MrExcel
How about

Sub Filldown()
   With Range("A:B")
      .SpecialCells(xlBlanks).FormulaR1C1 = "=r[-1]c"
      .Value = .Value
   End With
      
End Sub

 

[tpmuser2]

I received the following error message:

Run time error '1004':
Unable to get the SpecialCells property the Range class

 

[Fluff]

Check that your "Blank" cells are actually blank.
=ISBLANK(A3)

 

[tpmuser2]

Thank you
The macro works

 

[Fluff]

You're welcome