Automatic linking of cell data between worksheets

C

CherylB

I am using Excel for word lists. Using one workbook, the
first worksheet within is the 'Master' index. Subsequent
worksheets will contain words divided into different
categories.

Example:
Sheet1 = Master Index
Sheet2 = Cardiology Words
Sheet3 = Oncology Words

As I enter words into the various worksheets, I would
like to have that word 'automatically' entered into the
Master Index worksheet. This index is cumulative.
Everything I have tried will not allow me to link more
than one worksheet to the index. Data from additional
worksheets, when linked, end up canceling out or
replaceing previously linked data.

Help please!
 

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

Similar Threads

How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
How to update data from linked worksheet back to a master worksheet? 0
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
How to update a value from a linked worksheet back to the master worksheet? 0
Linking value of cell on one worksheet to a column on another work 1
Automatic refresh in linked worksheet if row is added 1
Automatic Update in Multiple Worksheets 0
vlookup help linking data between worksheet 3

Top