How to paste data over hidden cells by a filter

[axel_jorje]

Hi,
Could you please help me with a hint for my problem or maybe you can make a tutorial with it. How to paste some data over hidden cells by a filter
So i have one table with 3 columns A,B and C and 10 rows. In column A i have Name, in column B i have AWB and in column C Total. In column C i need to fill some data. In column A , I have 2 names, 5 rows with Alex and 5 with George. In the AWB I have some random numbers. I've filtered column A by Alex. Now i should copy some data in C column only for those 5 rows with Alex, but when I paste it, data goes over the hidden cells by the filter.
How can i solve this so data can be filled when I paste it only on that selected rows?

 

[kadri1234]

Sort the "Name" Column

 

[Fernando Madrid]

Hi

When you want to copy only some data after filtering your list you need to sort it before as kadri1234 says.

We need one after the other, Alex in your example, that's why we need to sort the list before copy/paste.

If you don't want to change the sort of your list you can get what you want with a formula which will work as a filter.

Name = A1 in the table shown below.

[TABLE="width: 318"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]AWB[/TD]
[TD]Total Alex[/TD]
[TD]Total George[/TD]
[/TR]
[TR]
[TD]Alex[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]George[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]Alex[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Alex[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]George[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]George[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]Alex[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]22[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Alex[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]George[/TD]
[TD="align: right"]34[/TD]
[TD][/TD]
[TD="align: right"]34[/TD]
[/TR]
[TR]
[TD]George[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[/TR]
</tbody>[/TABLE]


formula in C2 = IF(A2="Alex";B2;"") -- Copy it down and you'll get the total amount only for Alex
formula in D2 = IF(A2="George";B2;"") idem for George[TABLE="width: 87"]
<tbody>[TR]
[TD="width: 87"][/TD]
[/TR]
</tbody>[/TABLE]