Copying Data from Sheet1 to Sheet2 with condition

Hi everyone,

Good evening. My first post here and happy to be a part, to learn and to contribute. i am posting a thread today to kindly get some help. I am new to VBA excel and i am working on a task. Please see the attached excel sheet; what I would like to get is,

1. Copy and paste data from Sheet1 into a sheet and that sheet data should be categorised according to the tests.

The final output should look like how it is in Sheet2. (Please note that there is no "Test C" on Sheet 2)

Any help would be very much appreciated.

Very much looking forward to replies.

Thanks guys!!

Try

Please Login or Register  to view this content.

1)

Don't quote whole posts -- it's just clutter.
If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.

2) Do a step debug while Local Window open.
While you are in VBE, go to [View] - [Local Window].
Click somewhere n the code, and hit F8
As you hit F8, the code executes one line and you will see all the variables in Local Window.

No problem Jindon, thanks again for your help and support! Cheers.