Why do multiple circular references affect each other in a worksh.
I am trying to create a mileage tracker for service records, eg. a1=total
miles, b1=miles. I would like to enter in the new miles into b1 every time. I found that a circular reference works for this but for only one entry and I have many parts to keep track of. If at all possible I would like to be able to make this work for each part and all on one worksheet. If other worksheets are required for calculation purposes that is fine. Any help is appreciated. |
Take a look at
http://www.mcgimpsey.com/excel/accumulator.html In article , "jtblock" wrote: I am trying to create a mileage tracker for service records, eg. a1=total miles, b1=miles. I would like to enter in the new miles into b1 every time. I found that a circular reference works for this but for only one entry and I have many parts to keep track of. If at all possible I would like to be able to make this work for each part and all on one worksheet. If other worksheets are required for calculation purposes that is fine. Any help is appreciated. |
All times are GMT +1. The time now is 02:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com