Sharing data between worksheets (auto-update)

Giganews Newsgroups
Subject: Sharing data between worksheets (auto-update)
Posted by:  RUSH2CROCHET
Date: Thu, 22 Jun 2006

Running Excel 2003 - not much experience in linking data - hoping someone can
help....

Sheet 1 is a transaction log - 1 per line, in several columns...
Sheet 2 needs to show columns A-C, F,H,I,M,N from Sheet 1, and allow
additional info to be added into O-T (not on Sheet 1)

I need Sheet 2 to be updated each time a new transaction is posted on Sheet
1, without having to re-key the info.

All help appreciated!

TIA,
Sandi

Replies