circular reference

Hey guys, I've been struggling with a problem for a few days, so decided to test the superior minds of MrExcel. If anyone can solve this, I'd be very grateful! Here's an example table for a staff schedule: <colgroup><col><col span="7"></colgroup><tbody> 5/5/2016 5/6/2016 5/7/2016 5/8/2016...

I am trying to build a scheduling model for a clinic. Right now I am focused on building the basic model (random variation elements will be added later). Eventually, I am hoping that I can show wait times for patients and resource utilization patterns based upon different scheduling templates...

I've been using this awesome forum for many years, getting all of my Excel questions answered by the awesome forum members and Excel gurus, but now I'm having a task to which I cannot seem to find an already existing topic/solution for, thus this is my first post. I'm having (almost) the same...

Hi, I have a list of data in Sheet 1, and I use =(VLOOKUP($M$4,'Sheet 1'!$A$3:L1002,6,FALSE)) in Sheet 2 to call a value. I'm wondering if there is a way so that if I edit the value in sheet 2, it updates the value of the data in Sheet 1? Would I create some kind of a circular reference or use...

Hi all, I've written up an intentional circular reference as I need two cells to be identical when a certain criteria is met. These cells are also editable by other uses, both cells are set to 0 by default, it is only when one cell is changed, the other one must change. Is there a way to...

Can I circumvent circular references in excel by using VBA code (or is there a better way to make a formula) to calculate currency? In this case I have 2 columns where one is USD the other is GBP. When I enter an amount into the USD column I want the GBP column calculate on the fixed exchange...

Hi all, I have perused the various threads on difficulty finding difficult-to-locate circular references, but it appears that everyone eventually finds the problem either in the Error Checking--> Circular References dropdown option, or in the status bar (near "Ready"). I have this error pop up...

Background: I have been working on a pretty typical financial model that requires a circular reference (i.e. the amount of debt for a project is dependent on total project cost, which is dependent on the amount of debt, etc.). So I have turned on iterative calculation to handle this. The...

I have an Excel macro that opens workbooks in a folder/sub-folder structure and processes each worksheet via Copy/Paste SpecialValue and re-saves the workbook. As the macro processes hundreds/thousands of workbooks, there have been a few workbooks that have been "skipped". One reason for the...

Many years ago, in the days of Symphony, QuatroPro, and earlier versions of Excel, I used circular references extensively to collect results from different input data sets in extremely large and complex spreadsheets. You could base the selection of inputs and where result data would be stored...

Hello all, newbie questions for you involving Excel 2010. Have two cells that look at each other as conditional. A1 looks to see if A2 is >0 and if yes than A1 must be 0. A2 also looks to see if A1 is >0 and if yes than A2 must be 0. Only one cell can have a value greater than zero at any...

Ok, here is my problem I have a feed of live horse odds coming into a spreadsheet and the odds are changing from several hours before the race right up until the end of the race. What I need to do is to copy the odds of each horse at the start of the race. This can be triggered by another cell...

Hello, I have a sheet that simulates inventory levels at a store with deliveries for replenishment. I have the demand and leadtime be random so I am using conditions and INDIRECT multiple times. A circular reference error has appeared and I cannot trace it to solve it as Excel is showing me 6...

I'm trying to run a mathematical simulation of an economic model. I'm wondering what is the best structure to solve this problem, or whether I should consider purchasing Matlab instead. (I'm very poor and buying a Matlab program may be out of my budget since I'm not a student or associated with...

Hey how is everyone doing today I am actually new to this site, and still pretty new to excel. I am currently running a Excel '13 on a Win 7, as well as a Max OSX with Excel. I am currently working on a personal project where I am creating character sheets for RPG games like DnD and what not. I...

Hi, I have a circular reference with embedded VLOOKUP function which I solve using the iterative calculation. However the results that I get are not consistent: at the beginning both columns D and E produce the same result - then same implied rating and the same spread. However if I change...

This is my first time to submit a question here; I hope I'm asking for help correctly. If not, please advise and forgive. I've encountered something in a co-worker's spreadsheet that has me baffled. A cell contains a simple number (in this case, 12). There are formulas dependent upon that cell...

Hello all, I am looking for someone with experience building company financial statement models that use circular references to link the 3 financial statements. I am building a 5-year long-range model and basically the model keeps "blowing up" despite the fact that I turned on the iteration...

Hi, I am setting up a financial portfolio model. I have current/static portfolio data as of today - so, a list of stocks, bonds, private equity. In excel, I am forecasting returns for the next 10 years, so each asset class (or row) will grow at a certain rate. The sum $ total will grow from X...

This question is making me think I've gone crazy, seems simple but can not figure it out: If in cell a2 of sheet 1 I have some formula that returns a number by searching one database and if the value isnt there it searches sheet 2 'missing prehospital...' so cell a2 in 'missing...' has a...