Using a Template to View Multiple WorkSheets

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

I have used a technique with Lotus that I am having a hard time replicating
in Excel.

I have a series of files that come from an outside source. Each has
essentially the same info types, and all are formatted essentially the same
too.

Unfortunately, one user will have font A for an entry, and another will use
font B. I need these to be the same for a report, and I don't want to have
to change several dozen workbooks over the course of the year.

In Lotus, I was able to access this type of file using formulas to
concatenate the file path and individual worksheet, based on a list of file
names. Is there a way to do this in Excel?

I appreciate any help!
Rich
 
Rich,

You need to use a macro to concatenate files in Excel. Do the files have
multiple sheets, or just one in each file? What does 'essentially' the same
infor type mean? Are all the columns the same, or do you have keyed data
that needs to be put into new columsn in the database? Are all the files in
the same folder, or are they spread out in different folders?

Bernie
MS Excel MVP
 
Hey, Bernie...

Thanks for the response.

The files have multiple sheets. All have two baasic sheets, plus zero or
more others depending on the situation.

I have been thinking of each workbook as a record in a database. Each file
has the two sheets, and the same data points, or fields, with differing
data. If, when you say keyed data, you mean data that's spread across the
sheet, that's what I have. I think that probably would be the biggest asset,
is to gather up all the data from the various fields, into the main display
worksheet.

The files are spread out, but can and will be reorganized in subfolders of
the folder which contains the main display worksheet.

Now, I'm not much with macros, at least with Excel. Can you point me in the
right direction, please?

Thanks again,
Rich
 
Back
Top