VBA Loop through date range and copy/paste values into new Excel sheet.

[WaterRulesEverything]

Hi Everyone,

I have an Excel sheet that's gathering data from a server based on the date range of 2 weeks.

Server Tag Name
1/1/2020 0:00
1/14/2020 11:59	12/31/2020 11:59
Date	Value
....	....

My goal is to copy the cells from date and value columns (10K+ rows) into another excel sheet named "NewExcel"

Then I would need to increment the date range by another 2 weeks eg. 1/15/2020 0:00 to 1/28/2020 11:59, copy/paste the new values, and add on to the "NewExcel" sheet. The for loop increment would stop at the set date at 12/31/2020 11:59 as shown in cell B3.

This needs to be done since the server can only spit out a specific amount of rows and I would need to pull years of data which can be tedious. I have used python before but I'm choosing to use VBA since this would be for other people to use as well and they may not necessarily have python downloaded. I found a few examples on this site where it shows how to copy and paste values to another sheet but I am still a little lost. Any help would be greatly appreciated and please let me know if I should elaborate on anything. Thanks!

 

[Larry Haydn]

Have you found a solution?

If not, can you show us a sample of your data, and what goes into the NewExcel worksheet?