Macro that helps copying filtered data in file A and paste to file B ?

[achimeda]

I'm working with 2 files: file "Liver1" & "Liver2" (excel 2010)

Here are what they look like

Liver1
\1

Liver2
\1

My task:
1) Filter customer A column in file Liver1 to get the numbers only
2) Copy Prod.Name, Prod.Code and those numbers and paste to file Liver2 (see picture)
3) Back to file Liver1, unfilter customer A column, filter customer B column and repeat.

My problem is I have to deal with a large numbers of prod.codes and customers everyday so I think I shouldnt copy them manually.
I'd be appreciate if anyone could help me to solve this : )

My sample files attached belowLiver2.xlsxLiver1.xlsx

Pls notes:
I receive file Liver1 from my colleagues everyday and file Liver 2 is used to store data in one month

[jolivanes]

Have a look at SpecialCells(xlCellTypeVisible)

[achimeda]

Have a look at SpecialCells(xlCellTypeVisible)

Thks for ur comment

But Im afraid I cant code my own macro cuz my vba knowledge is not enough to do that