Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating tabs linked to master tab
I have a spreadsheet that calculates utility usage for commercial tenants in
a building. The top worksheet tab contains a table of utility readings by tenant and below is a table that calculates usage (Current minus Prior reading * meter multiplier). Below that I enter the utility periods, costs and utility units to determine $/KWH, $/Therm or $/gallon of water. Below that I have a table that multiples usage by cost per unit to get billing amount for each tenant during that period. So my top worksheet tab is a summary of billing for the whole year. Each worksheet tab below contains one invoice I create for every tenant. Each invoice is linked to the top tab to get Current and Prior meter readings along with cost per unit. My question is how can I simplify updating the Current and Prior meter reading data on each of the 25+ invoice tabs? Thanks, Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Continous updating of linked spreadsheet | Links and Linking in Excel | |||
macro | Excel Discussion (Misc queries) | |||
Inserting rows, updating linked worksheet | Excel Worksheet Functions | |||
cells linked to others in same workbook not updating | Excel Discussion (Misc queries) | |||
Updating master workbook from source that may/may not exist | Excel Worksheet Functions |