Hello, i have a report of 50 plus columns which i use, I have set up to transpose the information i require into a new worksheet, sample of code is below. my question is the data on the main report comes in date order ( submission date) no filtering or sorting has been done, however when i...