VBA Looping for copy paste after running analysis

Hello,

I need some help with the following VBA. I was unable to get a loop to reliably run my analysis, and thought it may be easier for someone to look at the steps I need repeated. I have locked in specific cells that cannot change, and anything unlocked will need to copy/paste from the row below. I will need this to continue this loop until the dates from the Range B8-B1500 end (Output Tab). Thanks for your help--see below.

Please Login or Register  to view this content.

Hi finansator,

Welcome to the Forum

Have I isolated the loop with my red shading?

Please Login or Register  to view this content.

BTW - just highlight your code and click on the pound sign

Thanks for your help with this, xladept!

To answer your question, no. I will need it to continue copying and pasting results from changes to the following:

wo.Range("B8").Copy: wa.Range("C10").PasteSpecial Paste:=xlPasteValues

B8:B1500 is where my dates are stored. The loop will need to copy the date from the "output" tab, paste it into the "Analysis" tab. An analysis will then run--updating the cells to be copied (these cells won't change), and then will paste the outputted values to the rows in the output tab. As the dates change, so to the outputs on the "analysis" tab. then I will be storing the output values (by date) on the output tab. this will repeat until the the last date is defined in the "output" tab. All of the following will need to be looped.

Please Login or Register  to view this content.

Thanks for pointing that out, Fotis1991. My bad, indeed.

Everything highlighted will be repeated. However, the cells highlighted in blue will stay the same while the others will need to be filled row by row until the last date from the output worksheet range B8:B1500 has been copied, and the results pasted.

Please Login or Register  to view this content.

Hi Finansator,

Best that you:

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. 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 demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi Finansator,

Thanks for the rep

Best that you:

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. 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 demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi Finansator,

Try this - the looping works, but it's slow and I'm not sure it's what you wanted:

Please Login or Register  to view this content.

Hi Finansator,

If that's what you wanted then this is a lot quicker:

Please Login or Register  to view this content.

Great - glad it worked - thanks for the feedback and - thanks for the rep!