View Single Post
 
Old 11-21-2017, 03:27 PM
hollies hollies is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Jun 2017
Location: Nottinghamshire
Posts: 25
hollies is on a distinguished road
Default

Quote:
Originally Posted by NBVC View Post
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
Reply With Quote