H
heather
I have 293 excel files, each comprised of a number of worksheets, and each
containing statistical information on a different area (the same type of
information, but obviously each area has different values; the same naming
conventions are used for each file/worksheet). What I want to do is to
extract selected worksheets from each file and merge them into one so I can
convert this to DB4 format to use in GIS mapping. Obviously I can cut and
paste individually....but...
Therefore, does anyone know of a macro/function etc that I could use to say;
for example: select source files, worksheet b4, range a3 - m17, paste in
destination file (preferably appended on the same worksheet and not in
separate worksheets). The original files are full of text, hyperlinks, odd
naming conventions etc which DB4 doesn't like; as well as information I don't
need. Does anyone have any idea how I might go about doing this (will save me
months of work...or megabucks to get the processed data from the bureau of
statistics).
containing statistical information on a different area (the same type of
information, but obviously each area has different values; the same naming
conventions are used for each file/worksheet). What I want to do is to
extract selected worksheets from each file and merge them into one so I can
convert this to DB4 format to use in GIS mapping. Obviously I can cut and
paste individually....but...
Therefore, does anyone know of a macro/function etc that I could use to say;
for example: select source files, worksheet b4, range a3 - m17, paste in
destination file (preferably appended on the same worksheet and not in
separate worksheets). The original files are full of text, hyperlinks, odd
naming conventions etc which DB4 doesn't like; as well as information I don't
need. Does anyone have any idea how I might go about doing this (will save me
months of work...or megabucks to get the processed data from the bureau of
statistics).