Single cell in my "work area" tab to be copied to a cell in the
Closed
tom
-
May 20, 2015 at 04:31 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 25, 2015 at 08:34 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 25, 2015 at 08:34 AM
Related:
- Single cell in my "work area" tab to be copied to a cell in the
- Which key is used to make multiple line in a single cell - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
- Insert the current date and time in cell a1 ✓ - Excel Forum
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
May 25, 2015 at 08:34 AM
May 25, 2015 at 08:34 AM
Hello Tom,
If the calculations are done in just one cell , say cell A1 in Sheet 2 and you want the result in cell A1 in Sheet 1 then:-
In A1 in Sheet 1 enter the equals sign (=) but do not press enter. Go to Sheet 2 and high-light (click on) cell A1. You should see "marching ants" patrolling the perimeter of the cell. Press enter. Done! The result will be seen in A1 Sheet 1.
If you click on cell A1 in Sheet 1, you will see the simple formula in the function bar.
I hope that this helps.
Cheerio,
vcoolio.
If the calculations are done in just one cell , say cell A1 in Sheet 2 and you want the result in cell A1 in Sheet 1 then:-
In A1 in Sheet 1 enter the equals sign (=) but do not press enter. Go to Sheet 2 and high-light (click on) cell A1. You should see "marching ants" patrolling the perimeter of the cell. Press enter. Done! The result will be seen in A1 Sheet 1.
If you click on cell A1 in Sheet 1, you will see the simple formula in the function bar.
I hope that this helps.
Cheerio,
vcoolio.
