I want to create a formula for cell A1 but I want the results to display not
only in A1 but E5 as well. Is this possible?
I want to create a formula for cell A1 but I want the results to display not
only in A1 but E5 as well. Is this possible?
In E5, put:
=A1
--
Vasant
"Scarlett O" <Scarlett [email protected]> wrote in message
news:[email protected]...
> I want to create a formula for cell A1 but I want the results to display
not
> only in A1 but E5 as well. Is this possible?
Scarlett O,
Here is another little trick, which is amusing if nothing else.
Goto menu Tools>Customize>Commands tab.
Select the Tools category, and then scroll down to near the bottom of the
Commands section and find the Camera command.
Drag the camera icon onto a toolbar.
Now you can use the camera.
Select cell E5.
Click the camera button.
Move the cursor to your chosen cell and click to drop the camera image.
You will now have a 'picture' of cell E5 in cell A1. You might need to move
it a little to align it, and remove the border (right-click and select
Format).
There you have it, an image of E5 in A1. When E5 changes, the image changes.
I have used it previously say in A1 as an image of a cell that is linked to
A1. For instance, the image is an image of H1, and H1 says =A1*5. So you
type 1 in A1, and it shows 3, 2 and 10, etc. Most confusing.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Vasant Nanavati" <vasantn *AT* aol *DOT* com> wrote in message
news:[email protected]...
> In E5, put:
>
> =A1
>
> --
>
> Vasant
>
> "Scarlett O" <Scarlett [email protected]> wrote in message
> news:[email protected]...
> > I want to create a formula for cell A1 but I want the results to display
> not
> > only in A1 but E5 as well. Is this possible?
>
>
It has potential. Thanks for the fun
--
Jim at Eagle
"Bob Phillips" wrote:
> Scarlett O,
>
> Here is another little trick, which is amusing if nothing else.
>
> Goto menu Tools>Customize>Commands tab.
> Select the Tools category, and then scroll down to near the bottom of the
> Commands section and find the Camera command.
> Drag the camera icon onto a toolbar.
>
> Now you can use the camera.
>
> Select cell E5.
> Click the camera button.
> Move the cursor to your chosen cell and click to drop the camera image.
>
> You will now have a 'picture' of cell E5 in cell A1. You might need to move
> it a little to align it, and remove the border (right-click and select
> Format).
>
> There you have it, an image of E5 in A1. When E5 changes, the image changes.
>
> I have used it previously say in A1 as an image of a cell that is linked to
> A1. For instance, the image is an image of H1, and H1 says =A1*5. So you
> type 1 in A1, and it shows 3, 2 and 10, etc. Most confusing.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Vasant Nanavati" <vasantn *AT* aol *DOT* com> wrote in message
> news:[email protected]...
> > In E5, put:
> >
> > =A1
> >
> > --
> >
> > Vasant
> >
> > "Scarlett O" <Scarlett [email protected]> wrote in message
> > news:[email protected]...
> > > I want to create a formula for cell A1 but I want the results to display
> > not
> > > only in A1 but E5 as well. Is this possible?
> >
> >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks