Need help making display charts from DATABASE

[Karyn]

Hi,
I have a fairly simply problem I was hoping someone could help me
with. I
know there is an easy answer but have been banging my head against the
monitor for a few hours now.

I purchased one of those 150 CD changers and do not really care for
the software they give you so I was trying to set up a database that
would index which CDs held which songs and artist. I made this
database fine, not a problem.

I made a new sheet in the workbook that I designed a small chart that
would print out index card sized with the data. The data is formatted
to print the name of the artist and cd on the top line followed by the
song titles and other info in
arranged cells below.

The chart is aprx 17 lines high.

The first line of Data, on Line 1 prints fine. When I highlight the
chart and copy and paste special, below instead of reference, say A2
it counts down 17 lines and prints A19, bypassing the CDs between 1
and 17. How do I fix this? Any clue?

For example.... The sheet with the data is simply called DATA and the
chart page is simply called CHART. On the chart page in the formated
chart, for example I reference =data!A4 which prints the first CD
TITLE. When I copy all this to chart #2 below, instead of referencing
=data!A5 if references =data!A21

Any help is greatly appreciated.

Karyn

 

[Debra Dalgleish]

I'd create the cards in Word, using Mail Merge.
But, to create the formula in Excel, enter the following formula on the
Index Card sheet, in cell A1:
=OFFSET(Sheet1!$A$1,ROW()/17+MOD(ROW(),17)-1,0)

in A2: =OFFSET(Sheet1!$A$1,ROW()/17+MOD(ROW(),17)-2,1)
in A3: =OFFSET(Sheet1!$A$1,ROW()/17+MOD(ROW(),17)-3,2)

Copy those formulas down as far as required.
(But I'd still do it in Word!)

 

[Karyn]

thank you very much. i knew someone could help me. If I can do it
through WORD that is good too. I will explore that option as well.

All the best,
Karyn