Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have weekly time broken down by category, however, only the total line has
the corresponding names. How do i fill the above cells with the corresponding name on the total line. For example(where blank insert last name on total line) Col A Col D blank wk27 blank wk28 blank wk29 blank wk30 Smith Total blank wk27 blank wk28 blank wk29 johnson Total thanks |
#2
![]() |
|||
|
|||
![]()
Try this:
1. Select the cells in column A 2. Press F5 3. Select 'Blanks' 4. Click OK 5. Type '=' (without the quotes) 6. Press the Down Arrow once 7. Press Control Enter now, in order to make those changes permanent, select the entire column, copy it, then go to Edit | Paste Special, and select 'Values'. -- Regards, Juan Pablo González Excel MVP "jerry" wrote in message ... I have weekly time broken down by category, however, only the total line has the corresponding names. How do i fill the above cells with the corresponding name on the total line. For example(where blank insert last name on total line) Col A Col D blank wk27 blank wk28 blank wk29 blank wk30 Smith Total blank wk27 blank wk28 blank wk29 johnson Total thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Does Excel support Auto fill on filtered data? | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
Auto fill option box disappeared | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) |