Reference automaticully copied.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marco J.L. - 29 Apr 2004 16:10 GMT

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.

Reply to this Message

Earl Kiosterud - 29 Apr 2004 17:18 GMT

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

Signature

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

> Hello,
>
[quoted text clipped - 16 lines]
>
> Marco J.L.

Reply to this Message