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
- Facebook id verification time - Guide
- Based on the values in cells b77 b88 what function can ✓ - Excel Forum
- What function can automatically return the value in cell c77 ✓ - Excel 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.
