| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Data From Different Sheets Via Formula/ae
Is there a way I can use data from different sheets within a workbook via
formula? Naeema |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Data From Different Sheets Via Formula/ae
Yes. The general syntax is =Sheet2!A10+75 etc.
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Naeema" wrote: Is there a way I can use data from different sheets within a workbook via formula? Naeema |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Data From Different Sheets Via Formula/ae
Yes.
Click in the cell where you want to create your formula, start with the = sign and go on from there. When you get to the stage where you want to use a reference to a cell on another sheet, just go to the other sheet and click in the relevant cell. The formula will fill in the references accordingly, so you'll end up with something like =Sheet2!B2+Sheet2!B12-'Third sheet'!B3 -- David Biddulph "Naeema" wrote in message ... Is there a way I can use data from different sheets within a workbook via formula? Naeema |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| collecting data from many sheets to one sheet | Excel Discussion (Misc queries) | |||
| Consolidating data from multiple sheets. | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
Linear Mode
