Trying to fill in Worksheet blanks by copying down previous cells

So I've tried to work on this myself, but haven't gotten very far.

I have about a 18K line spreadsheet that is formatted similarly to the following:

Cust # Name Date Sales
Date Sales
Date Sales
Date Sales
Date Sales
Cus # Name Date Sales
Date Sales
Date Sales
Date Sales

So I want to copy down the the customer name and number to the blank cells in order to make the data actually usable. I've tried a number of formulas, but all of them require me to manually copy and paste the formulas in order to not copy over the other Customer names and numbers. Would this be more suitable for a VBA?

Any Ideas? I've attached a test spreadsheet below.

Originally Posted by Norie

Select columns A & B, goto Find & Select>Goto Special..., select Blanks.

Then in the formula bar enter =A1 and hit CTRL+ENTER.

Wow....That was easy. So what was the =A1 do combined with the control enter?

Again much appreciated...so how exactly does that work? I get that the by saying =A1 for the first customer will copy the data down, but does excel just see a pattern and apply the formula to all the cells in the range?