Transfer data from all sheets to one sheet

[YasserKhalil]

Hello everybody
I have six sheets of data (the data which I want to transfer is in range("B2:B" & LastRow) as every sheet has different last row

Their names (First, Second, Third, Fourth,Fifth, Sixth)
In sheet named ALL I want to transfer all data in other sheets to this sheet starting in B2 too

[Pepe Le Mokko]

http://www.rondebruin.nl/win/addins/rdbmerge.htm

[YasserKhalil]

Thanks sir
I know this addin but I want to code that task so as to learn new things

[BS Singh]

Hi,

This should work

Please Login or Register  to view this content.

Regards,

[YasserKhalil]

Thaks Mr. BS Singh
Your code is great but it brings the data twice !!!

[BS Singh]

Updated

Please Login or Register  to view this content.

Regards,

[YasserKhalil]

it doesn't work well too
the same results I got the data twice and the header removed too

[BS Singh]

This is working for me..if I understood your query correctly.

See attached.

[YasserKhalil]

Thanks sir for the file
It worked now. I don't know the cause to get duplicate results. I closed the WB and opened it again ..tested the code again it worked well .. That's weird
Thank you very much