get data form cells sequentially

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

swmasson

Thank very much for the reply, but i must be a little thick as i still
couldnt figure it out, could you please, if you get a minute check out
my spreadsheet which i have uploaded onto my server?

You will see some date at consuistent intervals down column G and also
where i woul like all these date to apear along row 1 starting at J
(this is where i would like to continue using the formula??

I hope i have described this well enough and thanks again for all your
help!!!!

here is the link to my spreadsheet - http://www.masson.tv/sepcalc.xls

Thanks again

Kind regards

Swmasson
 
SW,

I had given a formula for copying down, and you wanted one for going across.

In cell J1, use the formula

=OFFSET($G$2,(COLUMN()-COLUMN($J$1))*9,0)

and copy across the row.

HTH,
Bernie
MS Excel MVP
 
Back
Top