Copy the value of one cell from worksheet to
Closed
Nicole
-
Oct 11, 2010 at 09:03 AM
GrnSpdr Posts 14 Registration date Wednesday October 6, 2010 Status Member Last seen December 11, 2010 - Oct 11, 2010 at 12:24 PM
GrnSpdr Posts 14 Registration date Wednesday October 6, 2010 Status Member Last seen December 11, 2010 - Oct 11, 2010 at 12:24 PM
Related:
- Which function would you use to enter the current time in a worksheet cell
- How to enter @ in laptop - Guide
- Popcorn time download - Download - Movies, series and TV
- How to change time in whatsapp - Guide
- Ocarina of time rom - Download - Action and adventure
- We limit how often you can post, comment or do other things in a given amount of time in order to help protect the community from spam. you can try again later. ✓ - Facebook Forum
2 responses
cant you just enter '=' then click to select the cell in the other sheet you want the data to update from?
GrnSpdr
Posts
14
Registration date
Wednesday October 6, 2010
Status
Member
Last seen
December 11, 2010
Oct 11, 2010 at 12:24 PM
Oct 11, 2010 at 12:24 PM
Hello Nicole,
To copy data from Worksheet One/Cell B2 into Worksheet Two/Cell C2, type this into Cell C2 on Worksheet Two:
=worksheetOne!B2
Meercat's method will work and is quicker.
To copy data from Worksheet One/Cell B2 into Worksheet Two/Cell C2, type this into Cell C2 on Worksheet Two:
=worksheetOne!B2
Meercat's method will work and is quicker.