Thread: Macro Help!!
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rowan[_9_] Rowan[_9_] is offline
external usenet poster
 
Posts: 88
Default Macro Help!!

Hi Dennis

Can we clear up what you mean by Selecting an Item. Are clicking on the
dropdown on arrow next to header "Shop" and then adding a check mark
next to one or more shops, or are you just clicking on a shop in the list?

Regards
Rowan

Dennis Cheung wrote:
Thanks Rowan! It works only in the 1st time.
I select an item in PVT1 and the PVT2 change to the same item as PVT1. And I
notice that all items in "Shop" were hided except the item I select in PVT1.
In the 2nd time I select an item in PVT1, the item in "Shop" was not changed
in PVT2.
Can you help please?