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


T

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.
 
Ad

Advertisements

S

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top