ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how can I update multiple worksheets at the same time (https://www.excelbanter.com/excel-programming/329208-how-can-i-update-multiple-worksheets-same-time.html)

David2507

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

Carim[_3_]

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



All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com