Hi All
Have been searching without results....is there a way to copy only the last 5 visible rows after a range has been filtered.
Hi All
Have been searching without results....is there a way to copy only the last 5 visible rows after a range has been filtered.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Hi
Maybe this would work:
Copy your filtered data into a known Row
Then Select that new Data using Currentregion
Split the current region address into an array using the Split function
Adjust your array variables
Copy your required data
Deete the current region.
Please Login or Register to view this content.
Last edited by mehmetcik; 08-26-2017 at 12:06 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks mehmetcik for your response...Seems lengthy...Nothing easier...
Will give it a go...
There may be a quicker way - but after the filter:
will count the visible rows - then you can find where the count is t-5Please Login or Register to view this content.
and copy from there
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi xladept
Just can't think straight...How to do thisthen you can find where the count is t-5
Subtotal 9 is the sum 3 is the countA - so something like:
* If that doesn't work try 103 instead of 3 as 103 excludes manually hidden rowsPlease Login or Register to view this content.
Last edited by xladept; 08-26-2017 at 12:13 PM.
How about an UDF, you don't even have to think...Seems lengthy...Nothing easier...
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
* I forgot the special cells - so:
Please Login or Register to view this content.
@ - Karedog Thinking? What's that
@ karedog...
Perfect, thanks...
@ xladept...
Works as well...
gonna go with karedog's solution...
@Orrin,
Thinking :
It is a process to prevent the brain from rusting.
And if you ask "What is rusting ?"
It is what will happened to your brain if you stop thinking.
--------
@sintek,
You are welcome, don't forget to mark the thread as solved.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks