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

linking spreadsheet nightmare
 

This won't link the cells but can obtain the data in the cells you want.

Sub Button1_Click()
Dim n As Integer
For n = 0 To 10

'sheetname you want to collect the data and paste data to
With Worksheets("DataSet")
'paste here = get from here
..Cells(1 + n, 1) = .Cells(2 + (n * 60), 2)
End With

Next n

End Sub











"newbie_help" wrote in message
...

I have a excel spread sheet that was handed to me that is bascially a
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 the
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 data
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 record
set.

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

Thanks in advance


--
newbie_help
------------------------------------------------------------------------
newbie_help's Profile:
http://www.excelforum.com/member.php...o&userid=15076
View this thread: http://www.excelforum.com/showthread...hreadid=267087