Insert a formula in cell A1 (or whatever cell you want) on sheet2 that looks like:
=Sheet1!A1 Whatever the content of A1 on sheet1 is at any given time will also show in A1 (or whatever cell in which this formula is inserted) on sheet2. Hope this helps. Carol Warman _____________________________________________________ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Arroyo Sent: Tuesday, September 21, 2004 3:47 PM To: [EMAIL PROTECTED] Subject: PCWorks: Duplicating cell data between sheets in the same Excel 2000 workbook How do you automatically duplicate the contents of a cell in Sheet 1 to Sheet 2 in Excel 2000? i.e. the contents of A1 in sheet 1 also show up in the same cell (A1) or whatever other cell I choose of sheet 2 in the same workbook. Is there a formula for this? -J ============= PCWorks Mailing List ================= Don't see your post? Check our posting guidelines & make sure you've followed proper posting procedures, http://pcworkers.com/rules.htm Contact list owner <[EMAIL PROTECTED]> Unsubscribing and other changes: http://pcworkers.com =====================================================
