1. In EXCEL 2007 Set up 2 Workbooks one called avinity1.xlsx the other
called avinity2.xlsx.

2. In avinity1 Workbook in cell A 1 type, for example, this is cell A1.

3. Go to avinity2 Workbook and in cell A1 type:-

=[avinity1.xlsx]Sheet1!$A$1

This will copy the information directly from the avinity1 Workbook.

There are other ways of doing this.

If my comments have helped please hit Yes.

Thanks.



"avinity" wrote:

Hello,

I would like to be able to enter information into Wkbk 1 and have it
automatically update Wkbk 2 - is that possible?

To take it one step further, I have 7 separate workbooks with lots of
entries with different program codes. I would love to have all the entries
with program code A update automatically to the Program A workbook and all
entries with Program Code B update to the Program B.

Can I make this work?