Hi,
I have a macro that I am using that is 5+ years old, I first started using it in 32bit Excel 2007 but I no longer use Excel 2007 anymore, instead I use Excel 2013 and this macro no longer works correctly...
- Run it in Excel 2007 with regional settings set to United Kingdom or United States = Works perfectly
- Run it in Excel 2010 or Excel 2013 with regional settings set to United Kingdom = Doesn't work
- Run it in Excel 2010 or Excel 2013 with regional settings set to United States = Works perfectly
Problem is, I'm British so my regional settings are set to United Kingdom.
How can I make my macro compatible so that it can either manage with any of the regional settings OR how can I get the macro to only work with United Kingdom regional settings (date)...
The macro is supposed to match two columns using autofilters to find the matched rows and then export data from one sheet to a different sheet. I've included a sheet called "RUSHEET (CORRECT)" that has what the output should look like.
The macro in question is:
You can download the file either from my dropbox or use the attached file.
https://www.dropbox.com/s/8edbk8rcp3...mple.xlsm?dl=1
Bookmarks