Macro to move an existing formula down one row

[ranvan]

Hello,

I am looking to create a macros that will automatically move a formula down one row. My current formula is:

=SUM('Chart Data - CBV'!D31:D36)

I want it to become:

=SUM('Chart Data - CBV'!D32:D37)

Any suggestions?

Thank you
Ranvan

 

[Giordano Bruno]

Greetings ranvan,

Here's a suggestion. Add a row to the top of the worksheet Chart Data - CBV. That will change the formula. Assign the formula to a variable. Remove the new row.

 

[ranvan]

Thank you, not quite sure how to get that done. Problem is also, that this data is linked to various items within my workbook. All my charts are based on this worksheet. The Chart Data worksheet is a link to the actual Summary page, as my Chart Data page is used to hind unwanted rows in my charts. Would adding a row then deleting it affect the rest of my workbook? This workbook is all automated with buttons linking to macros etc.

 

[ranvan]

Hello,

Does anyone know how to do this? I want a macro to automate this, as I have multiple locations within my workbook that I need to move my formula down one row each month. It would save a lot of time not to mention forgetting one along the way.

Thank you!!