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
- Popcorn time - Download - Movies, series and TV
- How to enter @ in laptop - Guide
- How to change time in whatsapp - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Ocarina of time rom - Download - Action and adventure
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.
