Help!! Excel question: how to link a cell to a group of cells

  • Thread starter Thread starter luican
  • Start date Start date
L

luican

Hi,

Good day!

I have a worksheet:
A commentA1
---------------
B commentB1
---------------
A commentA2
----------------
C commentC1
---------------
B commentB2
....
etc

and want to create another worksheet to link to the first to look like:
A commentA1
commentA2
---------------------
B commentB1
commentB2
---------------------
C commentC1

Can this be done in Excel?

Thanks,
lc
 
Hi Luican.............

In Sheet 2, wherever you want the contents from "Sheet 1 Cell A1", put this
formula

=Sheet1!A1

In Sheet 2, wherever you want the contents from "Sheet 1 Cell A2:, put this
formula

=Sheet1!A2

etc etc etc..............

Vaya con Dios,
Chuck, CABGx3
 
Hi Chuck,

Thanks for the reply. Wouldn't this provide just the content for row A,
column 1 etc?

Rgds,
lc
 
Hi Lucian.........

Yes, indeed it would, and if you wish more cells linked similarly, just copy
and paste that Sheet 2 formula wherever you want on Sheet 2. However, in
re-reading your post, I see that you might be wanting to Concatenate the
values from two different cells on Sheet 1 into one cell on Sheet 2.......be
that the case, the formula to link Sheet 1 cells A1 and A2 into Sheet 2 cell
A1 would be to put this in Sheet 2 cell A1

=Sheet1!A1&" "&Sheet1!A2

If thats not what you meant, post back and we'll try again..........

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top