Worked beautifully thank you JB.
Related Q: Delete entire row if condition is met, as per attached. If you can help with corrections much appreciated.
Sorry, I am struggling a bit but keen to learn and be competent. Thank you, regards.
Worked beautifully thank you JB.
Related Q: Delete entire row if condition is met, as per attached. If you can help with corrections much appreciated.
Sorry, I am struggling a bit but keen to learn and be competent. Thank you, regards.
Last edited by Alfie101; 07-03-2012 at 08:56 AM.
That's a fairly simple oneliner:
![]()
Please Login or Register to view this content.
or:
![]()
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Ok, i think i have this out of order - sorry. Have just replied, thanked and posted a related question. Alfie
I don't understand what you're saying. If there is a related post somewhere please provide a link to it.
Very simple but I am grappling.
I have numbers in a column (G1:G20). I want to find if any any are >12.0 and if so delete that entire row, and have the other rows move up to replace deleted rows.
Sorry about clarity before, many thanks. Alfie
![]()
Please Login or Register to view this content.
Just great JB. Much appreciated thank you. Alfie101
If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks