Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jerry
 
Posts: n/a
Default Auto fill multiple sections with different names

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   Report Post  
Juan Pablo González
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Does Excel support Auto fill on filtered data? Maria Excel Discussion (Misc queries) 1 August 26th 05 02:45 PM
Auto Fill Options adarling Excel Discussion (Misc queries) 1 April 8th 05 04:09 AM
Auto fill option box disappeared sbrimley Excel Worksheet Functions 5 February 4th 05 04:21 AM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 05:45 AM
Auto Fill Options Patti B Excel Discussion (Misc queries) 3 December 9th 04 01:49 AM


All times are GMT +1. The time now is 12:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"