One of those Excel question posts...

[Mike Lowe]

Pretty simple I'm thiking...

I have content on one page, that I'd like to automatically appear someplace else on another page. When I update the content on page 1, it automatically changes the content on the additional page as well.

Make sense? Just in case it matters, the original page has merged cells that make up a block, with the writing on top of that block. I'm only concerned with having the text automatically move to the additional page.

[sterlingice]

Unless I'm misunderstanding, on the other page, just go to a cell, type "=" and then put your cursor on the cell you want it to copy. You'll see the syntax "={other_sheet_name!cells}" and you can copy and paste that all over the page you want to display the data on. Meanwhile, whenever you update the raw data sheet, the display sheet updates because it's just a pointer

SI

[wade moore]

si beat me to it - should be really as simple as he says.

[Mike Lowe]

When I do that I get an error. This is what's in the command box at the top:

='PAGE NAME HERE'!A65:C67

[Rizon]

Originally Posted by Mike Lowe

When I do that I get an error. This is what's in the command box at the top:

='PAGE NAME HERE'!A65:C67

If you're copying merged cells, the reference should be only to one cell (since it's merged). This looks like a range of cells. Unless I'm misunderstanding?

Should look something like this:
Sheet1: A4:B4 merged, with text in the cell
Sheet2: Link to A4:4 as =Sheet1!A4

[Suburban Rhythm]

Maybe I'm misunderstanding...

Let's say you have sheets A and B

The simple way is, as SI said, type "=", then click the cell you want to map.

So on sheet B, you want A1 to = A1 from sheet A....
='SheetA!'A1

Are you trying to put multiple cells from sheet A into one cell of sheet B? That can't be done.

[Suburban Rhythm]

Originally Posted by Rizon

If you're copying merged cells, the reference should be only to one cell (since it's merged). This looks like a range of cells. Unless I'm misunderstanding?

Should look something like this:
Sheet1: A4:B4 merged, with text in the cell
Sheet2: Link to A4:4 as =Sheet1!A4

Even then, you'll only get the 1st result, so what is in cell A4, before the merge.

[Rizon]

Originally Posted by Suburban Rhythm

Even then, you'll only get the 1st result, so what is in cell A4, before the merge.

These are the only 3 scenarios I could think of (what he's trying to do)

[Suburban Rhythm]

Originally Posted by Rizon

These are the only 3 scenarios I could think of (what he's trying to do)

Gotcha

When he says

When I do that I get an error. This is what's in the command box at the top:

='PAGE NAME HERE'!A65:C67

Looks like he's trying to get the data from 9 cells into 1 cell on his secondary page.

[Rizon]

Originally Posted by Suburban Rhythm

Gotcha

When he says



Looks like he's trying to get the data from 9 cells into 1 cell on his secondary page.

Something like row12?

[Suburban Rhythm]

Originally Posted by Rizon

Something like row12?

Yeah I suppose. He referenced merged cells in the OP. So not sure what he's trying to do...

I just like messing around with this stuff over doing work right now!

[Mike Lowe]

I'm opening the attached Excel sheet above here in a minute. The merged cells I'm referring to make a box, like a desk for a seating chart, but I only need to copy the name that's typed on that "seat" which is just merged cells. I don't care about getting anything from one page to the other aside from the text (student's name).

[Rizon]

Originally Posted by Mike Lowe

I'm opening the attached Excel sheet above here in a minute. The merged cells I'm referring to make a box, like a desk for a seating chart, but I only need to copy the name that's typed on that "seat" which is just merged cells. I don't care about getting anything from one page to the other aside from the text (student's name).

Any chance you can post your Excel file here or PM it to me? So I can see what you're looking at.

[Rizon]

Originally Posted by Mike Lowe

The merged cells I'm referring to make a box, like a desk for a seating chart, but I only need to copy the name that's typed on that "seat" which is just merged cells. I don't care about getting anything from one page to the other aside from the text (student's name).

Like this?