Need a lookup to extract data table based on four criteria & override user input

David,

Thank you for explaining how to change the colors in VBA. You have been an invaluable resource and I am so grateful for your help and guidance. Also, I did go to the links below your name and there are some good resources there as well.

Marvin

David,

I have "added reputation" a couple of times and will continue to do so because I cannot give you enough kudos for your help on this project. Another question: I have managed to get a couple of errors in the VBA code at different stages which opens the "debugger". Is this occuring because I am trying to add rows or columns? In other words, does the VBA automatically update or does moving rows/columns mess up the VBA code? As in my instance, I may need to add a row on both the "Quote" sheet and the "Calculation" sheet. On the "Calculation" sheet the user will need to add rows quite often and it will be in between Rows 14 & 17 which is the same area that the "display table" is in. Will this cause any problems?

I know that I am going to have several questions in the future. Should I just post them to the forum or reply to your post? Not exactly sure what proper protocol is for this site.

Have a good day!
Marvin