Macro or query formula to add different sheets data in one

Hi All

Lovely people!

Will highly appreciate help on this, This query is related to the flow statement data to summarise in one sheet

The three sheets data I am looking to add and in one sheet Year 2020

asking help to create macro or query for best visuals

basically summary of 3 different sheet data into Year 2020 sheet


I hope I explained it proper, let me know please if any question

Find attached workbook.

Thanks a lot in advance for help


Kind Regards

Have you heard of 3D reference?

If the worksheets to be calculated are next to each other like your sample workbook then
Formula in C2 in Year 2020
=SUM('450 LFB:450 HQ Bio'!D3)

Hi,

Thankyou for reply, I am really looking for macro to apply here.

Will highly appreciate response with macro query

Kind Regards

No really sure about how exactly you want to do, so hope you can amend then code.

Please Login or Register  to view this content.

According to the attachment as a VBA beginner starter :

PHP Code: 

Sub Demo1()
    With Worksheets
       .Item(1).[C3:G6,C10:G14,C19:G19,C21:G23,C25:G31,C33:G38,C40:G40,C46:G54,C58:G61].Formula = _
            "=SUM('" & .Item(2).Name & ":" & .Item(.Count).Name & "'!D3)"
    End With
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » !

Hi

Thanks I did tried to enter code gives me run time error,

Could you please add in file as attachment

Regards

Hi,

Here the attachment the file to work on