stock reconcile variance puller

[makinmomb]

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

[boopathiraja]

HI, Apply the below array formula in A3 and drag it down and across,

Ref the attachment

Please Login or Register  to view this content.

[makinmomb]

boopathiraja

thank you , exactly what i needed

Volume of data is huge , this will trim tons of unwanted rows

[boopathiraja]

Hi, Thanks for the rep and feedback

[makinmomb]

The formula will serve purpose for less than 1000 rows

Is slow on 30,000 rows , I wish I had a macro version too

[makinmomb]

Nor I can post again since it will be duplicate

[boopathiraja]

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,

[makinmomb]

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

[makinmomb]

Anyone who will reply a macro based solution consider 22222 rows

[Vikas_Gautam]

Here is the code you need...

Please Login or Register  to view this content.

Check the attached file...

[makinmomb]

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

[HaHoBe]

HI, Vikas,

Here is the code you need...

Please Login or Register  to view this content.

@makinmomb:

Maybe omitt the deletion and change the last line of code to read

Please Login or Register  to view this content.

Ciao,
Holger

[makinmomb]

Thank you Vikas , I am waiting for the morning to
go blow the office with a big surprise

Thank you Hahobe too

[Vikas_Gautam]

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,