Solved! Can't fully copy excel data collum range to another workbook

[karthick_kyo]

Hi, I have a workbook whr I want to copy 1 whole range of collum to anther workbook. But it only pastes a certain range only. Example when I copy cell from A1 to A300 and paste it to another workbook, it copies only A1 to A235 skipping a certain section of the data in between causing it not to tally from the previous excel file.

Pls help thanks.

 

[USAFRet]

Hi, I have a workbook whr I want to copy 1 whole range of collum to anther workbook. But it only pastes a certain range only. Example when I copy cell from A1 to A300 and paste it to another workbook, it copies only A1 to A235 skipping a certain section of the data in between causing it not to tally from the previous excel file.

Pls help thanks.

How are you selecting the data to copy?
Click on the "A" header and copy. See what happens.