Thanks. Will give it a try when I get to work in the AM.

L.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
L

To link data from one sheet to another you can use a formula on the
summary
sheet like =January!A1

This can be dragged down using the fill handle as far as you wish.

From the sounds of it you have 12 columns of notes on the summary sheet.

In January Notes column enter =January!cellref and drag/copy that down.

cellref being the top cell in the January sheet "notes" column


Gord Dibben MS Excel MVP

On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote:

Office 2k.

Have 13 sheets, one for each month and a "summary" page.
Each monthly page has a "Notes" column for special notes, comments, etc.
The Summary page also has corresponding columns (January Notes, Feb.
Notes,etc.etc.) for each month.
When done with particular month, I try to remember to transfer Notes from
individual monthly pages to summary page Notes. Now I just retype data
and/or copy-paste.

Would like to have anything I enter in Notes column on monthly pages to
auto
transfer to summary page Notes.

Help,

L.