VBA Code excel Loop to copy and paste dates from one sheet to specific cells in another sheet - then paste specific content in that sheet to another workbook
Budget: £10 – £30 GBP
The process I have is follows
Step1 - I enter 3 dates in 3 cells
Step 2 - I paste those dates in 3 cells in a separate workbook
Step 2.1- The workbook calculates a lot of data and returns data
Step 3 - copy and paste that data into a new workbook
I have many days to calculate.
I want the macro to do this.
I input how many times I want to loop through the dates. It will be plus one on all three dates.
The macro - copies and pastes the orginal 3 dates to a separate sheet.
That separate sheet is loaded with formulas (all date dependent)
Then it pastes the results for that day into a separate sheet (or workbook)
Repeat for as many times as I chose.
I have my own VBA code that does 50 days at a time but I'd like it to do a lot more (and my code is from a macro recording).
If you can do this then get in touch.
I won't be sharing the spreadsheet as some data is protected. I can however provide dummy data and a dummy workbook if needed.
Step1 - I enter 3 dates in 3 cells
Step 2 - I paste those dates in 3 cells in a separate workbook
Step 2.1- The workbook calculates a lot of data and returns data
Step 3 - copy and paste that data into a new workbook
I have many days to calculate.
I want the macro to do this.
I input how many times I want to loop through the dates. It will be plus one on all three dates.
The macro - copies and pastes the orginal 3 dates to a separate sheet.
That separate sheet is loaded with formulas (all date dependent)
Then it pastes the results for that day into a separate sheet (or workbook)
Repeat for as many times as I chose.
I have my own VBA code that does 50 days at a time but I'd like it to do a lot more (and my code is from a macro recording).
If you can do this then get in touch.
I won't be sharing the spreadsheet as some data is protected. I can however provide dummy data and a dummy workbook if needed.