Don't think its possible to do that
But maybe just something like this
in say, C2, copied down: =IF(A2="A",B2,"")
would suffice?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"TWT" wrote:
I filter out rows and copy data from the filtered rows. However, when I
paste the data onto another column, the data gets pasted on the rows which
are hidden. How can I ensure that the data is pasted onto the same rows?

Eg. I have 3 rows of data:

Name Amount Column 1 Amount Column 2
Row 1 A $2
Row 2 B $5
Row 3 A $6

After filtering for Name = A, the spreadsheet will show only datas on Rows 1
and 3.

This shows:
Name Amount Column 1 Amount Column 2
Row 1 A $2
Row 3 A $6

Now, I want to copy $2 and $6 onto Amount Column 2, so I highlight the two
cells and click on 'Copy'.

However, when I paste the amount on 'Amount Column 2', it will appear as:
Name Amount Column 1 Amount Column 2
Row 1 A $2 $2
Row 3 A $6 (Blank)

... Because the $6 has been posted onto Row 2, which, when i unfilter all,
will show:
Name Amount Column 1 Amount Column 2
Row 1 A $2 $2
Row 2 B $5 $6
Row 3 A $6

How can I make sure that, with the filter still on, the $6 gets pasted onto
Row 3?