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?

Many thanks.

Hi,

You can't control that during the Paste command, you may need to modify the
resulting output afterwards. Alternatively you could use VBA. Let us know
if you want a macro solution. I'm at work and so I won't be looking back at
this till this evening but someone else may respond.
--
Thanks,
Shane Devenshire


"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?

Many thanks.

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?