Previous Topic Next Topic

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
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
 - Sep 5, 2015 at 05:02 PM
Dear,
i want to reformulate some data from an excel sheet to another with other columns titles.
the order of the rows are different also.
i added new columns in the new sheet to get other results.

thank you
Related:

1 reply

Answer 1 / 1
smuneeb
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
 1
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
0