Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Transfering the numbers with some calculations inside

[Closed]
Report
Posts
1
Registration date
Saturday September 5, 2015
Status
Member
Last seen
September 5, 2015
 -
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
 -
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

1 reply

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!