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:
Transfering the numbers with some calculations inside
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".
