+ Reply to Thread
Results 1 to 1 of 1

Macro for copying specific values from one excel file to another

  1. #1
    Registered User
    Join Date
    02-25-2013
    Location
    L.A
    MS-Off Ver
    Excel 2010
    Posts
    19

    Macro for copying specific values from one excel file to another

    I have attached my workbook (Data_CIMDO_Sub_SovBank).

    What I wish to do is the following steps: I have attached another workbook (Book1) which illustrates what I want to achieve in the following steps.

    1. In the workbook Data_CIMDO_Sub_SovBank there are 3 sheets, PD, COV and DT. First, in the PD sheet, I select the row beginning with "AUT5" and copy only the values in that row into Book1 (open Book1 -> PD worksheet to see what I mean). Then back to the workbook Data_CIMDO_Sub_SovBank, I select the row beginning with "EBG5" and again copy only the values in that row into Book1.

    2. In the COV sheet of Data_CIMDO_Sub_SovBank, I want to select a 2 by 2 matrix which is defined by the names of the rows I selected in step 1, that is, I want a 2x2 matrix formed by the following values (AUT5, AUT5) = cell B2, (EBG5, AUT5) = cell B12, (EBG5,EBG5) = cell L12 and (AUT5, EBG5) = cell L2. I then want to copy this matrix into Book1 (open Book1 -> COV worksheet to see what I mean).

    3. Finally in the DT sheet of Data_CIMDO_Sub_SovBank, I want to select the value next to AUT5 and copy into Book1 (open Book1 -> DT worksheet to see what I mean). Similarly, I also want to copy the value next to EBG5 in Data_CIMDO_Sub_SovBank into Book1.

    Now I want to repeat steps 1 to 3 with AUT5 fixed but cycle through EBG5, RBI5, DEX5, ..., until ESFG5 and I want each cycle to be done in a new workbook. For example, Book1 is for AUT5/EGB5, Book2 will be for AUT5/RBI5, ... until Book24 will be for AUT5/ESFG5.

    Thanks so much, I have no idea how to code this up, please let me know if you want me to explain what I mean further.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to copy specific line from text file and paste into specific cell in excel
    By keeneye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:35 AM
  2. Copying over specific values when a specific value is entered.
    By jampy00 in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 12-11-2012, 01:23 PM
  3. MACRO for Copying specific values from multiple sheets
    By planetrisk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-24-2012, 11:42 AM
  4. Macro for copying specific data from excel files in a folder to a newly created excel file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2012, 02:24 PM
  5. [SOLVED] Macro to copy only specific data from a txt file to an excel file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 48
    Last Post: 04-13-2012, 02:11 AM

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