| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter 2 columns onto Sheet 2!!
Hi All.
I have a file which contains 2 sheets. Sheet 1 holds all my info an Sheet 2 holds selected info from Sheet 1. At the moment, i am using the Data|Filter|AdvanceFilter option to cop a column from Sheet 1 to Sheet 2. I was wondering if it is possible to use this feature to copy tw columns together from sheet 1 to sheet 2. For example, if i needed to copy infromation from Columns A and D(bot down to Row 20), how can i go about doing this without having to do th Data|Filter|Advance Filter option twice? Is this possible? Would i need to record a macro? Any help is very much appreciate -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter rows on sheet 2 when a certain option is chosen on sheet 1 | Excel Worksheet Functions | |||
| Particulars data Filter from sheet 1 to sheet 2 automatically | Excel Worksheet Functions | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| Filter Range on Sheet B Based on List on Sheet A | Excel Discussion (Misc queries) | |||
| 'Copy to' Advance Filter depend only on sheet ID not start sheet | Excel Worksheet Functions | |||
![sparky3883[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
