I understand that, however, I want it update cells if I add them because when doing a bid I am always adding or deleting products from it and I want the other worksheet to update. I am guessing what I need to do is some kind of Visual Basic Programing to accomplish this but I would like to find a way so that I don't have to. Any other suggestions?