Extracting data from the offset of a cell, to be put into a new sheet

Hello and thanks for reading this, and thanks in advance for your help for which I truly appreciate.

I have a sheet of data (pls refer attachment - it's a zip file because excelforum doesn't allow *.xlsm uploads) which needs some processing. I need to scan column C (stock level) for those which are not at zero stock quantity, and take the following data to be arranged into a new worksheet according to rows:

copy offset(-1, 0) to Sheet2 A2,A3,A4 and so on
copy offset(-1, 1) to Sheet2 B2,B3,B4 and so on
copy offset(0, 1) to Sheet2 C2,C3,C4 and so on
copy offset(0, 2) to Sheet2 D2,D3,D4 and so on

I'm still quite a noob at VBA programming so I could only come up with the code below (which I'm pretty sure has errors as it is):

Please Login or Register  to view this content.

I would greatly appreciate it if someone can please help teach me how to fill in the blanks in the IF...THEN section, as well as help me check if the rest of my coding is correct.
Sheet1 of the attachment is the demo data (arbitrary and is bound to change), and Sheet2 is an example of how the data is to be arranged.

Thank you very much!

Try to use this code:

Please Login or Register  to view this content.

Regards,
Antonio

hey, sorry for the late reply wasn't in the office for the whole day.

tried your code, had to edit it a little for it to work properly but it did the job nonetheless. a very big thank you, i learned new code again today

thanks again!

~Michael~