Copy and paste relative data with loop

[MeggieDoodles]

Hello all,

I have what seems to be a relatively complicated problem. I need to write a macro that consolidates data from a Google Form into a readable invoice. The data pulled from the form looks like this:

Date	Child 1	Child 2	Child 3
2/1/17	After Care	Morning Care
2/2/17		Morning Care	After Care
2/3/17	After Care		After Care

I need all of the dates associated with an entry under each child copied and pasted in their own specified sheets. Currently, I have code that loops through all of the child names and creates a new sheet for them. This is my code for that:

Please Login or Register  to view this content.

What I would like it to do within that for loop would be:
-Loop through each cell in a column
-If the cell <> blank then
-Copy the cell value AND relative date
-Go to the specific child's sheet (as specified currently by cel.value)
-Paste the date in the next blank row in their sheet

If anyone has any insight into this I would be most grateful.

Thanks!

[dflak]

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.