I have a spreadsheet which has lots of data rows and
columns (also has Macros which exports data, does some
validation etc).

This spreadsheet is distributed to my customers.

Here is my problem:
Periodically, I have to modify this spreadsheet to support
additional columns of data (sometimes the columns are
inserted in the middle of the current columns). When I do
so, I need to distribute the updated spreadsheet to my
customers and then they need to do a bunch of cutting and
pasting of their data from the old spreadsheet to the new
spreadsheet.

Does anyone hae any suggestions on how to easily handle
these types of repeated changes?

Thanks in advance.

Dave

That's the problem with spreadsheets! With a database you avoid many of
these "synchronicity" issues. Maybe a database system would work for you
and your clients.

"Dmorgan" wrote in message
...
I have a spreadsheet which has lots of data rows and
columns (also has Macros which exports data, does some
validation etc).

This spreadsheet is distributed to my customers.

Here is my problem:
Periodically, I have to modify this spreadsheet to support
additional columns of data (sometimes the columns are
inserted in the middle of the current columns). When I do
so, I need to distribute the updated spreadsheet to my
customers and then they need to do a bunch of cutting and
pasting of their data from the old spreadsheet to the new
spreadsheet.

Does anyone hae any suggestions on how to easily handle
these types of repeated changes?

Thanks in advance.

Dave