| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown Sheet
Good afternoon all, i am struggling to create a spreadsheet looking like this
below, this is an hierarchical dropdown, i know its not simple. Product Type Desc extra Clothes Dress Pants Long Regular Short Loose Skirt Pleated Causual Mini Party Sweater Longsleeves Black Short sleeves Red Blue Vegetable Lettuce x y I would appreciate this very much i have been looking at the Dalglish template and cant seem to be able to match this. Very much appreciated.... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown Sheet
If you're typing the data, one way is to just type it in the way you want.
But this doesn't look like a format that can be used very easily for other things. If I were doing it, I'd try to make my data look more like: Clothes DressPants Long Regular Clothes DressPants Short Loose Clothes Skirt Pleated Casual ..... One row with something in each column (if it applies to that row) whatzzup wrote: Good afternoon all, i am struggling to create a spreadsheet looking like this below, this is an hierarchical dropdown, i know its not simple. Product Type Desc extra Clothes Dress Pants Long Regular Short Loose Skirt Pleated Causual Mini Party Sweater Longsleeves Black Short sleeves Red Blue Vegetable Lettuce x y I would appreciate this very much i have been looking at the Dalglish template and cant seem to be able to match this. Very much appreciated.... -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown Sheet
Maybe this, similar to Dalglish instructions:
Make a copy of the data Choose F5 Special blanks press [=] followed by [Up Arrow] then [Enter] Select all data and copy and paste values Delete any rows you don't want to show "whatzzup" wrote: Good afternoon all, i am struggling to create a spreadsheet looking like this below, this is an hierarchical dropdown, i know its not simple. Product Type Desc extra Clothes Dress Pants Long Regular Short Loose Skirt Pleated Causual Mini Party Sweater Longsleeves Black Short sleeves Red Blue Vegetable Lettuce x y I would appreciate this very much i have been looking at the Dalglish template and cant seem to be able to match this. Very much appreciated.... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown Sheet
Hi Lori, thanks. I tried using the instruction but i ahve failed maybe i
misunderstand the command. I copy data,f5,special,blanks,ok, =, up arrow,enter, select all data, copy paste special values. I did all that so maybe i miss a step please can you put me right...thanks a lot "Lori" wrote: Maybe this, similar to Dalglish instructions: Make a copy of the data Choose F5 Special blanks press [=] followed by [Up Arrow] then [Enter] Select all data and copy and paste values Delete any rows you don't want to show "whatzzup" wrote: Good afternoon all, i am struggling to create a spreadsheet looking like this below, this is an hierarchical dropdown, i know its not simple. Product Type Desc extra Clothes Dress Pants Long Regular Short Loose Skirt Pleated Causual Mini Party Sweater Longsleeves Black Short sleeves Red Blue Vegetable Lettuce x y I would appreciate this very much i have been looking at the Dalglish template and cant seem to be able to match this. Very much appreciated.... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown Sheet
Are you trying to fill the empty cells with the value of the cell above it?
If yes: Select the range F5|Special|blanks|ok type = hit the up arrow key hit ctrl-enter (to fill all the blank cells with that formula) Now select all the range edit|copy Edit|paste special|values From your description, it looks like the copy data wasn't needed and you didn't hit ctrl-enter instead of enter when filling the empty cells. whatzzup wrote: Hi Lori, thanks. I tried using the instruction but i ahve failed maybe i misunderstand the command. I copy data,f5,special,blanks,ok, =, up arrow,enter, select all data, copy paste special values. I did all that so maybe i miss a step please can you put me right...thanks a lot "Lori" wrote: Maybe this, similar to Dalglish instructions: Make a copy of the data Choose F5 Special blanks press [=] followed by [Up Arrow] then [Enter] Select all data and copy and paste values Delete any rows you don't want to show "whatzzup" wrote: Good afternoon all, i am struggling to create a spreadsheet looking like this below, this is an hierarchical dropdown, i know its not simple. Product Type Desc extra Clothes Dress Pants Long Regular Short Loose Skirt Pleated Causual Mini Party Sweater Longsleeves Black Short sleeves Red Blue Vegetable Lettuce x y I would appreciate this very much i have been looking at the Dalglish template and cant seem to be able to match this. Very much appreciated.... -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown Sheet
Hi, Thanks again, that was kind of what i wanted to a point, but to only
display unique value and display it just as i show it in the original question. I have now done what you said but for example a2:a19 is populated with the same data "clothes" what i wanted was Clothes to be only displayed in a2. Same with "pants" only displayed in b4. So Dress, pants,skirt & blouse would be a selection from Clothes and say Pleated and Mini was a selection from Skirt. Think that can be done in excel? "Dave Peterson" wrote: Are you trying to fill the empty cells with the value of the cell above it? If yes: Select the range F5|Special|blanks|ok type = hit the up arrow key hit ctrl-enter (to fill all the blank cells with that formula) Now select all the range edit|copy Edit|paste special|values From your description, it looks like the copy data wasn't needed and you didn't hit ctrl-enter instead of enter when filling the empty cells. whatzzup wrote: Hi Lori, thanks. I tried using the instruction but i ahve failed maybe i misunderstand the command. I copy data,f5,special,blanks,ok, =, up arrow,enter, select all data, copy paste special values. I did all that so maybe i miss a step please can you put me right...thanks a lot "Lori" wrote: Maybe this, similar to Dalglish instructions: Make a copy of the data Choose F5 Special blanks press [=] followed by [Up Arrow] then [Enter] Select all data and copy and paste values Delete any rows you don't want to show "whatzzup" wrote: Good afternoon all, i am struggling to create a spreadsheet looking like this below, this is an hierarchical dropdown, i know its not simple. Product Type Desc extra Clothes Dress Pants Long Regular Short Loose Skirt Pleated Causual Mini Party Sweater Longsleeves Black Short sleeves Red Blue Vegetable Lettuce x y I would appreciate this very much i have been looking at the Dalglish template and cant seem to be able to match this. Very much appreciated.... -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown Sheet
I'd keep the data there, but I'd hide it using Format|Conditional formatting
See Debra Dalgleish's site for a method: http://contextures.com/xlCondFormat03.html#Duplicate whatzzup wrote: Hi, Thanks again, that was kind of what i wanted to a point, but to only display unique value and display it just as i show it in the original question. I have now done what you said but for example a2:a19 is populated with the same data "clothes" what i wanted was Clothes to be only displayed in a2. Same with "pants" only displayed in b4. So Dress, pants,skirt & blouse would be a selection from Clothes and say Pleated and Mini was a selection from Skirt. Think that can be done in excel? "Dave Peterson" wrote: Are you trying to fill the empty cells with the value of the cell above it? If yes: Select the range F5|Special|blanks|ok type = hit the up arrow key hit ctrl-enter (to fill all the blank cells with that formula) Now select all the range edit|copy Edit|paste special|values From your description, it looks like the copy data wasn't needed and you didn't hit ctrl-enter instead of enter when filling the empty cells. whatzzup wrote: Hi Lori, thanks. I tried using the instruction but i ahve failed maybe i misunderstand the command. I copy data,f5,special,blanks,ok, =, up arrow,enter, select all data, copy paste special values. I did all that so maybe i miss a step please can you put me right...thanks a lot "Lori" wrote: Maybe this, similar to Dalglish instructions: Make a copy of the data Choose F5 Special blanks press [=] followed by [Up Arrow] then [Enter] Select all data and copy and paste values Delete any rows you don't want to show "whatzzup" wrote: Good afternoon all, i am struggling to create a spreadsheet looking like this below, this is an hierarchical dropdown, i know its not simple. Product Type Desc extra Clothes Dress Pants Long Regular Short Loose Skirt Pleated Causual Mini Party Sweater Longsleeves Black Short sleeves Red Blue Vegetable Lettuce x y I would appreciate this very much i have been looking at the Dalglish template and cant seem to be able to match this. Very much appreciated.... -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation dropdown: works in one sheet, not in another | Excel Discussion (Misc queries) | |||
| populating DropDown with Values Of a Column in another Sheet. | Excel Discussion (Misc queries) | |||
| Jump to Sheet Dropdown List | Excel Worksheet Functions | |||
| adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) | |||
| dropdown value from range in other sheet | Excel Worksheet Functions | |||
Hybrid Mode
