Hi,

I need some help with copying a formula which adds columns from another Sheet.

I have 2x B2B and 1x B2C.

I would like to add B2B sales togetherr in first column and then =sales 3 on second. I want to repeat this formula by dragging it to the right and not type formula in each cell by myself.

#Sheet 1
A B C D E F G
1 Period 1 2
2 Sales B2B B2B B2C B2B B2B B2C.. n1+
3 Values 1 2 3 4 5 6

#Sheet2 - Dasboard
A B C D E F G
1 Period 1 2
2 B2B =Sheet1!B3+Sheet1!C3 (WHEN I TRY TO COPY THIS FURTHER IT JUST ADDS 1, but what I had preferred is that it took next B2B sales from Period 2 etc: =Sheet1!E3+Sheet1!F3)
3 B2C =Sheet1!D3


I tried to explain it as easy as possible.

Thanks in advance for usefull tips!

- Hens