Thanks again NBVC

I have managed to copy the rows down and input the data in several sheets and it works.

I even added extra sheets and got them to work too.

Now, I have not managed to get it to work in another workbook which is identical. I tried copy and paste and I have also typed exactly the same formula in the correct cells.

What is it that needs to change to get it to work in the other workbook. I cannot see the identifier that relates the formula specifically to my test workbook.

Rob

Is the formula pointing to the correct columns in the other sheets?

Are the values you are trying to pull numeric or text? My formula assumed numeric only as per your sample data.

Are you getting an error? If so what is it?

No errors but noticed that the formula was changing to my test sheet so I shut that workbook down and voila, it all appears to be working perfectly.

I didn't understand that keeping the test sales page open was interfering with my original file.

Thank you so much for your help. You have been very patient.

I will now plough on and input the rest of the data and set up all of the other sheets.

Many thanks once again.

Rob