Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I update multiple worksheets at the same time
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I update multiple worksheets at the same time
David,
Place your cursor in destination cell, type = then go to source cell and then type enter ... That 's it ...!!! HTH Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update multiple worksheets? | Excel Discussion (Misc queries) | |||
Automatic Update in Multiple Worksheets | Excel Worksheet Functions | |||
How to update multiple worksheets | Excel Worksheet Functions | |||
How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
Update multiple worksheets | Excel Discussion (Misc queries) |