get data form cells sequentially

  • Thread starter Thread starter swmasson
  • Start date Start date
S

swmasson

Hi there,

I have a spreadsheet i am creating which is giving me some amount o
hassle!!! I'm sure it is possible to do this but i just cant figure ou
how:-

I have one worksheet which has many copies of the same table, eac
table is consistantly ontop of the other i.e. first table uses cells A
- G10 (a rectangle of cells).

The dates i am trying to use are in a pattern of a nine row seperatio
i.e. first date is in cell G2, next one is G11, next one G20, and s
on.

I need to find out how i can make a formula which i could copy whic
would grab the date out of these cells in sequence for plac ing i
different cells, this is so bloody hard to explain, i hope i have don
it well enough.

Thanks for your time

Kind regards

Swmasso
 
swmasson,

For example, if you wanted to put a formula in cell C2, you would use

=OFFSET($G$2,(ROW()-ROW($C$2))*9,0)

and copy that down as far as you need.

Note that you need to change the $C$2 to the cell address of the cell where
you are actually putting the first formula.

HTH,
Bernie
MS Excel MVP
 
Back
Top