Results 1 to 10 of 10

Macro to copy values from specific columns from different workbooks to one sheet

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    7

    Macro to copy values from specific columns from different workbooks to one sheet

    Need help real badly, i have to prepare summary report of simulator boxes utilization and prepare trend charts. For this need help on macro.

    Multiple input files(can be in one single directory c:/tmp/): File_date1.xls, File_date2.xls, File_date3.xls, File_date4.xls... 30 files

    Another catch is min, max and avg are formula in input sheet, however need to copy only value to master sheet.

    Sample File_date1.xls file, here every alternate column data is required. physical location between box1 and box2 data is fixed:
    A B C D E F G H I J K
    Box1 xx xx Box2 xx xx Box2 xx xx BoxN
    Min 1 xx xx 1 xx xx 1 xx xx 1
    Max 4 xx xx 4 xx xx 4 xx xx 4
    Avg 3 xx xx 3 xx xx 3 xx xx 3

    required master_file.xls in following format using above multiple files using macro:

    A B C D E F G H I J K
    Box1_Date1 Box1_Date2 Box1_Date3 Box1_Date4 .. ..
    Min 1 1 1 1
    Max 4 4 4 4
    Avg 3 3 3 3

    Box2_Date1 Box2_Date2 Box2_Date3 Box2_Date4 .. ..
    Min 1 1 1 1
    Max 4 4 4 4
    Avg 3 3 3 3

    Box3_Date1 Box3_Date2 Box3_Date3 Box3_Date4 .. ..
    Min 1 1 1 1
    Max 4 4 4 4
    Avg 3 3 3 3

    ..
    ..
    BoxN_Date1 BoxN_Date2 BoxN_Date3 BoxN_Date4 .. ..
    Min 1 1 1 1
    Max 4 4 4 4
    Avg 3 3 3 3
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1