Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3-D worksheet references?
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
3-D worksheet references?
Select a range(A1:M1000) on source sheet, copy and switch to target sheett.
Select A1 and Paste SpecialPaste Links Gord Dibben MS Excel MVP On Tue, 1 Apr 2008 12:34:02 -0700, Brady 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
3-D worksheet references?
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 SpecialPaste Links Gord Dibben MS Excel MVP On Tue, 1 Apr 2008 12:34:02 -0700, Brady 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet references for a macro and VBA | Excel Discussion (Misc queries) | |||
References to a specific worksheet | Excel Discussion (Misc queries) | |||
worksheet references | Excel Discussion (Misc queries) | |||
Cell References from old worksheet to new worksheet. | Excel Discussion (Misc queries) | |||
Worksheet references another tab in formula | Excel Worksheet Functions |