Hi, I have a macro that creates a pivot table from a set of data on a separate sheet in Excel. My problem is that during the pivot the case on the header _sometimes_ gets changed. For example the data is 'EX-Examination' but in the pivot table this is shown as 'EX-examination' .

This then means that my later macros can't then match up the 2 pieces of data. Any ideas how to stop this happening?