copying non-sequential cell references

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've always wondered if this is popssible and it would
help greatly. I need to copy the contents of every
thirteenth cell in column A to consecutive cells in
column B, so A13 copies to B1, A26 to B2, and so on. Is
there a quick way to write the formula for the cells in
column B? It will take forever to write the formula for
each B cell (200 of them!) individually.

Many thanks

Gary
 
Back
Top