![]() |
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 |
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