Excel 2007 Formulas
Posted on 2013-05-19
I am dealing with a very complicated Excel spreadsheet that I did not write, as it is quite a bit over my head. I would like to set up a table on a worksheet that uses a formula to sum up data along a row, and displays that data at the end, and instantly exports that data to a cell on another sheet.
For example: Dealing with Sheet-A, Sheet-B, and Sheet-C. The base data is entered on several cells on Sheet-A which sends data to various cells on Sheet-B. On Sheet-B, which would tally and add information from several other sheets, offering the results to Sheet-C for display.
To sum it up, rather than using a formula to look up information to import into the cell, is it possible to use a formula to take information from one cell and export it to another cell on another worksheet within the spreadsheet?