| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel data across sheets
How do get data from one cell (or group of cells) from sheet to another cell
(or group of cells) to another sheet in Excel. If I were on the same sheet (i.e.: Sheet1) and I wanted to, say, place data in cell E3 to F11, I'd simply select F11, go to the Formula Bar, and type "=E3" to capture that data. How can I do the same thing but on different sheets? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel data across sheets
The easiest is to actually select the cell in the other sheet. Otherwise,
you have to precede your cell reference with the sheet name, followed by an exclamation mark, eg =Sheet1!E3 "Bee" wrote: How do get data from one cell (or group of cells) from sheet to another cell (or group of cells) to another sheet in Excel. If I were on the same sheet (i.e.: Sheet1) and I wanted to, say, place data in cell E3 to F11, I'd simply select F11, go to the Formula Bar, and type "=E3" to capture that data. How can I do the same thing but on different sheets? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel data across sheets
Thanks, Kassie. That did the trick!!!!
"kassie" wrote: The easiest is to actually select the cell in the other sheet. Otherwise, you have to precede your cell reference with the sheet name, followed by an exclamation mark, eg =Sheet1!E3 "Bee" wrote: How do get data from one cell (or group of cells) from sheet to another cell (or group of cells) to another sheet in Excel. If I were on the same sheet (i.e.: Sheet1) and I wanted to, say, place data in cell E3 to F11, I'd simply select F11, go to the Formula Bar, and type "=E3" to capture that data. How can I do the same thing but on different sheets? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel data across sheets
Glad I could help, and thanks for the response
"Bee" wrote: Thanks, Kassie. That did the trick!!!! "kassie" wrote: The easiest is to actually select the cell in the other sheet. Otherwise, you have to precede your cell reference with the sheet name, followed by an exclamation mark, eg =Sheet1!E3 "Bee" wrote: How do get data from one cell (or group of cells) from sheet to another cell (or group of cells) to another sheet in Excel. If I were on the same sheet (i.e.: Sheet1) and I wanted to, say, place data in cell E3 to F11, I'd simply select F11, go to the Formula Bar, and type "=E3" to capture that data. How can I do the same thing but on different sheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| how do i find data in multiple sheets in excel | Excel Discussion (Misc queries) | |||
| how do i find data in multiple sheets in excel | Excel Worksheet Functions | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Hybrid Mode
