Hi guys, I am fairly new to Excel (only experience was very basic schoolwork), having recently employed as a Grad in my company, I have been given some Excel tasks.
My question is, I am now working on a Pivot Table. Every month, we import a new set of data which refreshes the Pivot Table. However, some of the data values, might be changed during the monthly imports.
The problem I am having is, some of the names in the new import may be very similar to the previous month's, which makes some of our results go very wrong. The previous person has since left the company, and apparently everyone knew that the data wasnt refreshed properly, but nothing has been done. I have been asked to fix this, but have no idea how I can do it Any help would be much appreciated! Thanks, Vicky