Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Reflect cell contents into another worksheet
I have forgotten how to reflect data that is present in one worksheet cell into a specific cell of a second worksheet. IOW, repeat cell contents in a second worksheet. I simply do not make use of MS Excel97 often enough to remember the procedures ! Please help. Regards, ~ Vince ~ |
#2
|
|||
|
|||
Hi Vince,
Try this: - Go to the desired cell in your second worksheet. - Press the = key to start a formula. - Click on the first worksheet to select it and then click on the desired cell. You should see the formula now contains a reference to the desired cell. - Press return. You should now see the value in the cell from worksheet 1 repeated in the cell on worksheet 2. Is this what you wanted to achieve? Kind regards, Mark "Vince" wrote: I have forgotten how to reflect data that is present in one worksheet cell into a specific cell of a second worksheet. IOW, repeat cell contents in a second worksheet. I simply do not make use of MS Excel97 often enough to remember the procedures ! Please help. Regards, ~ Vince ~ |
#3
|
|||
|
|||
Example 1: =[Book2]Sheet1!$A$1
Example 2: ='[Copy of piezeros.xls]Sheet1'!$B$1 (note single quotes because file name has spaces) Formula is best done by typing = and then click on the cell in the second book. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Vince" wrote in message ... I have forgotten how to reflect data that is present in one worksheet cell into a specific cell of a second worksheet. IOW, repeat cell contents in a second worksheet. I simply do not make use of MS Excel97 often enough to remember the procedures ! Please help. Regards, ~ Vince ~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reference a worksheet name in a cell, or vice versa? | Excel Discussion (Misc queries) | |||
xls worksheet formatting a single cell | Excel Discussion (Misc queries) | |||
Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |