I realize that it seems impractical, but it is a project that I have been
told to complete before our meeting next week so that we can present it for
the director and a few higher bosses. If it is possible to do it, but
impractical then that is what we will tell them. But first I must know the
process to put it together so that I can show them where things could go
wrong.

Thanks.

"Duke Carey" wrote:

What you propose to do is error prone and impractical. You should always
enter your data in one place and only one place, then use Excel's filtering
and sorting capabilities to generate reports, etc.

So...my advice is to enter ALL the data on the master sheet. When the
database app is done, the person who is developing that should be able to
easily put the appropriate Excel columns into the correct Access tables.

"akemeny" wrote:

In order to prevent excessive entries of the same information my company
wants to link a master account list to the individual lists that we currently
updated for the purposes of using the master spreadsheet in Access for
reporting of information. For example:

Spreadsheets X234, X235 and X236 are all individual sheets; X234 contains 25
accounts, X235 contains 500 accounts and X236 contains 67 accounts. The
master spreadsheet contains all 592 accounts. We receive a notice on client
#56 on spreadsheet X235. Instead of updating the information twice (on the
individual and the master) we enter it on the individual only, but it updates
automatically on the master. The director doesn't want to use only the
master sheet because it will not include ALL the aspects that the individual
spreadsheets contain.

Is this possible?? Even if it is a lengthy process we would like to do this
(it's a temporary fix until our database is completed, but that won't be for
another few months).