I just checked it again and its actually copying the data from 1.3 - 1.9 and pasting it into format sheet. I am not sure who this Ron person is to be honest. and the sample file i uploaded its a dummy file. not the actual file i am working with. its all happening in one workbook. I am not pasting the file into diff workbook.