I have a rather large workbook with around 10 sheets. i want to setup a
'export' button on this workbook that will allow a user to save
specific raw data (values from a given range and given worksheet) from
this workbook into another excel workbook and an 'import' button that
will allow user to import this raw data back to the location it was
exported from and use the existing formulas/links from this large
workbook.

I was thinking around these options:
1) Copy and then PasteValues from the large worksheet into another
workbook for exporting and same idea for importing
2) For all raw data, copy out all the values and put their
corresponding addresses in another excel sheet. e.g. column1:
Sheet1!$A$1, column2: value
and import it in by reading the address n value.

Suggestions on how I should go about this problem and a starting point
for getting started on the macros will be much appreciated.

Consider storing all the data in MS-Access, and either use MS-Excel to
extract the data (for use), or a report writer (for output/display). They can
save results of the sheets (in Excel) as a Web page if they have to share the
information.

What is the purpose of the multiple sheets and user actions on each?

P.

p.s. This should probably be a database application vs. Excel.
--
Overcome Sales Barriers
http://salesbarriers.typepad.com/


"ajn" wrote:

I have a rather large workbook with around 10 sheets. i want to setup a
'export' button on this workbook that will allow a user to save
specific raw data (values from a given range and given worksheet) from
this workbook into another excel workbook and an 'import' button that
will allow user to import this raw data back to the location it was
exported from and use the existing formulas/links from this large
workbook.

I was thinking around these options:
1) Copy and then PasteValues from the large worksheet into another
workbook for exporting and same idea for importing
2) For all raw data, copy out all the values and put their
corresponding addresses in another excel sheet. e.g. column1:
Sheet1!$A$1, column2: value
and import it in by reading the address n value.

Suggestions on how I should go about this problem and a starting point
for getting started on the macros will be much appreciated.