| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Circular reference
I need to know how to copy the results of the cummulative claims to the
previous claims row. In order to submit a new claim the previous claims cummulative should be 13,000 and then I need to delete the current claim amount and enter the new claim amount. I get a circular reference when I try to copy since it is a formula. Can anyone help me? Code Description Approved Budget Previous Claims - Cummulative Current Claim Cummulative Claims Remaining Budget i. Salaries 50,000.00 10,000.00 3,000.00 13,000.00 37,000.00 ll. Fringes 10,000.00 3,000.00 1,000.00 4,000.00 6,000.00 iii. Travel 5,000.00 2,000.00 1,000.00 3,000.00 2,000.00 Total 65,000.00 15,000.00 5,000.00 20,000.00 45,000.00 ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Circular reference | Excel Discussion (Misc queries) | |||
| Copying a mixed reference formula | Excel Discussion (Misc queries) | |||
| Why do multiple circular references affect each other in a worksh. | Excel Discussion (Misc queries) | |||
| international absulute cell reference | Excel Discussion (Misc queries) | |||
Threaded Mode
