I have a filtered list in "file 1", and want to paste some data from "file
2", next to the filtered values in "file 1". I'm unable to do so, as the
values are getting pasted in-between the cells. Please assist.

I use Excel 2003.