some more on hyperlinks, if that's what you need:

HYPERLINK to a location within another document ?? not tested
need to add book name to path..

='[AddressBook.xls]Sheet1'!$B$3
=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01")


TOP OF DOCUMENT UP/ DOWN LINKS:
=HYPERLINK("#"&CELL("address",OFFSET($A$550,-1,0)),"0")
=HYPERLINK("#"&CELL("address",OFFSET($A$550,$Z$7,0 )),"0")

HYPERLINKS: (for use in a header line within document will go up or down;
Z7 cell is work cell for size of screen view)
=HYPERLINK("#"&CELL("address",OFFSET($A$550,IF(ROW ($A$550)ROW($A602)-$Z$7/4,$Z$7,-1),0)),"0")

Z7: (AX6 is work cell, for number of rows avail / see at top of screen)-22
rows of header..
=$AX$6-ROW($A$22)-2


"Blobbies" wrote:

I have data coming to me from different companies, which is essentially the
same type of data, but their spreadsheets are formatted differently and in
different orders etc.

I want to create an analysis spreadsheet of my own, and want to tell it to
refer to a column within their spreadsheets for the date, a column for the
time, a column for the customer number, a column for the customer details and
a column for the customer comments.

I thought I might be able to do that by creating a macro in the analysis
template that gives me the opportunity to identify the appropriate column or
the first cell containing the data I want to use in a column of the company's
raw data.

Is there a way to do this? Or is there some other way I haven't thought of?
I'm not clever enough (yet) to work this out!!??

I look forward to hearing your suggestions, or requests for more info'!



Mike
NZ