Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Functions
Hi
What does the master table look like? Can you clarify how you decide on the update formula is it a value in the master table? Do you want the update to be a formula or a hard coded value. You say 'when I change workbook = weekly totals sheet Employees cell H31 (changes 9500 H32 changes 9501 etc.) to 80% or would update from workbook "60% payout" if I put 60% in H31 This is a little unclear. But basically you need to loop through all the sheets and then pick up the price to change. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Tomkat743" wrote: I have a workbook with 100 sheets. Each sheet contains 50 or so items and pricing for each item. I need to updat the price list on each sheet based on a single master sheet. I was using straight percentages from a master pay sheet but am now forced to use multiple percentages per sheet. What I need is to write a formula that based on a cell value on the master sheet the pricing for each item will update from another workbook or workbooks. example: workbook = weekly totals sheet 9500 thru 9600 cells E5 thru E55 update from workbook "80% payout" Cells E5 thru E55 when I change workbook = weekly totals sheet Employees cell H31 (changes 9500 H32 changes 9501 etc.) to 80% or would update from workbook "60% payout" if I put 60% in H31 Please help Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get any of my functions to run in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 -Where did the ALT-E functions go? | Setting up and Configuration of Excel | |||
JIS / ASC Functions in Excel 2007 | Excel Worksheet Functions | |||
2007 Excel Functions | Excel Discussion (Misc queries) | |||
2007 Excel Functions | Excel Worksheet Functions |