Pasting data in a filtered list

[LaundroMat]

Hi,

I'm looking for a way to paste data into a sheet where data has been filtered.

Eg:

Sheet1:
1| A
2| B
3| C
4| D

Sheet2 (filtered data):

1| 10
3| 30
7| 70
8| 80

I want to paste the column from Sheet1 onto Sheet2, so that it will read:

1| 10 A
3| 30 B
7| 70 C
8| 80 D

Sorting is not an option, as it's essential that I keep the order the rows are in in their original state.

Many thanks,

Laundro.

 

[GlennUK]

You can paste from a filtered list, but you can't paste into one the way you want. Do you have any unique identifiers in your filtered list? If so, you could paste those from the filtered list into Sheet1, and then fill the required column in the filtered list with a lookup ( INDEX(MATCH for example ), to fetch the data from Sheet1 according to the unique identifier. Just an idea.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.