Input box and sum

[jmoney30]

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)"

 

[Snakehips]

@jmoney30

Two things I see. Month is a function so cannot be used as a variable. In the formula you will need to concatenate the variable string within the other portions of the formula.
Try

MyMonth = InputBox("Insert Month")
Worksheets("Sheet3").Range("a1") = "=SUM(" & MyMonth & "!P:P)"

Hope that helps.

 

[jmoney30]

Hi

@jmoney30

Two things I see. Month is a function so cannot be used as a variable. In the formula you will need to concatenate the variable string within the other portions of the formula.
Try

MyMonth = InputBox("Insert Month")
Worksheets("Sheet3").Range("a1") = "=SUM(" & MyMonth & "!P:P)"

Hope that helps.

Hi it works thanks