Copy Paste Macro Loop

Hi,


I have a financial model (attached) which calculates the final cash flows (in a calculation sheet named 9.Operations, rows 428 to 437) for a particular plot. However,the model has a list of 17 plots in the input sheet (3.Input-Plot Details). The macro must change the plot number in the 9.Operations sheet(cell G11), re-calculate the final cash flows and paste all the final cash flows for 1 to 17 plots in a single separate sheet consecutively.

I am not a VBA expert.So, any help will be appreciated.

Kind regards,
Ritesh

Hi Ritesh

There appears to be no File attached...

Hello Jaslake,

Apologies. I am new to this forum,and trying to navigate my way through.How do I attach the file? I cannot see any option to do so.

Kind regards,
Ritesh

Hi Ritesh

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" worksheet that demonstrates what you wish the output to be.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.

Hello Jaslake,

Thanks for the guidance.

The file is attached. There is no code (I gave up after initial try). The output is needed in the sheet named 10.Cash Flows. Example cash flows for Plot 1000 are included. The macro should calculate the cash flows for all the 17 plots and paste them one after another.

Kind regards,
Ritesh

Hi Ritesh

It's beyond mind numbing...and my abilities...