Hello all,

I am hoping you can understand my rambling...here goes:

I am building an inspection sheet that has drop down boxes for the techs to choose a result from thier inspection. I have a second sheet in my workbook for when an inspection results in a Warranty claim. I would like to see the sections on the warranty sheet which are the same as the inspection sheet autofill with data. I am struggling because I have data validation set in most of the boxes so I can't enter a formula in those cells. Is there another way or does anyone have another suggestion?

Thanks so much!!