| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Referencing worksheets
I am trying to figure out a way to reference a value from one sheet to another. I know how to go to sheet 2 and "receive" a value from sheet 1 (=sheet1!a1), but I don't know how to take a value from sheet1 and "send" it to sheet 2 (??). Also, say I have a workbook with one worksheet in it titled "RED". Is there a way for me to say if there is a value in cell b2 on worksheet "RED" for Excel to automatically create a new workskeet and title it "BLUE"? One more thing. Regardless of whether both of these can be done separately, is there a way to do them simultaneously? -- NewExcelGuy ------------------------------------------------------------------------ NewExcelGuy's Profile: http://www.excelforum.com/member.php...o&userid=27141 View this thread: http://www.excelforum.com/showthread...hreadid=466567 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
| Shortcut for copying formulas referencing different worksheets | Excel Discussion (Misc queries) | |||
| Referencing Variable Name Worksheets | New Users to Excel | |||
| Summary worksheet referencing multiple worksheets | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Threaded Mode
