Fill in of cells excel 2007

[Manky]

I have a database that has only the user id field on the 1st record and i
need to fill in the user id on the subsequent records. until it hits the next
User ID, in the following example i need user ID 100 to be copied into the
next 2 rows

user id name code Amt
100 Wayne A 20
C 12.5
X 9
104 Doe A 19
H 11
200 wright A 15
206 Jones B 7
x 10
400 Marsh D 5

 

[Jim Cone]

Here is an easy way from John Walkenbach...
http://spreadsheetpage.com/index.php/tip/duplicate_repeated_entries_in_a_list/
--
Jim Cone
Portland, Oregon USA



"Manky"
<[email protected]>
wrote in message

I have a database that has only the user id field on the 1st record and i
need to fill in the user id on the subsequent records. until it hits the next
User ID, in the following example i need user ID 100 to be copied into the
next 2 rows
-snip-

 

[Gord Dibben]

Select column A and F5>Special>Blanks>OK

Type an = sign in active blank cell then point or arrow to cell above.

Hit CTRL + ENTER


Gord Dibben MS Excel MVP

 

[ryguy7272]

One more for good measure:
http://www.contextures.com/xlDataEntry02.html

Regards,
Ryan---