VBA to copy only certain filtered column to another workbook

Copper Contributor

Hi all,

Could somebody help me?


I am trying to write a VBA code that would allow me to the below :

  • Copy the values of filtered column F,P,T,V from workbook "Sales"-> sheets "Data" without header 
  • Paste the values to another workbook "Sales summary"-> sheets "Data1"->column B,D,H,K respectively in the last row.

    I have attached the file for clarity
    Many thanks in advance.
0 Replies