Copy the value of one cell from worksheet to
Closed
Nicole
-
11 Oct 2010 à 09:03
GrnSpdr Posts 14 Registration date Wednesday 6 October 2010 Status Member Last seen 11 December 2010 - 11 Oct 2010 à 12:24
GrnSpdr Posts 14 Registration date Wednesday 6 October 2010 Status Member Last seen 11 December 2010 - 11 Oct 2010 à 12:24
Related:
- Which function would you use to enter the current time in a worksheet cell
- How to enter at the rate in laptop - Guide
- What is the function of a hard drive - Guide
- How to enter bios - Guide
- Popcorn time apk - Download - Movies, series and TV
- How to enter in wechat - Guide
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 6 October 2010
Status
Member
Last seen
11 December 2010
11 Oct 2010 à 12:24
11 Oct 2010 à 12:24
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.
