The caveats on the data regularity were there as stated for the suggestions
to work. (Never said I had a solution otherwise)

Here's what I did in your sample (File returned to you)

Inserted a new col A
Placed in the "new" A1: =IF(C1="Cost Center:",E1+0,"")
Copied down to A11986 (the last data row)

Col A pulled in the 4 digit numbers from col E
where the marker phrase: "Cost Center:" appeared in col C

Killed the formulas in col A
(via an in-place copy paste special values ok)

Inserted a new row1
Typed a label into A1
Did a Data Filter Autofilter on col A
Selected (Blanks) from the droplist in A1
Selected the filtered range A3:A11987 (blue row headers)
Right-clicked on the selection Clear Contents
Removed the autofilter

Raided Debra's page on: Excel -- Data Entry -- Fill Blank Cells
at: http://www.contextures.com/xlDataEntry02.html

Under the section "Fill Blank Cells Programmatically"
(scroll down a bit in the page)
Copied and implemented Dave Peterson's
Sub FillColBlanks() into the book

Selected A2:A11987
Ran Dave's Sub FillColBlanks() on the selected range

(Think that's it. I'm out of ideas)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ecohen1" wrote in
message ...

Thanks you so much for your help, and again for your file, but again it
doesn't work for me. I don't have exactly 20 rows for each center, I
could have 20 for one cost center and 50 for example for the next one.

I'm sending you the excel file by Email, you gona see excatly the
sheet.

Thanks again, I really appreciate your help.


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile:
http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=388070