Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel help
How Can I Reference Information On One Cell In Worksheet 1 in another cell in
Worksheek 2? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|