Sorting data from one sheet to another

[hsmeet]

Hi guys,

I know that it is very simple to do this sorting


but i am stuck to it. (I could not find the function or Code)

Please help

my exapmple is in attached book.

Thanx in advance

Hope to find solution as We always get in this forum........ Hats Off to you guys.......... u ppl are great

[martindwilson]

ok ive done this for you on sheet1

formulas are arrays which need to be confirmed with ctrl+shift+enter then dragged down(amend ranges as needed they only do 50 rows at the moment

i changed the function in data sheet col a to return a number not text as this messed with the look up value which is a number in cells c2 f2 i2
also changed it to remove errors if nothing in column f

[mikerickson]

This macro will do what you want. The destinationSheet can be adjusted in the noted line.
(see attachment)

Please Login or Register  to view this content.

Martin: Nice! I didn't think there was a non-VB solution. (Apparently you and I use the same naming conventions for test sheets )

[hsmeet]

Thanks Martin and Mike

Thanks for ur reply

I m trying to understand martin's formula and i hope to get my work done with this one

But Mike, I m sorry for i cann't understand this much complex code

and i tried ur sheet and i could not complete my all the rows in my text file

i m sure ur code is fine but i m wrong somewhere.

ny ways, THANKS for ur efforts dude.