Excel help
How Can I Reference Information On One Cell In Worksheet 1 in another cell in
Worksheek 2? |
Excel help
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) " wrote in message ... How Can I Reference Information On One Cell In Worksheet 1 in another cell in Worksheek 2? |
Excel help
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. -- David Biddulph "Chip Pearson" wrote in message ... 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) " wrote in message ... How Can I Reference Information On One Cell In Worksheet 1 in another cell in Worksheek 2? |
All times are GMT +1. The time now is 03:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com