I am trying to get a spreadsheet to update mutiple worksheets as you fill it
out.
For example a budget on a spreadsheet.
The budget would have a primary woorksheet where expenses for the current
year are recorded. As a liabliltiy is recorded on the primary sheet, an
entry would be simultaneously created on another woorksheet listing just the
expense details of that expense type.
Eg Months
Expenses JAN FEB MAR
TELEPHONE 68.50 85.24 76.15
ELECTRICITY 123.50 125.96 25.65

Then there would be two other worksheets

Electricity
JAN 123.50
FEB 125.96
MAR 25.65

and

TELEPHONE
JAN 68.50
FEB 85.24
MAR 76.15