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

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



"Manky"

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-

Select column A and F5SpecialBlanksOK

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

Hit CTRL + ENTER


Gord Dibben MS Excel MVP


On Tue, 17 Mar 2009 15:10:09 -0700, Manky
wrote:


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

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

Regards,
Ryan---
--
RyGuy


"Gord Dibben" wrote:

Select column A and F5SpecialBlanksOK

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

Hit CTRL + ENTER


Gord Dibben MS Excel MVP


On Tue, 17 Mar 2009 15:10:09 -0700, Manky
wrote:


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