VBA sumifs with a loop

[DeanMcK]

Hi All,
I want to write some code that will allow me to do a sumifs.

How do I get the code to drop to the next line so 'Graph data'!A4' to changes to 'Graph data'!A5' within the code?

Column A has the time of day, from 8am to 8pm and is the look up




Current code looks like

Please Login or Register  to view this content.

Data.JPG

Any help appreciated

Cheers

Dean

[Richard Buttrey]

Can't you just copy the formula you create with the Cells(3 + I, 2)......line of code and paste it to the rows underneath.

I tend to hold formulae like this that need copying down a range in a named range in a spare row somewhere above the data and have VBA copy and paste the range name.

[DeanMcK]

I ended up adding " & I + 3 & ")" to the end of the formula - works a treat

Please Login or Register  to view this content.

Cheers

Dean

[DeanMcK]

Thanks Richard,

I'm not sure what you mean by

'I tend to hold formulae like this that need copying down a range in a named range in a spare row somewhere above the data and have VBA copy and paste the range name. '
[/I]

I wanted to 'loop' as there is over 270 lines it needs to go through and ended up with 'Graph data'!A" & I + 3 & ")" in the formula.

Cheers

Dean