| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
About filter
Hello,
I have the following question: If I want to fill a different sheet using the information on Sheet 1 as source. For example on Sheet 2, I want to select from a list, apples on column A and automatically on column B I want to select also from drop down list only the information asociated to apples, like box z, and Column C only information asociated to apples, using box w. Sheet1 A B C D apples box z 25 units labeled PF apples box z 50 units labeled PF apples box w 50 units labeled TR lemmons box y 100 units labeled LM lemmons box y 100 units labeled LM grapes box x 200 units labeled GR grapes box x 250 units labeled GR grapes box x 300 units labeled GR How can I do it? Thanks JP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
About filter
Data Filter Autofilter........select the dropdown arrows and choices on
your columns of interest..... Vaya con Dios, Chuck, CABGx3 "juanpablo" wrote: Hello, I have the following question: If I want to fill a different sheet using the information on Sheet 1 as source. For example on Sheet 2, I want to select from a list, apples on column A and automatically on column B I want to select also from drop down list only the information asociated to apples, like box z, and Column C only information asociated to apples, using box w. Sheet1 A B C D apples box z 25 units labeled PF apples box z 50 units labeled PF apples box w 50 units labeled TR lemmons box y 100 units labeled LM lemmons box y 100 units labeled LM grapes box x 200 units labeled GR grapes box x 250 units labeled GR grapes box x 300 units labeled GR How can I do it? Thanks JP |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
About filter
Sorry, forgot to mention that when you are finished viewing the filtered data
you can do Data Filter Autofilter again and it will return everything to normal.....like a toggle....... Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Data Filter Autofilter........select the dropdown arrows and choices on your columns of interest..... Vaya con Dios, Chuck, CABGx3 "juanpablo" wrote: Hello, I have the following question: If I want to fill a different sheet using the information on Sheet 1 as source. For example on Sheet 2, I want to select from a list, apples on column A and automatically on column B I want to select also from drop down list only the information asociated to apples, like box z, and Column C only information asociated to apples, using box w. Sheet1 A B C D apples box z 25 units labeled PF apples box z 50 units labeled PF apples box w 50 units labeled TR lemmons box y 100 units labeled LM lemmons box y 100 units labeled LM grapes box x 200 units labeled GR grapes box x 250 units labeled GR grapes box x 300 units labeled GR How can I do it? Thanks JP |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
About filter
I'm not really sure what you are after, but 'Auto Filter' works well for the
sample you have given. You may also want to consider using a 'pivot table.' Pivot tables are a good way to analyze data and select specific records from a large group. -- T Tipsy "juanpablo" wrote: Hello, I have the following question: If I want to fill a different sheet using the information on Sheet 1 as source. For example on Sheet 2, I want to select from a list, apples on column A and automatically on column B I want to select also from drop down list only the information asociated to apples, like box z, and Column C only information asociated to apples, using box w. Sheet1 A B C D apples box z 25 units labeled PF apples box z 50 units labeled PF apples box w 50 units labeled TR lemmons box y 100 units labeled LM lemmons box y 100 units labeled LM grapes box x 200 units labeled GR grapes box x 250 units labeled GR grapes box x 300 units labeled GR How can I do it? Thanks JP |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
About filter
Yes, but the filter would go on sheet 2, and the data is on sheet 1, how do i
proceed? "CLR" wrote: Sorry, forgot to mention that when you are finished viewing the filtered data you can do Data Filter Autofilter again and it will return everything to normal.....like a toggle....... Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Data Filter Autofilter........select the dropdown arrows and choices on your columns of interest..... Vaya con Dios, Chuck, CABGx3 "juanpablo" wrote: Hello, I have the following question: If I want to fill a different sheet using the information on Sheet 1 as source. For example on Sheet 2, I want to select from a list, apples on column A and automatically on column B I want to select also from drop down list only the information asociated to apples, like box z, and Column C only information asociated to apples, using box w. Sheet1 A B C D apples box z 25 units labeled PF apples box z 50 units labeled PF apples box w 50 units labeled TR lemmons box y 100 units labeled LM lemmons box y 100 units labeled LM grapes box x 200 units labeled GR grapes box x 250 units labeled GR grapes box x 300 units labeled GR How can I do it? Thanks JP |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
About filter
Use copy an paste, filter on sheet1 and then copy and paste to sheet2
-- Regards, Peo Sjoblom "juanpablo" wrote in message ... Yes, but the filter would go on sheet 2, and the data is on sheet 1, how do i proceed? "CLR" wrote: Sorry, forgot to mention that when you are finished viewing the filtered data you can do Data Filter Autofilter again and it will return everything to normal.....like a toggle....... Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Data Filter Autofilter........select the dropdown arrows and choices on your columns of interest..... Vaya con Dios, Chuck, CABGx3 "juanpablo" wrote: Hello, I have the following question: If I want to fill a different sheet using the information on Sheet 1 as source. For example on Sheet 2, I want to select from a list, apples on column A and automatically on column B I want to select also from drop down list only the information asociated to apples, like box z, and Column C only information asociated to apples, using box w. Sheet1 A B C D apples box z 25 units labeled PF apples box z 50 units labeled PF apples box w 50 units labeled TR lemmons box y 100 units labeled LM lemmons box y 100 units labeled LM grapes box x 200 units labeled GR grapes box x 250 units labeled GR grapes box x 300 units labeled GR How can I do it? Thanks JP |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
About filter
But on Sheet 2 I dont want to have all the information displayed,
Sheet 2 should look like this A B C D fruit packing qty label and from below the fields, a drop down to select. JP "Peo Sjoblom" wrote: Use copy an paste, filter on sheet1 and then copy and paste to sheet2 -- Regards, Peo Sjoblom "juanpablo" wrote in message ... Yes, but the filter would go on sheet 2, and the data is on sheet 1, how do i proceed? "CLR" wrote: Sorry, forgot to mention that when you are finished viewing the filtered data you can do Data Filter Autofilter again and it will return everything to normal.....like a toggle....... Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Data Filter Autofilter........select the dropdown arrows and choices on your columns of interest..... Vaya con Dios, Chuck, CABGx3 "juanpablo" wrote: Hello, I have the following question: If I want to fill a different sheet using the information on Sheet 1 as source. For example on Sheet 2, I want to select from a list, apples on column A and automatically on column B I want to select also from drop down list only the information asociated to apples, like box z, and Column C only information asociated to apples, using box w. Sheet1 A B C D apples box z 25 units labeled PF apples box z 50 units labeled PF apples box w 50 units labeled TR lemmons box y 100 units labeled LM lemmons box y 100 units labeled LM grapes box x 200 units labeled GR grapes box x 250 units labeled GR grapes box x 300 units labeled GR How can I do it? Thanks JP |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
About filter
Hi,
The autofilter wont work, what I want to do is on sheet numer two, select a cell and from a drop down list, choose the desired items. Will work a query with ODBC? "Terry Tipsy" wrote: I'm not really sure what you are after, but 'Auto Filter' works well for the sample you have given. You may also want to consider using a 'pivot table.' Pivot tables are a good way to analyze data and select specific records from a large group. -- T Tipsy "juanpablo" wrote: Hello, I have the following question: If I want to fill a different sheet using the information on Sheet 1 as source. For example on Sheet 2, I want to select from a list, apples on column A and automatically on column B I want to select also from drop down list only the information asociated to apples, like box z, and Column C only information asociated to apples, using box w. Sheet1 A B C D apples box z 25 units labeled PF apples box z 50 units labeled PF apples box w 50 units labeled TR lemmons box y 100 units labeled LM lemmons box y 100 units labeled LM grapes box x 200 units labeled GR grapes box x 250 units labeled GR grapes box x 300 units labeled GR How can I do it? Thanks JP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
| How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Linear Mode
