Hi

I hope someone can help me please?

I inherited a workbook that is used to share the forecast of how many we are going to sell across each product group (I work in a manufacturing company)

We have changed our SAP Product hierarchy, and I've been amending the sheet and macro's to incorporate this and had to create a few new sheets, which need a graph presenting the key figures.

But I've come across a issue which I need help fixing, please?

I'm using excel 2010, how do I reference current workbook and named range in a formula, please?

I've looked at the formula's on a twin sheet and wish to replicate them into the new charts, and there are 2 both pointing to named ranges, and I'm stuck.

I've tried searching but I think perhaps I'm not using the right terminology as the pages I'm finding aren't really helping me.

I really look forward to hearing from you

Thank you in advance
Clair