VBA to copy different ranges to other ranges

[Ztv]

Im quite new to VBA, but I can code some "smaller" problems. But right now, Im having trouble with this problem, which I dont know how to solve in an optimal way.

I simply just need a code which copies some data from one area/range to another area/range. Please see the attached file, I think it speaks for it self.

[kvsrinivasamurthy]

Pl see the attached file with macro.

[AB33]

Another one

[Ztv]

@kvsrinivasamurthy: The data has to be copied to the output sheet. Like in AB33's suggestion.

@AB33: It works, thanks .
Where should I edit the code so I only copy the values (i.e. ignore the formatting)? I have used this in another workbook:

Please Login or Register  to view this content.

But I cant figure out how to use it in this code.

[AB33]

The code already copies values only, but amended for your other requirement

[Ztv]

@AB33: Thank you so much!