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