View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete G[_2_] Pete G[_2_] is offline
external usenet poster
 
Posts: 3
Default Advanced excel fill handle Question

In cells a1 is 1
in cell a2 is
in cella3 is 3

etc..

How do you set up a fill in say column B such that when you use fill handle
or equivalent b1 becomes equal to a1

but b2 becomes b3,

b3 becomes b 5


the filling process to avoid every other line ..

regards

Pete G