View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cyberdude
 
Posts: n/a
Default Can I do it without using macro?

Hi,

I want to do the following:

values of cells C20, C40, C60, C80, C100... are given,

then I need the value of A1 to be that of C20, value of A2 to be that
of C40, value of A3 to be that of C60 and so on.

Is there a quick way to do the above without writing a macro?

Thank you.

David