Excel data across sheets

B

Bee

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?
 
K

kassie

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
 
B

Bee

Thanks, Kassie. That did the trick!!!!

kassie said:
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
Click to expand...
 
Top