Data Copy one sheet to another

[rr1050]

Hello there,

My requirement data copy from Input sheet to Output based on the heading.

Attached, file Input file has heading apple so search in output sheet "Apple" which cell located, and below that cell, copy paste data from input sheet.

Thanks

Regards, RR

[Sintek]

You get what you ask for...

Please Login or Register  to view this content.

By the way..."Mango " in OutPut sheet has a trailing space...

[maniacb]

Give this code try

Please Login or Register  to view this content.

[rr1050]

Dear Sintek & maniacb

Both codes works perfectly... many thanks

[Sintek]

..........................
THANKS.gif