Forecasting from two business sites on one output, is this possible?

[Bert_Withpeterson]

Hi all, I have a simple table like the below. I'm looking to forecast both sites at once if possible on one output. When I select the whole range and select 'Forecast Sheet', it only selects Site B e.g. the bottom row. I assume it is possible to forecast both Sites at once, or indeed any number of sites, can anyone advise how this is possible?

Site	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23
A	10	20	30	40	50	60	70	80	90
B	10	15	17	12	30	40	80	90	100

Thank you

 

[RobP]

Not quite sure what you are trying to do, but it reads like you want to copy both rows onto a different sheet (called "Forecast Sheet") in your workbook yes ?

You should be able to highlight both rows (and assuming you are using a PC/Windows based machine - hit CTRL+C to copy the rows you highlighted.

Then select your "Forecast Sheet" , place the cursor where you want to paste them, and hit CTRL+V to paste data in.

If I've misunderstood, then please elaborate more ...
thanks
Rob

 

[Fluff]

Duplicate to: Is it accurate that Excel's 'forecast sheet' function can only work with one series at a time?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.