Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex look up/colum filter
I'm trying to set up a sort of filter so that I can pull information from one
main page. Room 1 Room 2 Room 3 Room 4 Chair 1 2 1 Table 1 2 1 Stool 1 The main data sheet looks (sort of ) like the above with individual products down the left and their locations across the top. In reality there are hundreds of products and hundreds of locations. I want to have a formula/macro which looks up the word 'chair' for example, then returns me the quantity with the corresponding heading (location), but I need it to skip the blanks. I.e. If I ask it to look up 'Chair', the following is displayed Room 1 Room 2 Room 3 Chair 1 2 1 If I asked it look up 'Stool' it would display Room 3 Stool 1 Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex look up/colum filter
Hello!
Sub filtre() Cells.EntireColumn.Hidden = False Range("_FilterDataBase").SpecialCells(xlCellTypeVi sible).SpecialCells(xlCellTypeBlanks).EntireColumn .Hidden = True End Sub Sub tout() Cells.EntireColumn.Hidden = False End Sub http://cjoint.com/?jdpFeVOqBD JB http://boisgontierjacques.free.fr/ On 3 sep, 13:16, raphiel2063 wrote: I'm trying to set up a sort of filter so that I can pull information from one main page. Room 1 Room 2 Room 3 Room 4 Chair 1 2 1 Table 1 2 1 Stool 1 The main data sheet looks (sort of ) like the above with individual products down the left and their locations across the top. In reality there are hundreds of products and hundreds of locations. I want to have a formula/macro which looks up the word 'chair' for example, then returns me the quantity with the corresponding heading (location), but I need it to skip the blanks. I.e. If I ask it to look up 'Chair', the following is displayed Room 1 Room 2 Room 3 Chair 1 2 1 If I asked it look up 'Stool' it would display Room 3 Stool 1 Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex look up/colum filter
I've posted one formulas play in .worksheet.functions.
Pl do not multi-post. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
colum 1 = product #'s than colum 2 = prod. disc. | Excel Discussion (Misc queries) | |||
Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) |