Fill in of cells excel 2007

M

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top