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

 

[wonder_lander]

Can you give an example?

 

[whitecrook]

probably not, as the filter you talk of is probably the View filter? It does as it says, it's only a filter for the view and doesn't affect the data.

You may be able to use the option in the Edit menu I think called Go (i think) which allows you to 'go' to all cells matching specific parameters and then copy only that data. ( I use it to select all blank cells for deletion)


Alternatively you could put a Special column beside your filtered list, eg. 'a', then copy that colunm to your other list of data, then create a new colum which copys the data you want copied only if there is an 'a' there beside it. Then copy paste that new colum values only to the new place. Don't know if that'll work but it's a suggestion

 

[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