| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto fill text columns based on rows
I'm trying to fill in Column A based on the info. listed in the first row for
a section. For example, column A would list Store 1 until it hit Store 2 and then repeat until the next section. Any ideas on how to do this?? Thanks!!! Column A Column B Store Detail Competitors Store 1 Store 1 Detail Comp 1 Store 1 Detail Comp 2 Store 1 Detail Comp 3 Store 1 Detail Comp 4 Store 4 Store 4 Detail Comp 1 Store 4 Detail Comp 2 Store 4 Detail Comp 3 Store 4 Detail Comp 4 Store 4 Detail Comp 5 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto fill text columns based on rows
Select column A then F5SpecialBlanksOK
Type an = sign in active blank cell then point or arrow up to cell above. Hit CTRL + ENTER With column still selected, copy and in place, paste specialvaluesokesc. Gord Dibben MS Excel MVP On Mon, 29 Mar 2010 11:46:02 -0700, Cecilia wrote: I'm trying to fill in Column A based on the info. listed in the first row for a section. For example, column A would list Store 1 until it hit Store 2 and then repeat until the next section. Any ideas on how to do this?? Thanks!!! Column A Column B Store Detail Competitors Store 1 Store 1 Detail Comp 1 Store 1 Detail Comp 2 Store 1 Detail Comp 3 Store 1 Detail Comp 4 Store 4 Store 4 Detail Comp 1 Store 4 Detail Comp 2 Store 4 Detail Comp 3 Store 4 Detail Comp 4 Store 4 Detail Comp 5 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto fill text columns based on rows
That worked!! thanks so much
"Gord Dibben" wrote: Select column A then F5SpecialBlanksOK Type an = sign in active blank cell then point or arrow up to cell above. Hit CTRL + ENTER With column still selected, copy and in place, paste specialvaluesokesc. Gord Dibben MS Excel MVP On Mon, 29 Mar 2010 11:46:02 -0700, Cecilia wrote: I'm trying to fill in Column A based on the info. listed in the first row for a section. For example, column A would list Store 1 until it hit Store 2 and then repeat until the next section. Any ideas on how to do this?? Thanks!!! Column A Column B Store Detail Competitors Store 1 Store 1 Detail Comp 1 Store 1 Detail Comp 2 Store 1 Detail Comp 3 Store 1 Detail Comp 4 Store 4 Store 4 Detail Comp 1 Store 4 Detail Comp 2 Store 4 Detail Comp 3 Store 4 Detail Comp 4 Store 4 Detail Comp 5 . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto fill text columns based on rows
Happy to help
Thanks for the feedback On Mon, 29 Mar 2010 14:12:02 -0700, Cecilia wrote: That worked!! thanks so much "Gord Dibben" wrote: Select column A then F5SpecialBlanksOK Type an = sign in active blank cell then point or arrow up to cell above. Hit CTRL + ENTER With column still selected, copy and in place, paste specialvaluesokesc. Gord Dibben MS Excel MVP On Mon, 29 Mar 2010 11:46:02 -0700, Cecilia wrote: I'm trying to fill in Column A based on the info. listed in the first row for a section. For example, column A would list Store 1 until it hit Store 2 and then repeat until the next section. Any ideas on how to do this?? Thanks!!! Column A Column B Store Detail Competitors Store 1 Store 1 Detail Comp 1 Store 1 Detail Comp 2 Store 1 Detail Comp 3 Store 1 Detail Comp 4 Store 4 Store 4 Detail Comp 1 Store 4 Detail Comp 2 Store 4 Detail Comp 3 Store 4 Detail Comp 4 Store 4 Detail Comp 5 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-Fill Column based on data in each row | Excel Worksheet Functions | |||
| auto fill rows with months based on cell value | Excel Discussion (Misc queries) | |||
| auto fill columns based on a selection | Excel Discussion (Misc queries) | |||
| Auto fill Column based on data in other columns | New Users to Excel | |||
| How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) | |||
Linear Mode
