I'm coding a VBA Sub that populates a new Excel workbook with data from my current Excel workbook, by using the 'Data' sheet in my current workbook as a ADODB. However, the newly-populated sheet has missing data in some cells.
All the relevant rows and columns are retrieved, with the right...