Copy and Paste data from 1 file to a another file RRS feed

  • Question

  • Hi Team, 

    Can u please help me on how can I copy column from 1 workbook to another workbook.

    Please note the name of the workbook gets changed on daily basis?




    Thursday, April 11, 2013 10:23 PM

All replies

  • Try like that:

    Workbooks(ActiveWorkbook.Name).Sheets(ActiveSheet.Name).Columns(5).Copy _
    Workbooks(Format(Now, "MM-DD-YYYY")).Sheets("DestSheetName").Columns(5)

    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Friday, April 12, 2013 5:37 PM
  • Hi, 

    Thank You for your reply. But Sir, I am trying to create a code for the following 

    1) I am working on a file for work allocation for the entire team member I have. 

    Procedure “

    I receive work from my boss in an excel workbook and the name of the file is

    "DSMT Exception Report Oct 25 2012 GGN” and I have to save the file in my shared location so that everyone can work on that file.

    After I save the file I also have to allocate the work to each team member in the same workbook. Hence for equal allocation I have create an excel work allocation sheet which allocate to the entire associate equally.

    Hence, I copy the entire cell from that file and paste it in my work allocation workbook" and then distribute it among my team members.

    Now after equal allocation, I copy the name of my team members (column "G") with the heading (SMT Associate) from work allocation and paste it to the main file under the heading of “SMT associate”.

    Now I want to create a macro which can perform this task.



    Friday, April 12, 2013 10:55 PM