Transfer important data from a messy rawdata

I have an unpredictable data, which I need a macro to be able to transfer the data. In the attached file, in the INPUT tab, all yellow should be transferred in a new sheet. Most of the data has dates/value on the column C. The highlights are for this sample purposes only and not in the actual.

Is there a macro on how I can transfer the line or the data to a new sheet with this data behavior?

Thanks.

You probably missed the attachment.

____________________________


Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

You can try this:

Please Login or Register  to view this content.

Hi, that just complicate matters.
Will the destination workbook be a new one? or is it an existing one? If existing, post a sample of that 'destination' workbook too.
Is the destination worksheet in the workbook a new one? or an existing one?