LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 7th 05, 05:19 PM
Posts: n/a
Default How do I fix a circular reference in a financial statement?

I have created a financial statement in an 2003 excell spreadsheet that has
a section where I am listing the last five years of info. I have a form cell
where each statement is referenced by a different form number (i.e. form
1=year one, form 2=year two, etc.). My problem is that I have a number of
circular references that occur whenever I update the form from 1 to 2, 2 to
3, etc. This occurs because in my last five years info section I have five
columns corresponding with whatever form number is put in, and if the form
number matches the column then it floods in the financial info, but if the
number doesn't match, I want the columns to retain whatever values that are
already in them. To do this I had to use an IF statement that tested to see
if the form matched with the column, and if it didn't then the cell should
equal itself. Does anyone know how I can retain the information in the cell
without making the cell equal to itself?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Reference Math Ralph Howarth Excel Worksheet Functions 0 January 26th 05 06:27 PM
Circular reference Pat Excel Discussion (Misc queries) 2 January 19th 05 05:52 AM
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 1 December 2nd 04 08:30 PM
How do I reference multiple rows Awetronics Excel Worksheet Functions 1 November 4th 04 12:37 AM
Circular reference leon Excel Worksheet Functions 1 November 1st 04 12:45 PM

All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017