Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter in EXCEL 2007
hi all,
as in excel 2003 while using auto filter in a particular column we get the drop down list box and the user has the choice of selecting and one from teh whole list, but in excel 2007 while using auto filter option we get the drop down list box with a checkbox prior to it allowing the user to select multiple rows in the filter. can the auto filter in teh excel 2007 can be modiifed to display teh data as in the form of excel 2003 (ie without the check boxes in front of the list) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter in EXCEL 2007
Not that I know of... which doesn't mean there isn't one... however, just
FYI, when you first open the list, while everything is still checked, clicking the select all option will uncheck everything - making it easier to select the one you want instead of having to uncheck all the ones you don't. "Pramod Mehta" wrote: hi all, as in excel 2003 while using auto filter in a particular column we get the drop down list box and the user has the choice of selecting and one from teh whole list, but in excel 2007 while using auto filter option we get the drop down list box with a checkbox prior to it allowing the user to select multiple rows in the filter. can the auto filter in teh excel 2007 can be modiifed to display teh data as in the form of excel 2003 (ie without the check boxes in front of the list) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter in EXCEL 2007
hi boni,nick
thanks for the help.. but i have a bit different problem.. when the user selects two items from the list of the dropdownlist box say (item1 and item4) and selects the colums with all the for those two selections and press ctrl+c and opens a new work sheet and presses ctrl+v.. i want only those rows to be copied which matches the autofilter criteria.... one way is to do it with f5-special-visible cells only then ctrl+c and then ctrl+v.. but i want that to be done in VBA code.... waiting 4 u replies.. and one more thing .. is there any way we can restrict the user from copying anything from the excel.. i.e to disable ctrl+c option... "Pramod Mehta" wrote: hi all, as in excel 2003 while using auto filter in a particular column we get the drop down list box and the user has the choice of selecting and one from teh whole list, but in excel 2007 while using auto filter option we get the drop down list box with a checkbox prior to it allowing the user to select multiple rows in the filter. can the auto filter in teh excel 2007 can be modiifed to display teh data as in the form of excel 2003 (ie without the check boxes in front of the list) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter in EXCEL 2007
Hi
If you want to copy the filtered rows, just select the visible range of rows by marking the row number, then copy and paste. If you want to do it by macro, then just switch on the macro recorder as you carry out the task. This is what was created for me when I did it. I had already created a Table called MyData in XL2007, by going to the Insert TabTable Then under the Table ToolsDesign tabfar left Propertiesenter MyData in the Table Name pane. I selected 2 customers, called Smith and Jones, from the second dropdown filter on column B Sub CopyFilteredRows() ActiveSheet.ListObjects("MyData").Range.AutoFilter Field:=2, Criteria1 _ :="=Smith", Operator:=xlOr, Criteria2:="=Jones" Rows("4:300").Select Selection.Copy Sheets("Sheet2").Select Range("A4").Select ActiveSheet.Paste End Sub -- Regards Roger Govier "Pramod Mehta" <Pramod wrote in message ... hi boni,nick thanks for the help.. but i have a bit different problem.. when the user selects two items from the list of the dropdownlist box say (item1 and item4) and selects the colums with all the for those two selections and press ctrl+c and opens a new work sheet and presses ctrl+v.. i want only those rows to be copied which matches the autofilter criteria.... one way is to do it with f5-special-visible cells only then ctrl+c and then ctrl+v.. but i want that to be done in VBA code.... waiting 4 u replies.. and one more thing .. is there any way we can restrict the user from copying anything from the excel.. i.e to disable ctrl+c option... "Pramod Mehta" wrote: hi all, as in excel 2003 while using auto filter in a particular column we get the drop down list box and the user has the choice of selecting and one from teh whole list, but in excel 2007 while using auto filter option we get the drop down list box with a checkbox prior to it allowing the user to select multiple rows in the filter. can the auto filter in teh excel 2007 can be modiifed to display teh data as in the form of excel 2003 (ie without the check boxes in front of the list) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Filter in Column | Excel Worksheet Functions | |||
Excel 2007 (Beta) Auto Filter | Excel Worksheet Functions | |||
filter options in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Beta Advanced Filter Performance | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |