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?
|
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? |
=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? |
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? |
All times are GMT +1. The time now is 11:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com