Hi i cant upload a macro enable spreadsheet? Is there a reason for this?
I've uploaded the sheet with macros disabled. So you can see my problem.
What i want to do is;
- Export data from the 'Production' tab using a macro, which will fill the 'Data' tab, i've wrote a macro for this and it works fine.
- The 'Data' tab has a 'update dates and times' macro which looks at the 'Report' tab to see what the date is and the dates and times adjust from the date input. I've written the macro and it works fine.
- The remove spaces macro is where I'm having trouble. I'm looking to do this so that a vlookup will look at the data from the exported production macro and return a value in column M so. The issue i'm having with my macro is that the date and month alternate between dd/mm/yyyy and mm/dd/yyyy on every row so the vlookup doesnt work.
Does this all make sense?
Solved by K. C. in 25 mins