Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can create a formula to add data from 1 worksheet to another?
how can create a formula to add data from 1 worksheet to another?
|
#2
|
|||
|
|||
Hi Linnie
You can use VLOOKUP, if it is based on info on the destination sheet. Would need more info to help you there. You can also reference the cell in the source sheet, by inserting a formula in the destination cell. Say you want to put the data in Sheet1, cell A3, and you want to read the data from Sheet2, Cell F8, then in Sheet1, cell A3, enter the following formula: =Sheet2!F8. HTH "Linnie" wrote: how can create a formula to add data from 1 worksheet to another? |
#3
|
|||
|
|||
=Sheet2!A1+Sheet1!A1
or =SUM(Sheet1:Sheet2!A1) -- Regards, Peo Sjoblom "Linnie" wrote in message ... how can create a formula to add data from 1 worksheet to another? |
#4
|
|||
|
|||
This helps a lot thanks, but what if you want to reference information from
another excel file. Is that possible? "Kassie" wrote: Hi Linnie You can use VLOOKUP, if it is based on info on the destination sheet. Would need more info to help you there. You can also reference the cell in the source sheet, by inserting a formula in the destination cell. Say you want to put the data in Sheet1, cell A3, and you want to read the data from Sheet2, Cell F8, then in Sheet1, cell A3, enter the following formula: =Sheet2!F8. HTH "Linnie" wrote: how can create a formula to add data from 1 worksheet to another? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Formula presumes cells have data | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions | |||
Importing Data Into Formula Based Cells | Excel Worksheet Functions |