View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marco J.L. Marco J.L. is offline
external usenet poster
 
Posts: 2
Default Automaticully copy of data

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.