| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
information the same for cells on two different worksheets?
I am trying to get information i type in cells on worksheet A to also be
entered somewhere else on worksheet b. As I change info on sheet A I would also like it to be changing on be so I dont have to reenter the data every time. I know I have done this before, but can not remmember how. Any help would be greatly appreciated even though I know I am going to feel silly when I see how easy it is. Thanks, Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
information the same for cells on two different worksheets?
Hi Rob Assuming the info you want displyed is in cell A1 and you sheet names are sheet1 sheet2 sheet3 etc try putting this in sheet2(or wherever you want the info from sheet1 displayed) =Sheet1!A1 This can be changed for whatever cells you need Let me know how you go Steel monkey -- Steel Monkey ------------------------------------------------------------------------ Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051 View this thread: http://www.excelforum.com/showthread...hreadid=571250 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
information the same for cells on two different worksheets?
that was it thank you sooooo much. I was forgetting the exclamation point.
errrrr I mean, I was forgetting the exclamation point!!!! Thanks again Steel monkey, greeeeatly appreciated "Steel Monkey" wrote: Hi Rob Assuming the info you want displyed is in cell A1 and you sheet names are sheet1 sheet2 sheet3 etc try putting this in sheet2(or wherever you want the info from sheet1 displayed) =Sheet1!A1 This can be changed for whatever cells you need Let me know how you go Steel monkey -- Steel Monkey ------------------------------------------------------------------------ Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051 View this thread: http://www.excelforum.com/showthread...hreadid=571250 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two worksheets for missing information | Excel Worksheet Functions | |||
| Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
| Aggregating categorized information from several worksheets | Excel Worksheet Functions | |||
| Clearing information in certain columns | Excel Discussion (Misc queries) | |||
| Charting information from a number of worksheets | Charts and Charting in Excel | |||
Linear Mode
