Copy column from one spreadsheet to a different spreadsheet that is filtered

[elkerpride]

Hello -

I have a column in a spreadsheet I need to paste onto another spreadsheet. The 2nd sheet is filtered, and I only need to paste on the showing/visible cells.

In the below example, I filter the destination (Bottom) sheet to only show one account number each name, the remaining 3 for each is hidden. I need to past the color column from origin (top) sheet into a column on the filtered sheet.

Can this be done?

Thanks!

account number	Name	Color
1234	Name 1	Blue
4567	Name 2	Green
7890	Name 3	Red
1475	Name 4	Yellow

account number	Name
1234	Name 1
1234	Name 1
1234	Name 1
1234	Name 1
4567	Name 2
4567	Name 2
4567	Name 2
4567	Name 2
7890	Name 3
7890	Name 3
7890	Name 3
7890	Name 3
1475	Name 4
1475	Name 4
1475	Name 4
1475	Name 4

 

[elkerpride]

Am I not making sense with this question or can it not be done?

 

[Akuini]

@elkerpride
Please check out this article:
Excel VBA: easy way to paste to visible cells