Copying column open Excel Workbook to another open Workbook RRS feed

  • Question

  • I am trying to paste a column from ONE WORKBOOK TO ANOTHER which is in some other location

     I have a workbook in my shared folder and the file name gets changed on daily basis.

    Format of the file name saved in shared folder: “DSMT Exception Report Oct 25 2012 GGN”

    Hence I have place some cell in my project worksheet that is

    1.       I21 as File Name
    2.       J21 as File location
    3.       L21 as worksheet  (that is CHGBW, CHGBRW, REPRW, STAR, PULSE, NYCE)

    I want to save column (G) from my workbook file that is “SMT associate” to the specific location mention in above cell and search for the heading that “SMT Associate” and paste the entire column from my workbook to that file 

    Thank You


    Tuesday, April 9, 2013 10:30 PM