B
Brady
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!
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!