VBA Loops / Copy / Paste Query

[carlbrianhadi]

Hi Everyone,

I'm new to the forum and this is my first post :0) I'd be get a Intro post done also!

In the meantime, I’m attempting to write the code (with no luck so far), to loop through a range of dates and copy / paste the returned results from another sheet.

Sheet1 – Is where I enter the date and the results are calculated
Sheet2 – Is where I want to build a record of the results against the corresponding date.

Simple code below; copy / paste the date from Sheet2 to show results on Sheet1, copy results and paste back to Sheeet2 against correct date. I need to loop as I’m working with dates going back to 2006! The date range is static 2006 - 2018.

Thank you in advance!

Please Login or Register  to view this content.

[carlbrianhadi]

My apologies. Now edited.

[carlbrianhadi]

Is anyone able to help?