View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Advanced excel fill handle Question

You could start by looking at the answer in your post of 17 minutes ago

"Pete G" wrote:

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