I have a workbook with a number of worksheets for budgeting. I have one worksheet that has rates on it. Each rate I labeled "Electrician_Rate" or similar for what the appropriate name should be. I have another worksheet that is a schedule of when I want these rates to be applied to number of hours worked, this is a scheduling workbook. I had to make a new workbook and pulled two worksheets from the original workbook to the new workbook. I have lets say one cell at "$50" labeled "Electrician_Rate". I change the value from $50 to $100 to see if it would update correctly and it is not updating on the sheet where it should update the rate with the schedule. When I look at the formula it still says it is referencing the "Electrician_Rate" but it is not taking.
Can anyone think of any reason this is not working as it should? The obvious thing that probably caused it is moving the sheets from one workbook to another, but I really cannot figure out what the deal is and there are a lot of formulas referenced and I hate to rewrite them all.
Any help is appreciated. Sorry I cannot post the book because it has info that I cannot put on a open forum.
Thanks,
Matt
Bookmarks