Hey everyone,
Thanks for the help provided me thus far, but now I am having a differnt problem. The spreadsheet is set up with 4 worksheets. The first 2 taking input from the user, the third a sheet of constants and the forth displaying results. On this results page I have a function set up that compares a value in the column currently active (this being on the forth sheet still) to a value on the second page. If they are the same it reads another value from the second page and returns that to formula.
The problem is when I update the values on the second sheet it does not update the function value on the forth. I have read about a calculate subroutine but I can't get that to work.
Any Idea's? Here is the code:
Thank you
~Jason
Bookmarks