Hi!

I have prepared a pivot table for equipment avalability, in which I can
select the required equipment, following which I can see the avaiability
status, which is being maintained in another sheet. Now, I want to create a
link of that particular equipment (selected in the pivot table) to the
another sheet and particular cells where details of accessories are there. I
am unable to do that. Is there any way of doing it??

Regards