If any of the columns N O P Q is not zero
Pull that whole line A B C D E F G H I J K L M N O P Q to sheet2
If any of the columns N O P Q is not zero
Pull that whole line A B C D E F G H I J K L M N O P Q to sheet2
HI, Apply the below array formula in A3 and drag it down and across,
Ref the attachment
Formula:Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
boopathiraja
thank you , exactly what i needed
Volume of data is huge , this will trim tons of unwanted rows
Last edited by makinmomb; 10-20-2014 at 02:05 AM.
Hi, Thanks for the rep and feedback
The formula will serve purpose for less than 1000 rows
Is slow on 30,000 rows , I wish I had a macro version too
Nor I can post again since it will be duplicate
Hi, how Abt adding a helper column and copy paste,
If you are looking for a VBA Solution, Mark the thread unsolved, or request the Admin to move the thread to VBA Section
You will get a solution with other members,
boopathiraja
I have marked thread not solved
I will collect your formula that works with smaller data
Some one will take care of the macro of this
Anyone who will reply a macro based solution consider 22222 rows
Here is the code you need...
Check the attached file...Please Login or Register to view this content.
Last edited by Vikas_Gautam; 10-20-2014 at 12:51 PM.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Vikas this is light fast
Before I close the thread as solved , why is picking
data after the shot reconcile where there is blank data
I am expecting to paste the counter data there
HI, Vikas,
Here is the code you need...@makinmomb:Please Login or Register to view this content.
Maybe omitt the deletion and change the last line of code to read
Ciao,Please Login or Register to view this content.
Holger
Last edited by HaHoBe; 10-20-2014 at 12:44 PM.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thank you Vikas , I am waiting for the morning to
go blow the office with a big surprise
Thank you Hahobe too
Last edited by makinmomb; 10-20-2014 at 01:08 PM.
Hi Thanks for the suggestion Holger..
I work upon it..
but I took off Main Head Row with it...
However, I respect it, I used it other code.. as it was new for me.. ( Or May be I used it first time..)
Regards,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks