Copy/Pasting Column from one spreadsheet to another

Hello. I need to copy a column (vertical) within 1 spreadsheet that has over 1000 cells to another spreadsheet that I filtered to have the same amount of cells (I hope it does have the same amount of cells).

The column of cells in spreadsheet 1 has formulas, but I only need the value, so I do a special paste and click only value show. But when I do paste it on the new spreadsheet, it does not completely copy the column. I realized that it does not copy any values that repeat (ex: the column of cells has these values: .01, .01, .02, .01, .03, .02, .03 ; and when I copy/special paste them in a new column in another spreadsheet, it only pastes .01,.02,.03)

I would not like to do this manually, so any help would be greatly appreciated! Thank you

When pasting to a sheet with filtered or hidden rows the cells you paste will be pasted into the hidden row also. If you turn off your filter you will probably see the missing values in the rows that where filtered out.

I suggest that you try to sort your destination sheet so you get your destination rows as a continous range of rows. Then you can paste into these rows without filtering.