You have sheet 1 with values/formulas that will be in every row
You have sheet 2 with values/formulas that will be in every 9th row

Which sheet has the values and which has the formulas that need to link to
the other

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"mattguerilla" wrote in message
...

Hi,

I have multiple lists of details which I have concatenated into a new
list.

ie week number (42) period number (10) and week commencing date (09/01/06)
now reads "Week 42, Period 10, wc 09/01/06".

My problem is getting a seperate worksheet to read this list of
information,
but allow the new worksheet to lookup the list without adding in the
amount
of spare rows. IE, reference cell a1 (concatenated data) into cell a1 of
new
worksheet, then cell a2 linked to cell a10 and so on. How do I get Excel
to
reference one sheet in sequencial cells but the new worksheet to miss the
spare cells I need to use for other data? I do not want to individually
link
each cell.

hope I have explained myself,

Matt