Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In a spreadsheet, I have multiple workbooks, I would like to sync the names in the first column between the workbooks, addition and removal.

is this posible?

share|improve this question
up vote 1 down vote accepted

The easiest answer to this may be to make one workbook with just the list of values (I'll say "names" for an example), then the rest of the workbooks use that as a reference. You only need to change each one once, but without a very complicated macro or script you won't get what you are after.

Think about it this way: Excel can have a cell be either a formula or a value. If you only have 2 workbooks, you need to set one of the workbooks to get it's values from the other in a formula. But, if you change that second (formulaic) workbook to a declared value, the first won't get the change. If you set them BOTH to be a formula, you don't have a start value. You need to have a single location to edit that all your workbooks can read from, which means a separate "master" list in a distinct workbook.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .