Excel Help. Filtered Data Copying

[Kitejumper]

Can anyone help at all with Excel 2003 ?

To save a load of manual inputing, I would like to know if there is a way to copy and paste data from a column on one spreadhseet to another column which has a filter applied to it on a different spreadsheet( i.e the rows are not sequential )

When I copy the unfiltered column data to the other spreadsheets filtered column, Excel still paste the data in to the cells that are hidden.

Is there a way around this ?

Thanks for reading

KJ

 

[Kitejumper]

thanks guys for that, just checked today this reply. I will attempt what you have suggested and let you know if the hours of cut and pasting can be thrown out. cheers

KJ

An example of what I am trying to do.

Spreadsheet 1 . - It has a filtered view ( Column A )on to show only rows not containing data . The aim is to copy the unfilterd view data from spreasheet 2 into Spreadsheets 1's Column B


Column
RowAB
1
3
4
14
22
36
40
41
42
43


Spreadsheet 2 - It has no view filter on and I want to copy column B from this spreadsheet into column B of spreadsheet 1

A B
Row
1 101
2 102
3 103
4 104
5 105
6 106
7 107
8 108
9 109
10 110


So in the end when I paste the data in it should look like this:

Spreadsheet 1

A B
Row
1 101
3 102
4 103
14 104
22 105
36 106
40 107
41 108
42 109
43 110


I hope this helps to explain the situation.

Cheers again

KJ