Is there a way to paste the Value of a cell into another one on a different spead sheet without a spacial paste cut?
Is there a way to paste the Value of a cell into another one on a different spead sheet without a spacial paste cut?
Last edited by shg; 10-30-2007 at 06:02 PM. Reason: title spelling
Maybe. The answer probably depends on why do you want a different method.
If the value is on Sheet1 in cell A1 and you want that value to appear on sheet2, then use
=Sheet1!A1
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Not really sure what your after but you can record a macro and assign a shortcut key to avoid using the menus.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks