Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SOS-Accounting & Spreadsheets-SOS
Hello All,
How do I set-up a worksheet so that if I change a value on Schedule B, it will automatically change the correlating value on the Summary of Account woksheet page? Thanks in advance for your suggestions and help--highly appreciated!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SOS-Accounting & Spreadsheets-SOS
In the appropriate cell of the Summary of Account sheet, you should
begin entering a formula by typing =, then click on the tab of the Schedule B sheet, click on the cell whose value you are talking about, and press <Enter. You will now have a formula in your first cell along the lines of: ='Schedule B'!F7 (if it was F7 that you clicked on), such that if you change the value in the Schedule B sheet it will automatically be updated in your summary sheet - it's known as linking cells. Hope this helps. Pete On Oct 24, 10:59 pm, Brandee wrote: Hello All, How do I set-up a worksheet so that if I change a value on Schedule B, it will automatically change the correlating value on the Summary of Account woksheet page? Thanks in advance for your suggestions and help--highly appreciated!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simply Accounting | Excel Discussion (Misc queries) | |||
Accounting report | Excel Discussion (Misc queries) | |||
where can i get accounting templates | Excel Worksheet Functions | |||
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
how do i do an accounting spreadsheet | Excel Worksheet Functions |