Reference automaticully copied.

  • Thread starter Thread starter Marco J.L.
  • Start date Start date
M

Marco J.L.

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.
 
Marco,

This isn't clear. I think you want to be able to quickly change the Sheet
name, and have your print sheet (Sheet2) get its data from the specified
sheet. Same cells. Eh? Post back.

This will probably require the use of INDIRECT(), tho that usually gets
messy. Maybe someone has a better idea.

If I've guessed correctly, it might also be clearer to call the print sheet
something like "PrintSheet."

Or perhaps you can simply print directly from the source sheet, first
setting a print area (since you seem to want to start printing in column D).
 
Back
Top