View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newbie_help newbie_help is offline
external usenet poster
 
Posts: 1
Default linking spreadsheet nightmare


I have a excel spread sheet that was handed to me that is bascially
data dump from a old data base.

When they dump the data though is appears to be in a report format
which is 60 rows of data for one record and column a1 being th
description of the data and the actual data in column a2 as an example


The next record starts on row a60 and repeats throughout the dat
dump.

How can I get the data for each record in a
1 row of 60 colums and then repeat the process for the next recor
set.

I would think there is some formula that allows to link b2, b62,b122..
to a1,a2,a3

Thanks in advanc

--
newbie_hel
-----------------------------------------------------------------------
newbie_help's Profile: http://www.excelforum.com/member.php...fo&userid=1507
View this thread: http://www.excelforum.com/showthread.php?threadid=26708