Quote:
Originally Posted by NBVC
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