Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill in of cells excel 2007
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill in of cells excel 2007
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- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill in of cells excel 2007
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 |
#4
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 auto fill help | Excel Discussion (Misc queries) | |||
Excel 2007 Fill Problem | Excel Discussion (Misc queries) | |||
Fill Handle in Excel 2007 | Excel Discussion (Misc queries) | |||
formula fill adjacent cells 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - selected cells shading (not fill) | Setting up and Configuration of Excel |