ExcelBanter - Automaticully copy of data

Hi Marco,
Sorry don't think you're going to get quite what you want.

You would have to update from one sheet, in which case
you might be able to use an Event macro when you change
a cell to have the same change made to another sheet,
but that really wouldn't be much different from using the
assignment that you don't want to use.
http://www.mvps.org/dmcritchie/excel/event.htm

I don't think you want to group the sheets to make the
same changes to the same cells in more than one sheet
at a time. Requires aligning everything just right, and
holding your breath that you don't forget to ungroup or
damage your workbook.

Some other things you might want to also look at,

HYPERLINK Worksheet Function, some examples in
http://www.mvps.org/dmcritchie/excel/sheets.htm

=HYPERLINK("#"&CELL("address",sheet7!C5),sheet7!C5 )
would allow you to move forward and back between sheets
with the link and with the BACK key.

Use of INDIRECT Worksheet Function
References are immediately evaluated to display their contents.
Mentioned only because you want to "refer to"
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Marco J.L." wrote in message ...
Hello,

I've a workbook with several sheets :

Sheet 1 : serveral data
Sheet 2 : I want to copy two colums in a printable format.

In "Cel A1" (Sheet 2) I've a formula : "='Sheet 1'!D2"
I want in "Cel A2" (Sheet 2) the data from "Cel D3" from "Sheet 1" , but I
don't want the formula "='Sheet 1'!D3"
I want to refer to "Cel A1" from "Sheet 2".

I want this because there are more sheets I want to print once a while, I
only want to edit "Cel A1" from "Sheet 2"

Is that possible?

Thanx,

Marco J.L.