Paste a SUM from Sheet 2 into Sheet 1

[adamprocter]

I am trying to build a macro to make some calculations from Sheet 2 and paste the values into Sheet one
The button I have runs the macro from Sheet 1

Sub MonthlyMacro()

    Sheets("Sheet 1").Range("M6") = "=SUM(Sheet 2!U:U)"
   
End Sub

 

[JLGWhiz]

Sub MonthlyMacro()
    Sheets("Sheet1").Range("M6") = "=SUM(Sheet2!U:U)"   
End Sub

 

[Caribeiro77]

That extra spaces between the sheet names

change Sheet 1 by Sheet1, the same with sheet2

 

[adamprocter]

Ah sorry my sheets names have spaces I just mocked up dummy names ? I have had no issues with spaces for my other macros?

 

[Caribeiro77]

When sheet names have spaces i htink that you have to put ' before and after the sheet name e.g

Sheets("Sheet1").Range("M6") = "=SUM('Sheet 2'!U:U)"

 

[adamprocter]

Thanks! that's got it

With this type of SUM I also want to check another column containing dates and compare to be within the same month as TODAY()?
Any advise on that ?

I believe this will check if dates in column A are within the month but how do I combine with my SUM ?

<code>=IFERROR(SMALL(IF(A2:A100>=TODAY(),IF(A2:A100<=TODAY()+30,A2:A100)),1),"")</code>