how can I update multiple worksheets at the same time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
David,

Place your cursor in destination cell,
type =
then go to source cell
and then type enter ...
That 's it ...!!!
HTH
Carim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Worksheet List to Named Array Constant 4
Monthly Update 1
Combine 6 worksheets into 1 worksheet - Summary 1
worksheet referencing 2
Can an Array Formula Solve This? 1
Summarizing data into different worksheet 1
Conditional Formatting 2
Fill a column in a worksheet from a formula worksheet based on the date 4

Back
Top