VBA to copy only certain filtered column to another workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1513537%22%20slang%3D%22en-US%22%3EVBA%20to%20copy%20only%20certain%20filtered%20column%20to%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1513537%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3ECould%20somebody%20help%20me%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20am%20trying%20to%20write%20a%20VBA%20code%20that%20would%20allow%20me%20to%20the%20below%20%3A%3C%2FP%3E%3CUL%3E%3CLI%3ECopy%20the%20values%20of%20filtered%20column%20F%2CP%2CT%2CV%20from%20workbook%20%22Sales%22-%26gt%3B%20sheets%20%22Data%22%20without%20header%26nbsp%3B%3C%2FLI%3E%3CLI%3EPaste%20the%20values%20to%20another%20workbook%20%22Sales%20summary%22-%26gt%3B%20sheets%20%22Data1%22-%26gt%3Bcolumn%20B%2CD%2CH%2CK%20respectively%20in%20the%20last%20row.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20attached%20the%20file%20for%20clarity%3CBR%20%2F%3EMany%20thanks%20in%20advance.%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1513537%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

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