LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking spreadsheet Saintsman Excel Worksheet Functions 1 July 1st 09 12:05 PM
Linking 2 spreadsheet using data from the last row of spreadsheet Mike Excel Discussion (Misc queries) 13 February 11th 09 10:48 AM
Linking 2 spreadsheet using data from 1st spreadsheet vennesse Excel Discussion (Misc queries) 1 February 11th 09 10:43 AM
Linking spreadsheet mrc1986 via OfficeKB.com Excel Worksheet Functions 0 October 6th 08 08:16 PM
sumif nightmare! TamIam Excel Worksheet Functions 3 May 28th 08 01:53 PM


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"