Transfering the numbers with some calculations inside
Closed
emelina100
smuneeb
- Posts
- 1
- Registration date
- Saturday September 5, 2015
- Status
- Member
- Last seen
- September 5, 2015
smuneeb
- Posts
- 77
- Registration date
- Saturday September 5, 2015
- Status
- Member
- Last seen
- March 8, 2017
Related:
- Transfering the numbers with some calculations inside
- Transfer data from one excel worksheet to another automatically - Guide
- Free fire id transfer - Guide
- Transfer whatsapp stickers to telegram - Guide
- How to transfer bookmarks from chrome to opera gx - Guide
- Mtu calculator - Guide
1 reply
smuneeb
Sep 5, 2015 at 05:02 PM
- Posts
- 77
- Registration date
- Saturday September 5, 2015
- Status
- Member
- Last seen
- March 8, 2017
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