notsobright

Hi I have started to have a similar problem but I am not using vlookup and I was able to sort the sheet previously but it seems once I had added a couple of extra lines of data it would no longer sort properly it drops values and does not put the remaining ones in order. I only want to sort one column and I dont want the rest of the colmns to move. It has worked fine for nearly four years in all different versions of excel until about a month ago cant remember if there has been any updates to excel in that time there was one in september specifically for excel but thats all cant say if the problem coincided with then as I dont perform this function every week.