View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
TheExpat Wanderer TheExpat Wanderer is offline
external usenet poster
 
Posts: 7
Default Pivot table - VB code

thank you again.
ill make my question very easy. and it will do what I want


Firstly , Cell B1 will take the value from A1
then if A1 value changed , it's value will be in Cell B2.(B1 will not change)
if A1 changed again ,it's value will be in Cell B3.(B1,B2 will not change)
if A1 changed Again ,it's value will be in Cell B4.(B1,B2,B3 will not change)

and so on

thank you in advance.