1
Worksheets("TnxDump").Range("A" & i & ":V" & i).Copy Worksheets("TnxSales").Range("A" & lastrow & ":V" & lastrow)

For dates less than 12th - month and day are interchanged while pasting. Like 06-Aug-2015 is converting into 08-June-2015

Vasily
  • 5,707
  • 3
  • 19
  • 34
laksh1987
  • 11
  • 2

1 Answers1

0

Please can you confirm the format of the dates in the TnxDump worksheet.

Also as a starting point take a look here: Excel 2010 - change US dates to UK format

Community
  • 1
  • 1
5202456
  • 966
  • 14
  • 24