Sure, you just use a formula. This is known as linking. If you are in cell C3, and you enter =A1, whatever is in A1 will show up in both cells. You can access cells on other sheets, so =Sheet2!A1 will copy the value stored in cell A1 on Sheet2 to wherever you entered the formula. You can access cells in other workbooks this way too. It possible to do it in VBA as well. When a cell is edited, a Change event fires, you can add code there. Something like: ActiveSheet.Range("A1").Copy Range("C3") This copies the value stored in cell A1 to C3. It's preferable to avoid VBA if you can, although a little VBA is often required to get precisely what you want (like the 1 second chart refresh). Tony > -----Original Message----- > From: piclist-bounces@mit.edu [mailto:piclist-bounces@mit.edu]On Behalf > Of John Pearson > Sent: Monday, 11 July 2005 1:44 AM > To: Microcontroller discussion list - Public. > Subject: Re: [OT] Book recommendations for VBA > > > Thank you very much for that Tony. I appreciate the effort. I will certainly > look this over and learn from it. > > I have a quick question, I think it may be simple, and perhaps it is already > in the example code you sent along (excuse me if so, but I have someone who > needs this feature last week and it may take me some time to find it).... > > Is there a real simple way to get Excel to automatically copy the contents > of a cell to another cell every time the first cell is updated or changed. > > Thanks again! > > John > > ----- Original Message ----- > From: "Tony Smith" > To: "Microcontroller discussion list - Public." > Sent: Saturday, July 09, 2005 8:30 AM > Subject: RE: [OT] Book recommendations for VBA > > > > Hi John, > > > > You won't find any info on DDE in recent books, that's fairly old stuff. > I had a look thru my book collection, a book on VB4 gave > > it an entire paragraph. Another book, "Developing Applications with MS > Office", (published in 1995 and referring to Office V4) has > > a short chapter, amusing called "DDE: It's not dead yet!". > > > > The way I'd do it is to write a small VB app to handle the DDE, and write -- http://www.piclist.com PIC/SX FAQ & list archive View/change your membership options at http://mailman.mit.edu/mailman/listinfo/piclist