Posted to microsoft.public.excel.programming
|
|
Fill in of cells excel 2007
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
|