Charting Employee name and product value over a given period

Originally Posted by sweep

Hi,

Please see attachment using the OFFSET function.

Hi Sweep,

you are getting their, some work some dont


and could you explain the cells above the drop down

Thanks for what you have done

Originally Posted by stephen1000

Hi Sweep,

you are getting their, some work some dont


and could you explain the cells above the drop down

Thanks for what you have done

Hi sweep, I have edited the staff list but 3 do not show any figures
Kerry, Steve, Helen

Any Ideas why

Originally Posted by sweep

In your first example I had to "trim" the list of names as there were extra spaces in them. Make sure this isn't the case for the ones you've just added.

Hi Sweep, Firstly thanks a mil for what you have done already.

not quite sure what you mean by the trim thing

as you can see from my previous post all but three names work, but they are not sequncial Kerry, steve ,, helen

hope you can shed light on this

cheers

stephen

Hi Dave

Sorted it thanks again


stephen