Thanks Dave,

I agree with you.

Winnie

"Dave Peterson" wrote:

Not from me.

Well, maybe one. Tell your boss that if he (and you) uses the features that are
built into excel, then you'll have more time to spend on the work that brings in
revenue.

But that's just my opinion.

Maybe someone else will have an idea that suits your boss better.

winnie123 wrote:

Thanks Dave,

It does work but my boss just doesnt like filters and he just wants to type
in the customer name. Any other suggestions?

Thanks

"Dave Peterson" wrote:

You could drag the customer field to a page field and have something very close
to what you want.

winnie123 wrote:

Hi,

I have cteated a pivot table which list all the spare parts sells we have
made this year. The list is every sale and the pivot table is looking at
salesa value, profit margin, actual costs, etc by customer and parts category.

I have just been asked if I can create a box where a customer name can be
inputted and it brings up the rsults. Is this possible and can anyone help?

Thanks
Winnie

--

Dave Peterson


--

Dave Peterson