Need Macro to Select All Files in a Column After Filter Applied

**Gard5096** · 09-10-2012, 03:01 PM

I am recording a macro to filter some data and then select the data in the column after filtering. When I record it and select the data, it gives specific coordinates in the coding rather than selecting all visible rows after the filter.

This is a problem because the filter will result in different rows each day, so the coordinates will not be the same as when I recorded it.

Example: I filter a column to show anything containing values of {19,20,21,22,23,24}. Rows 2 and 3 do not fit this criteria, so they are removed...therefore when I select the column to copy (excluding the title row), it starts specifically with row 4.

Please let me know if you need clarification on anything.

The help is much appreciated.

**JOHN H. DAVIS** · 09-10-2012, 03:54 PM

Does this help?

Please Login or Register  to view this content.

**Gard5096** · 09-10-2012, 05:03 PM

It is giving me an error for this part.

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 09-11-2012, 07:04 AM

What is the name of the sheet you are copying it too? I just used "Destination" as an example.

**Gard5096** · 09-11-2012, 01:00 PM

The name of the workbook is "Pipeline_Report" - Do I have to include the tab name as well? Would it be easier for you to just show me how to record this action so I can see where each variable is coming from?

**JOHN H. DAVIS** · 09-11-2012, 01:40 PM

Yes. If you could provide the copy to Tab name. As far as I know, you can't record variables. However, it does sound like an easy fix I just need the tab name.

Or you could change the code where I've put TAB NAME:

Please Login or Register  to view this content.

**Gard5096** · 09-11-2012, 01:53 PM

The tab name is "Report1" and the column that needs to be filtered is "L".

Do I need to have my cursor on a certain cell when I run the macro?

**JOHN H. DAVIS** · 09-11-2012, 01:58 PM

No, just run the macro, but make these changes first

Please Login or Register  to view this content.

**JAYRUES** · 09-11-2012, 02:43 PM

I do something similar. There is an select visible cells icon you can put on your Quick access toolbar. Right click on the quick access toolbar and select customize on the left. On your choose commands from section in the middle change it to all commands and slide down to "select visible cells:. Add it to quick access toolbar by hitting the add button. It will now show on the quick access toolbar. Run your macro and then hit the select visible cells and then copy them any where you want to.

**Gard5096** · 09-12-2012, 12:38 PM

JOHN-

When I run your code, first is hides all of the rows with data, and then the error occurs...if that helps

**Gard5096** · 09-12-2012, 12:39 PM

Ohhhh JAYRUES, this works! Is there a way to do this, but having the title row removed?

**JAYRUES** · 09-12-2012, 12:51 PM

I'm afraid not not that i know of.

**Gard5096** · 09-12-2012, 03:10 PM

JOHN - I used your code as a reference and figured out what I needed to do to make it work! Thank you very much for your time and expertise.

**JOHN H. DAVIS** · 09-12-2012, 03:18 PM

You're welcome. Glad you got a solution.

**jaslake** · 09-12-2012, 05:33 PM

Hi Gard5096

Try this

Please Login or Register  to view this content.

Need Macro to Select All Files in a Column After Filter Applied

LinkBack

Thread Tools

Rate This Thread

Display

Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Need Macro to Select All Files in a Column After Filter Applied

Re: Selecting all filtered files in a column when the row #s it selects are different each

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions