View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Kardon Coupé Kardon Coupé is offline
external usenet poster
 
Posts: 9
Default Need to reference a block of cells from another sheet.

That doesn't seem to work with multiple cells (which are formated, into some
merged, etc)

Basically, I have (and this is exact)

Sheet 12, contains the data I want to be able to change and reflect into the
other 11 sheets...

So, on Sheet 12, Block A1 to I1 across and A67 to AA67 bottom line (so A1 is
top left corner, and AA67 is bottom right corner) will be referenced to A39
to I39 and A56 to I56 (A39 being top and I56 bottom right) on the other 11
Sheets. (same location on the other 11 sheets)

and from Sheet 12, I want to take A19 to AA19 across and A67 to AA67 bottom
line (so A19 is top left corner and AA67 is bottom right corner) will be
referenced to S7 to AS7 across and S55 to AS55 bottom line (so S7 is the top
left corner and AS55 is the bottom right) on the other 11 sheets (same
location on the 11 sheets)...(there is also S63 to AS63 & S111 to AS111,
that will get this copied from sheet 12, but if I know the principle, I'll
be able to sort that bit)

But like I said, all the cells are formatted, i.e. a 2 by 2 cell block looks
like one cell, as I've merged and wrapped text in the format options.

Thanks in advanced.

"JMay" wrote in message
...
On your sheet1 select the cell that should receive the data from Sheet12;
Hold down the Shift key and Click on Sheet11 << this should Group S1-S11;
enter =Sheet12!A1
Ungroup your sheets QUICKLY so you don;t forget (they are grouped),

Does tha work for you?


"Kardon Coupé" wrote:

Dear All,

apologies if this is probably a mundane question, but I didn't know what
'search terms' to put in google to return any results..

I've got a Spreadsheet with 12 tabs (sheets), I need part of tab 12
(sheet)
to appear on tabs 1-11 (sheets), so that if I change data in tab 12
(sheet),
tabs 1-11 (sheets) are changed too.. the cells themselves will never move
location, just the data within them..

Is it possible?

Regards
Paul.