Hi there,
Can someone please help me with a macro to copy filtered data?
The filter is active from A10 to E86.
The macro should only select & copy filtered data.
Thanks,
Hi there,
Can someone please help me with a macro to copy filtered data?
The filter is active from A10 to E86.
The macro should only select & copy filtered data.
Thanks,
What row are your actual filters in? Row 9 or 10?
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
The filter is on row 8
Umm, strange as your data goes from row 10 unless you mean your first visible row is row 10. Anyway as an example the below will filter based on the blanks in column A of Sheet1 and copy to the first blank cell in column A of Sheet2.
Please Login or Register to view this content.
Hi mate, the macro is not working. I have made the attached sample file.
The macro does not require to paste in a separate sheet, the macro is just to copy filtered data.
Are you able to help me that please?
The macro posted works for doing what it stated it does.
Copy to where? I'm not psychicthe macro is just to copy filtered data.
The paste part will be done manually outside Excel, so the macro just needs to select and copy, and leave it ready to paste to the Word file.
Cheers
With your sheet protection off (if you havn't set it to allow filtering and copying...I haven't checked)...
Please Login or Register to view this content.
Hi !
A reminder : as Copy method works only with visible cells, SpecialCells is useless so no need neither On Error …
On Error is there because if there were no visible cells it would error and so you always should have error handling with SpecialCells! I admire your faith that copy only works with visible cells.
Last edited by WasWodge; 06-18-2019 at 10:55 PM.
As I wrote no need On Error without useless Specialcells …
Hi WasWodge,
The only problem I am having is with the protect cells.
How can I copy the cells and have the sheet protect as well?
Thanks,
We will have to differ on SpecialCells being useless, I will keep using it as copying not copying hidden cells doesn't always apply to manually hidden rows.
I also use SpecialCells for finding blanks, constants and formulas btw.
@ricdamiani, you have to allow filtering when you set the protection or turn it off at the start of the code and turn it back on at the end.
Last edited by WasWodge; 06-19-2019 at 04:20 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks