Hello,
I'm new to this VBA language and I am struggling with the updating of formulae in code. Can anyone help?
I have formulas in a workbook that refers to another sheet in a different workbook (master spreadsheet).
Hello,
The formulae looks like this:
='sheet 1'!BH32
So in the VBA code I need to update the formulae each month to refer to the next cell along i.e. if the reference is to cell BH this week I need it to be changed to cell BI nextmonth in the workbook using code.
I am able to do a find and replace and also recorded the macro using the find and replace for all the formulas. All formulas are similar, the BH needs to be changed to BI, this month and BJ next month.
So I have the marco recorded, but now I need to revise the macro section that changes the BH to BI to something that will change it to one column to the right.
Any suggestions!!
I'm new to this VBA language and I am struggling with the updating of formulae in code. Can anyone help?
I have formulas in a workbook that refers to another sheet in a different workbook (master spreadsheet).
Hello,
The formulae looks like this:
='sheet 1'!BH32
So in the VBA code I need to update the formulae each month to refer to the next cell along i.e. if the reference is to cell BH this week I need it to be changed to cell BI nextmonth in the workbook using code.
I am able to do a find and replace and also recorded the macro using the find and replace for all the formulas. All formulas are similar, the BH needs to be changed to BI, this month and BJ next month.
So I have the marco recorded, but now I need to revise the macro section that changes the BH to BI to something that will change it to one column to the right.
Any suggestions!!