How do I Copy and Paste onto Same Rows after filtering out rows.

[TWT]

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.

 

[ShaneDevenshire]

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.

 

[Max]

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