Transfering the numbers with some calculations inside
Closed
emelina100
Posts
1
Registration date
Saturday September 5, 2015
Status
Member
Last seen
September 5, 2015

Sep 5, 2015 at 10:41 AM
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017  Sep 5, 2015 at 05:02 PM
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017  Sep 5, 2015 at 05:02 PM
Related:
 Transfering the numbers with some calculations inside
 Spreadsheet calculations  Guide
 Where is the calculator on my android phone  Guide
 Electrical calculations software  Download  Calculators
 The standard transfer speed of your wireless connection is  Guide
 Transfering sound from laptop to TV with HDMI ✓  Laptop Forum
1 response
smuneeb
Posts
67
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
1
Sep 5, 2015 at 05:02 PM
Sep 5, 2015 at 05:02 PM
Hi
If you want to reformulate some data to another sheet
then its work as given below
Suppose you have a data in Sheet1 at Column A and want to transfer data to another sheet named as Sheet2 in Column B with any formula,
you have to go to Sheet2 in Column B Cell
write "=Sheet1!A1" in Column B Cell No "B1"
it implies that it will fetch the data from Sheet1 and Column A Cell No "A1" to Sheet2 in Column B Cell No "B1"
if You want above example with any formula then
write =SUM(Sheet1!A1+A1) in Column B Cell No "B1"
it implies that it will sum the data from Sheet1 of Column A Cell No "A1" and Sheet2 of Column A Cell "A1" to Sheet2 in Column B Cell No "B1".
I hope you get the point
Thanks
If you want to reformulate some data to another sheet
then its work as given below
Suppose you have a data in Sheet1 at Column A and want to transfer data to another sheet named as Sheet2 in Column B with any formula,
you have to go to Sheet2 in Column B Cell
write "=Sheet1!A1" in Column B Cell No "B1"
it implies that it will fetch the data from Sheet1 and Column A Cell No "A1" to Sheet2 in Column B Cell No "B1"
if You want above example with any formula then
write =SUM(Sheet1!A1+A1) in Column B Cell No "B1"
it implies that it will sum the data from Sheet1 of Column A Cell No "A1" and Sheet2 of Column A Cell "A1" to Sheet2 in Column B Cell No "B1".
I hope you get the point
Thanks