| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting rows to another sheet
I have an excel sheet that has lists of categories and several selections for
each. I use a Filter to select only the rows with a "X" in column J. I want the selections made to also automatically appear on the next sheet which is like a spec/ selection sheet. in the location I choose. Is there a way that if I use a IF function to say in a cell on sheet 2, IF J1-J5 is "X", than only that row with a "X" appears in sheet 2? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting All Rows with Certain Data | Excel Discussion (Misc queries) | |||
| Selecting All Rows with Certain Data | Excel Discussion (Misc queries) | |||
| after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
| Selecting alternate rows | Excel Discussion (Misc queries) | |||
| Selecting Rows | Excel Worksheet Functions | |||
Threaded Mode
