How do I use an input to replace the sheet name that I’m doing calculations on. Every month the sheet name changes and I want to use an input box that changes this formula every month.
Month = InputBox(“Insert Month”)
This is the formula.
>Worksheets("Sheet1").Range("a1") = "=SUM(Sheet2!P:P)"
Trying to get this to work but formula keeps using the word month and not the month value.
>Worksheets("Sheet1").Range("a1") = "=SUM(Month!P:P)"
Month = InputBox(“Insert Month”)
This is the formula.
>Worksheets("Sheet1").Range("a1") = "=SUM(Sheet2!P:P)"
Trying to get this to work but formula keeps using the word month and not the month value.
>Worksheets("Sheet1").Range("a1") = "=SUM(Month!P:P)"