B
Byers
I have some cells that use a user defined function that I wrote. I
finds a certain company from another chart and then inserts tha
multiplier. It all works perfectly, thanks to those that helped, bu
the problem is that the user enters what company the people work fo
first, then they go fill in the other chart with each company and th
appropriate multiplier. It doesn't cause any error messages but wha
happens is that the multiplier for the person is not update
automatically, I have to go in like I'm going to change it and hi
enter, then it changes, and only it, not the whole sheet, so I woul
have to do each on individually. Just looking for a way around it
maybe a line of code to add to my function or part of a formula.
thank
finds a certain company from another chart and then inserts tha
multiplier. It all works perfectly, thanks to those that helped, bu
the problem is that the user enters what company the people work fo
first, then they go fill in the other chart with each company and th
appropriate multiplier. It doesn't cause any error messages but wha
happens is that the multiplier for the person is not update
automatically, I have to go in like I'm going to change it and hi
enter, then it changes, and only it, not the whole sheet, so I woul
have to do each on individually. Just looking for a way around it
maybe a line of code to add to my function or part of a formula.
thank