|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 02:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com