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