How Can I Reference Information On One Cell In Worksheet 1 in another cell in Worksheek 2?
J j_m_craig Mar 5, 2007 #1 How Can I Reference Information On One Cell In Worksheet 1 in another cell in Worksheek 2?
C Chip Pearson Mar 5, 2007 #2 You can do that directly with a formula. E.g., ='Sheet 2'!A1 returns the value in A1 on Sheet 2. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site)
You can do that directly with a formula. E.g., ='Sheet 2'!A1 returns the value in A1 on Sheet 2. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site)
D David Biddulph Mar 5, 2007 #3 Or the easy way is to click in your destination cell (in sheet 2?), type =, then click in the source cell (in sheet 1?) and Excel will fill in the reference for you.
Or the easy way is to click in your destination cell (in sheet 2?), type =, then click in the source cell (in sheet 1?) and Excel will fill in the reference for you.
