How do I copy a cell from one sheet to another in the same workbook?
How do I copy a cell from one sheet to another in the same workbook?
Do you really mean copy?
In Sheet2 you could have (in any cell) the formula =Sheet!A1 and that would
display whatever value is in A1 of Sheet!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"DaveO51" <[email protected]> wrote in message
news:[email protected]...
> How do I copy a cell from one sheet to another in the same workbook?
Thanks. Sorted! Best wishes.
"Bernard Liengme" wrote:
> Do you really mean copy?
> In Sheet2 you could have (in any cell) the formula =Sheet!A1 and that would
> display whatever value is in A1 of Sheet!
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "DaveO51" <[email protected]> wrote in message
> news:[email protected]...
> > How do I copy a cell from one sheet to another in the same workbook?
>
>
>
For example you want values from sheet1 to sheet2
Just type = in sheet2(which cell you store values), then go to sheet1,
click which cell data you want.
sp_prabhakaran(at)yahoo.com
--
sp_prabhakaran
------------------------------------------------------------------------
sp_prabhakaran's Profile: http://www.hightechtalks.com/m878
View this thread: http://www.hightechtalks.com/t2346928
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks