Connections with multiple worksheets

B

bvicari

I am in a small office environment and have NO desire to learn Access. We
have an Excel 2007 spreadsheet used by 3 people on a network with a number of
formulas and about 4 worksheets. Obviously it gets annoying telling people
to close the spreadsheet all the time to unlock it for editing.
Consequently, I'd like to break it up into several different spreadsheets (we
each manage our own files) which are linked to a master spreadsheet.

Basically, I want to create a master sheet with connections to all three
documents, which consolidates them into one list. I leave blank space to add
information for new clients, but I don't want to copy the blank space into
the master spreadsheet. Furthermore, I don't want to have blank space in
between my linked tables. How do I draw data from all three sources and put
it into one big table?

For the record, the majority of this data is text and consequently, a
PivotTable will not work. Please let me know what options are available to
me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top