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?

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?

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?

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?