How to define Variables as Ranges and Copy them?

[Dubrock]

I want to create a Macro to be able to prepare a NEW Offer/Calculation based on an OLD Offer/Calculation.
I use 3 Tabs in Excel for this:
Tab 1: Contains the old calculation
Tab 2: Should contain the new calculation
Tab 3: Contains info about how a position in the old calculation matches a position in the new calculation.

Tab 3 is added as an attachment.

In the table A5:F22 of TAB3 the following info is given:
A the position number of the new calc
F the Range of the old calc [Tab3] that should be copied for this position.
C the cell in [Tab2] where the the calculation should be pasted (at least the cell where the range should start)

How can I create a Macro to do the following
Copy the range from TAB1 defined in TAB3 Cel F5
Paste the range starting in the Cel defined on TAB2 defined in TAB3 Cel C5
Then give the Cel on TAB2 defined in TAB3 Cel C5 the value of A5

Move on to the next row until No Values are defined in rows C and F

[Dubrock]

This is what I have so far:

Please Login or Register  to view this content.

[Dubrock]

Anyone an idea?

[FDibbins]

Dubroc, please use code tags with your code, thanks

[Dubrock]

I managed to make the Macro work, but row for row. And its far to slow. Based on the first position which is 20 rows, it would take about 6 hours to do one calculation of about 3000 rows.

Does anyone have ideas to make the macro significantly faster??

Please Login or Register  to view this content.