I'm creating a pricing report for both our salespeople and customers in Excel
07. I would like to have a detailed form on one worksheet with all the
information that the salesperson needs to account for. I would then like to
have all this information referenced to a seperate worksheet that is
formatted for customer's eyes.

Is there anyway to have every cell mimicked in a seperate worksheet
(including numbers, formulas, and names/words)? I know how to do individual
3-D references, but is there anyway to reference an entire worksheet in one
go?

Ideally i want two identical worksheets, where the second one will always
mimick the changes in the individual one. This way i can just 'hide'
particular columns and rows to suit our customers.

Thanks for any help!

Select a range(A1:M1000) on source sheet, copy and switch to target sheett.

Select A1 and Paste Special>Paste Links


Gord Dibben MS Excel MVP

On Tue, 1 Apr 2008 12:34:02 -0700, Brady <(E-Mail Removed)>
wrote:

>I'm creating a pricing report for both our salespeople and customers in Excel
>07. I would like to have a detailed form on one worksheet with all the
>information that the salesperson needs to account for. I would then like to
>have all this information referenced to a seperate worksheet that is
>formatted for customer's eyes.
>
>Is there anyway to have every cell mimicked in a seperate worksheet
>(including numbers, formulas, and names/words)? I know how to do individual
>3-D references, but is there anyway to reference an entire worksheet in one
>go?
>
>Ideally i want two identical worksheets, where the second one will always
>mimick the changes in the individual one. This way i can just 'hide'
>particular columns and rows to suit our customers.
>
>Thanks for any help!

thank you so much. that was just what i was looking for!

"Gord Dibben" wrote:

> Select a range(A1:M1000) on source sheet, copy and switch to target sheett.
>
> Select A1 and Paste Special>Paste Links
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 1 Apr 2008 12:34:02 -0700, Brady <(E-Mail Removed)>
> wrote:
>
> >I'm creating a pricing report for both our salespeople and customers in Excel
> >07. I would like to have a detailed form on one worksheet with all the
> >information that the salesperson needs to account for. I would then like to
> >have all this information referenced to a seperate worksheet that is
> >formatted for customer's eyes.
> >
> >Is there anyway to have every cell mimicked in a seperate worksheet
> >(including numbers, formulas, and names/words)? I know how to do individual
> >3-D references, but is there anyway to reference an entire worksheet in one
> >go?
> >
> >Ideally i want two identical worksheets, where the second one will always
> >mimick the changes in the individual one. This way i can just 'hide'
> >particular columns and rows to suit our customers.
> >
> >Thanks for any help!
>
>