+ Reply to Thread
Results 1 to 24 of 24

Copying columns from one workbook to another

  1. #1
    Registered User
    Join Date
    04-27-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    19

    Copying columns from one workbook to another

    Hello - I think this is one those days when I realize there people with mad VBA skills that I need to use for my research project. I am stuck and despite recording a macro I cannot get to do all sheets (A range) into master.
    Two files: FileA and FileB

    Sub CopyPasteRange()
    Workbooks("FileA.xlsx").Sheets("John B").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("John B").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("John B").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("John B").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("John B").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("John B").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("John B").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("John B").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Mark L").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Mark L").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Mark L").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Mark L").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Mark L").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Mark L").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Mark L").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Mark L").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Suzanne A").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Suzanne A").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Suzanne A").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Suzanne A").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Suzanne A").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Suzanne A").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Suzanne A").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Suzanne A").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Eva D").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Eva D").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Eva D").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Eva D").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Eva D").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Eva D").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Eva D").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Eva D").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Bello").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Bello").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Bello").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Bello").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Bello").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Bello").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Bello").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Bello").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Beatrice").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Beatrice").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Beatrice").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Beatrice").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Beatrice").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Beatrice").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Beatrice").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Beatrice").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Levi").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Levi").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Levi").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Levi").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Levi").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Levi").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Levi").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Levi").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Riverforte").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Riverforte").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Riverforte").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Riverforte").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Riverforte").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Riverforte").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Riverforte").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Riverforte").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Clif").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Clif").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Clif").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Clif").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Clif").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Clif").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Clif").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Clif").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Lee S").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Lee S").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Lee S").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Lee S").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Lee S").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Lee S").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Lee S").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Lee S").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("John S").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("John S").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("John S").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("John S").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("John S").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("John S").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("John S").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("John S").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Iain").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Iain").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Iain").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Iain").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Iain").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Iain").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Iain").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Iain").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Vic P").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Vic P").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Vic P").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Vic P").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Vic P").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Vic P").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Vic P").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Vic P").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("India").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("India").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("India").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("India").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("India").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("India").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("India").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("India").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Singh").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Singh").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Singh").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Singh").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Singh").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Singh").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Singh").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Singh").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Pranav").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Pranav").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Pranav").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Pranav").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Pranav").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Pranav").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Pranav").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Pranav").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Ling").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Ling").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Ling").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Ling").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Ling").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Ling").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Ling").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Ling").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Fungo").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Fungo").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Fungo").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Fungo").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Fungo").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Fungo").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Fungo").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Fungo").Range("V:V")
    Workbooks("FileA.xlsx").Sheets("Engel").Range("H:H").Copy Workbooks("FIleB.xls").Sheets("Engel").Range("S:S")
    Workbooks("FileA.xlsx").Sheets("Engel").Range("I:I").Copy Workbooks("FIleB.xls").Sheets("Engel").Range("T:T")
    Workbooks("FileA.xlsx").Sheets("Engel").Range("J:J").Copy Workbooks("FIleB.xls").Sheets("Engel").Range("U:U")
    Workbooks("FileA.xlsx").Sheets("Engel").Range("K:K").Copy Workbooks("FIleB.xls").Sheets("Engel").Range("V:V")

    End Sub


    I want to combine two workbooks into one by copying Round 2 survey results from "FileA" into the master workbook FileB. The tabs are named the same (same respondents). I just want to copy the columns that are part of Round 2 plus the comments in FileA after the Comments section.

    The reference terms are consistent.Is it possible to create a macro that will copy all sheets Round 3 fileA into FileB?

    Thank you so very much for any input/help.
    Attached Files Attached Files
    Last edited by wanian7; 08-06-2015 at 10:21 PM.

  2. #2
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Hi wanian7,
    . It is almost certainly possible to copy / consolidate data from 2 sheets into 1 with VBA.
    . But It is very unclear exactly what you want.
    .
    . You seem to have given a File B with reduced sample data, and that is good.
    . It is not clear what you are talking about by “Round 2“
    . .....
    . The one FileA that you have uploaded appears empty?
    .
    . You need to supply two FileA’s, a Before and an After
    .
    . The Before should look just as it does before running of any macro.
    .
    . The After should be hand filled by you so that it looks exactly as you want it to After running of any macro that we do for you, based on the actual sample data you supply in FileB.
    .
    . It is most likely then that any code we do for you would then also work on much bigger files with more data and more sheets .

    . Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  3. #3
    Registered User
    Join Date
    04-27-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    19

    Re: Copying columns from one workbook to another

    Dear Alan,
    File B is the master file where we are compiling results of everyone's findings individually and providing qualitative points.
    File A is compilation of everyone's results for Round 3. I need to bring in all Round 3 results into workbook FileB. Problem is every student mixed the questions up and if I do a blind column copy without matching it with the question number also called "SPII" then they will be mixed in the copying and pasting.

    Basically each student has a spreadsheet in Master FileB and FileA is Round 3 with High Medium and Low columns under it.
    An Example is John B where his results for Round 3 have been matched from FileA to FileB. I already have the headers in each persons tab. I have uploaded sample files the replicate the scenario (Not sure if it can scripted with the copying and pasting starting under the ranking and matching to "SPII" for the right question.

    I hope these helps and thank so much for your comments and for reviewing post with helpful feedback.

    Thank you.
    Attached Files Attached Files
    Last edited by wanian7; 08-06-2015 at 10:18 PM.

  4. #4
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Hi wanian7,

    . Ok, the info from Post #3 makes it much clearer, Thanks
    .
    . Based on the example you gave, i think it will be easy to write a code to reproduce that.
    .
    . I will take a look at it later for you


    . Some Questions:

    . 1) Are the tabs always in the same order in both files? Or can this vary?

    . 2a) Are there always 8 questions ( as determined by column F ) in File A ? Or can this vary?
    . 2b) If the number can vary, would it be the same for all persons for the same Round ?
    , 2c) Would the order of the questions ( as determined by "SPII" ( Column F FileA ) ) be the same for all persons in a Round? Or can that vary?

    . 3) I do not quite understand what you mean here?

    Quote Originally Posted by wanian7 View Post
    ...... (Not sure if it can scripted with the copying and pasting starting under the ranking ........
    ... can you explain that again please?

    . 4) I am not sure what the significance of The Points in FileB is ?

    Using Excel 2007
    Row\Col
    W
    X
    Y
    1
    2
    3
    Points
    4
    5
    Beatrice

    ... is there any significane that I should know about that?

    Alan
    Last edited by Doc.AElstein; 08-07-2015 at 06:20 AM. Reason: Added question . 2c)

  5. #5
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Hi,

    . OK, I have an initial code for you:


    Some initial remarks, assumption:
    .
    . 1) I assume that file A is a typical “Round” File. ( I have renamed it in my Folder as “Round3” and refer to it from now as File “Round3” )
    . 1a) I assume that following files ( Round4 , Round5 ... etc.. ) will always have similar formats to “Round3”. I will refer to thes files as “Round3” or Round File or Round Files

    . 2) I will refer to File B from now on as the “FileBMaster” or “MasterB” Or Master.
    . 2a) I will assume for all persons the unique question reference numbers in column I ( “SPII” ) are identical for all persons in the FileBMaster
    . 2b) I will assume this list may be added to at a later date, that is to say the reference numbers could extend further down.
    . 2c) I assume the general characteristics of all sheets in Master are the same (Only differing in the practice by the data in the 4 columns ( High, Medium, Low, Comments )

    .3 ) I will assume that further “Rounds” are added in FileBMaster alongside and touching ( to the right) of the last Round Entries, that is to say the new round data is offset form the last round data by 4 columns, and zero rows, that is to say starting on the same row.
    .3a) I note that you have already included headings for round 3, but I will assume the start point is thus: ( for all sheets in Master )

    Using Excel 2007
    Row\Col
    O
    P
    Q
    R
    S
    T
    U
    V
    2
    3
    Round 2 Quantitative Ranking
    Comments
    4
    High Medium Low
    5
    0
    1
    0
    6
    1
    0
    0
    7
    0
    1
    0
    Asked
    8
    1
    0
    0
    9
    0
    0
    1
    Cocomet
    10
    1
    0
    0
    11
    0
    0
    1
    ML
    12
    0
    0
    1
    John B

    . Note heading “Comment” should be in row 3.

    . 4) I assume that for Round files the new data always starts in cell H5 ( 5 , 8 ) , and that the question reference numbers start in cell F5 ( 5 , 6 )
    . 4b) I assume the number of rows of data will be equal to that of the rows in the unique question reference numbers column I ( “SPII” ) in Master

    . 5) In abscence of your answerers to my questions I assume a few other things for now such as that sheets are in exactly the same order in both Files
    .
    ............................

    .. So, anyways I have a first shot of a code that seems to work. For example taking the start Point as that spreadsheet screen shot I gave above, and running the code with , for example, your test data for the Round Sheet of..

    Using Excel 2007
    Row\Col
    F
    G
    H
    I
    J
    K
    2
    3
    Round 3 Quantitative Ranking
    Comments
    4
    SPII V High Medium Low
    5
    402F
    0
    0
    1
    6
    403A
    0
    0
    1
    7
    405A
    0
    1
    0
    WAHR
    8
    405C
    1
    0
    0
    9
    405P
    1
    0
    0
    10
    406B
    0
    1
    0
    11
    407D
    1
    0
    0
    12
    408Q
    0
    0
    1
    13
    14
    John B

    ....
    I get this in the first sheet:

    Using Excel 2007
    Row\Col
    S
    T
    U
    V
    2
    3
    Round 3 Quantitative Ranking
    Comments
    4
    High Medium Low
    5
    0
    1
    0
    WAHR
    6
    1
    0
    0
    7
    0
    1
    0
    8
    1
    0
    0
    9
    0
    0
    1
    10
    1
    0
    0
    11
    0
    0
    1
    12
    0
    0
    1
    13
    John B

    ... That result ties up with what you gave as sample output. I also ran the code for the entire file and it appears at first glance to work correctly and give the correct results.
    . see how you get on with it, and we will maybe discuss any problems or changes later..

    Alan


    Code in next Thread Post # 6
    Last edited by Doc.AElstein; 08-08-2015 at 08:38 PM.

  6. #6
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Code for post # 5


    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    04-27-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    19

    Re: Copying columns from one workbook to another

    Hi Alan,
    Sorry I got tardy in response to the questions.
    1. I have put the order of tabs(sheets) in round three to be the same as the master file, but I know they were not the same order when they were compiled by one of the other teaching students.
    2a. The questions can vary, we tried to have the students have a minimum of 8 questions but each question is weighted differently in the qualitative review. I think for the purpose of this each question has a unique ID and will remain the same for each student from round 3.
    2b.The number can vary- but should be the same for each student.
    2c. The order of questions may vary, but are the same for each person. Example a question may be in row 15 for the student file and row 13 in the master depending on how each student approached the survey.
    3. I meant to ask or suggest that since I have headers of ranking - High, Medium and Low can the macro be able to see that and paste the results in the right cell under the right rank... Just an idea.
    4. Points no significance just that we usually have a comments and points column after the round results.

    Again, thank you so much. I really appreciate it.

    Kind regards,

    Ian

  8. #8
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Hi Ian,

    Quote Originally Posted by wanian7 View Post
    Hi Alan,
    Sorry I got tardy in response to the questions.
    1. I have put the order of tabs(sheets) in round three to be the same as the master file, but I know they were not the same order when they were compiled by one of the other teaching students.
    ... the code could be adapted to allow for the different order as long as the spelling of the names is always the same, or at least for the first few characters in the name
    2a. The questions can vary, we tried to have the students have a minimum of 8 questions but each question is weighted differently in the qualitative review. I think for the purpose of this each question has a unique ID and will remain the same for each student from round 3.
    2b.The number can vary- but should be the same for each student.
    2c. The order of questions may vary, but are the same for each person. Example a question may be in row 15 for the student file and row 13 in the master depending on how each student approached the survey.
    .. the code allows for that and reorders the rows accordingly before pasting into the Master
    3. I meant to ask or suggest that since I have headers of ranking - High, Medium and Low can the macro be able to see that and paste the results in the right cell under the right rank... Just an idea.
    - the code already does that – I tested it several times and it continually adds data to the right exactly as I think you want
    4. Points no significance just that we usually have a comments and points column after the round results.
    - I deleted that bit, that is to say the code overwrites that as it pastes in the new info - the code can easilly bee modified so as not to remove that - It would than enter to the right of anything else, (regardless of what row if, if any , thers is any info in. - It would simply paste in at the next fully free column. So the offset to the right could vary each time depending on exactly what extra info is to the right of the last inserted data)

    ......
    . Try the code and See how you get on. Then let me know of any problems or modifications you wish, and i will take another look at it later..

    Alan
    Last edited by Doc.AElstein; 08-08-2015 at 09:02 PM.

  9. #9
    Registered User
    Join Date
    04-27-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    19

    Re: Copying columns from one workbook to another

    Dear Alan, After several attempts of trying to curtail this to the files, it seems to be hang up on pasting in the same range of columns and inaccurate rows. Below is the adjustment I made....

    Option Explicit
    Sub GetRoundToMasterB()
    ' 1 ) Some Initial Info sheet info
    Dim wbMaster As Workbook: Set wbMaster = ThisWorkbook 'Give the abbreviation for the Wofkbook in which this code is all methods, Properties etc of VBA Workbook Object through .Dot
    Dim wbRnd As Workbook: Set wbRnd = Workbooks("Round3.xlsx") 'I changed this to the workbookname Research_Methods.xlsx
    Dim ws1 As Worksheet: Set ws1 = wbMaster.Worksheets.Item(1) 'No edit
    Dim lMc As Long: Let lMc = ws1.Cells(3, Columns.Count).End(xlToLeft). ' THIS I SUSPECT TO BE MY PROBLEM...My first counting row with the Round 1, Round 2 data is 24 so I changed it to Row 24
    Dim luQr As Long: Let luQr = ws1.Cells(Rows.Count, 9).End(xlUp).Row ' I changed the 9 to 2 because my question reference ID is now in column 2 with the header in row 25 and the first question code in cell 26,2
    Dim uQMr() As Variant 'This will become an Array of the question reference numbers - must be given variant dimension to allow the range assignment that will become an Array in the next VBA allowed "one liner" - It "becomes an Array" as VBA guesses that is what should be returned. But as it recives a range Object initially which could be anything it must be Variant
    Let uQMr() = ws1.Range(ws1.Cells(5, 9), ws1.Cells(luQr, 9)).Value2 "I changed to 26,2 because my question ID is in cell 26.2 column 2 so LuQr, 2)
    '
    ' 2 ) Loop through sheets... and..
    Dim Cnts As Long, clm As Long, rwM As Long, rwR As Long '
    Dim uQRr() As Variant 'This will become an Array for the question reference numbers in the Round sheet
    Dim arrR() As Variant, arrM() As Variant 'Initial Data Array from Round file, reordered file for input in Master
    Dim rws() As Long: ReDim rws(1 To UBound(uQMr(), 1), 1 To 1) 'This IS an Array ( known size to be filled in with looping so undynamic and can have its indicies dimensioned appropriately ) , in which we place indicies representing the "row" number in the Round data array corresponding to the index of that referrence number in the master referrence number list
    Dim clms() As Variant 'This is another Dynamic Array, It will become a 1 dimensional Array of "column" indicies through assignmant to the VBA Array( ) Method, so it must initially be a variant as the only thing that can store an Array ( what is returned by the VBA Array Method ) is the Variant
    '..2a) get unordered referrence number column and unordered Data range=====
    For Cnts = 1 To wbMaster.Worksheets.Count
    With wbRnd.Worksheets.Item(Cnts)
    Let uQRr() = .Range(.Cells(5, 6), .Cells(luQr, 6)).Value2 'I changed to 26,2 because the round files had been modified with the uniquest question ID falling in column B and the first row of Unique ID was 26
    Let arrR() = .Range(.Cells(5, 8), .Cells(luQr, 11)).Value2 ' I changed to (.Cells(26, 16), .Cells(luQr, 19)) because this is the range I need copied from the round 3 file to the the master.
    End With
    '==========================================================================
    '..2b) Build the Rws() Array================================
    For rwM = 1 To UBound(uQMr(), 1) Step 1
    'rws(rwM, 1) = Application.WorksheetFunction.Match(uQMr(rwM, 1), uQRr())
    For rwR = 1 To UBound(uQMr(), 1) Step 1
    If uQMr(rwM, 1) = uQRr(rwR, 1) Then 'Match condition so ..
    rws(rwM, 1) = rwR '..give appropriate match "column" indicie
    Else 'No Match, do nothing, redundant code
    End If
    Next rwR
    Next rwM
    '===========================================================
    '..2c) Make a reordered Array from the unordered Array=============
    Let clms() = Array("1", "2", "3", "4") 'This returns a 1 dimensional Array of our ( ordered ) column indicies
    Let arrM() = Application.Index(arrR(), rws(), clms()) 'Exactly how this works is still not quite clear to me... see for example : Post #22 http://www.excelforum.com/excel-prog...ing-vba-2.html
    '==================================================================
    '
    ' 3) Write results to Master File
    wbRnd.Worksheets.Item(Cnts).Range("H3:k4").Copy 'Changed to P24:S25 as the columm headers required for round three.

    wbMaster.Worksheets.Item(Cnts).Cells(3, lMc + 1).PasteSpecial Paste:=xlPasteAllUsingSourceTheme 'Changed to (24, lMc + 1)

    Let wbMaster.Worksheets.Item(Cnts).Cells(5, lMc + 1).Resize(UBound(arrM(), 1), UBound(arrM(), 2)).Value = arrM() 'changed to (26, lMc + 1) *****PROBLEM WHEN I CLICK ON (lMc + 1) it shows me that my destination would be column 11 which is wrong as it is overwriting on data. The next blank cells in the master is *QRST with headers in rows 24 and 25 and data in cells 26. This is for all master sheets.
    Next Cnts 'Finished with one sheet, go back and do next
    End Sub

    Is there away to use column headers as the lead in to start the copy and pasting? Example row P25 has the Comments and M24 has a merged header "Round 2" that extends to P24. Is it possible to make it copy Round 3 in a selected range? of the Master spreadsheet? which ensuring the question ID are aligned?

    Thank you again for the help.

    wanian7

  10. #10
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Hi wanian7,

    . 1 ) Pleas use code Tags # when posting at ExcelForum - ( See notes in my signature ) -

    Please Login or Register  to view this content.
    ..........................................................................

    . 2 ) I am struggling to understand any of your comments:

    . 2a )
    Quote Originally Posted by wanian7 View Post
    ......
    “THIS I SUSPECT TO BE MY PROBLEM...My first counting row with the Round 1, Round 2 data is 24 so I changed it to Row 24” .........
    .... You have never had anything in any File you gave me in row 24. So I have no idea what you are talking about there...

    ..............

    . 2 b )
    . I have no idea what you are talking about here.
    Quote Originally Posted by wanian7 View Post
    ..... I changed to 26,2 because my question ID is in cell 26.2 column 2 so LuQr, 2) .........

    uQMr() becomes an Array full of the question reference number as you gave them in the correct order in the Master File B

    Using Excel 2007
    Row\Col
    I
    5
    405A
    6
    405C
    7
    406B
    8
    407D
    9
    408Q
    10
    405P
    11
    403A
    12
    402F
    John B

    .........................................

    . 3 )
    . 3 a )
    Quote Originally Posted by wanian7 View Post
    ...... Is there away to use column headers as the lead in to start the copy and pasting? Example row P25 has the Comments and M24 has a merged header "Round 2" that extends to P24. Is it possible to make it copy Round 3 in a selected range? of the Master spreadsheet? .......
    . Sorry, but again I have no idea what you are talking about. You are talking again about rows 24 and 25 which have never had any data in in any of the sample files you sent me. It is possible to paste anywhere you want , but you must tell, or rather show, me what you want. I cannot guess ****
    .............................................

    . 3 b)
    Quote Originally Posted by wanian7 View Post
    .......... Is it possible to make it copy Round 3 ......which ensuring the question ID are aligned?.....
    The code I gave you copies as you asked AND reorganises the data and so pastes it in ensuring that the question ID are aligned.

    ...........................................................

    . 4 )

    . The modified code you sent to me does nothing, as the lines shown in red below give me a compiling error. So I have no idea exactly how you modified my code:

    Please Login or Register  to view this content.
    .............................................

    .. ****I suggest you try again to send me 2 versions of FileB Master. And send again File A, possibly with some more representable data.
    . IMPORTANT:
    For the two FileB Master Files
    . – 1 should be the Before... It should look like it does before the macro is run to take in Round 3 results.
    . – The other should look exactly as you want it after running of the macro, based on the sample data in File A that you give me

  11. #11
    Registered User
    Join Date
    04-27-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    19

    Re: Copying columns from one workbook to another

    Dear Alan, Thank you again for help. I am so sorry for not being clear...I have attached File A as the student round 3 file and File B as a compilation, also I have included an "After Example" file for one of the students.
    These are the actual cells. I wish the macro asked for a "From" and "To" range, I tried modifying yours after realizing along the way there were additions to the template. These are final templates. Note how in the after example the student question reference 406B was not in the same row in the Round File A as to the master and had to make sure its aligned to that number.FileA.xlsxAfter Example.xlsxFileB.xlsx

  12. #12
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Hi,

    Quote Originally Posted by wanian7 View Post
    ......I wish the macro asked for a "From" and "To" range, .......
    .. 1 ). So do you want the code to ask , for example, for the top left cell in which the new Round data is in File A..`
    . Or
    would that always be cell F 24


    . 2) Similarly, do you want the code to ask for the top left cell of where you want the reordered results to come into File B. ?
    Or
    do you always want the latest Round results alongside the last Round results, ( as appears currently to be the case )?


    Alan

  13. #13
    Registered User
    Join Date
    04-27-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    19

    Re: Copying columns from one workbook to another

    #1 - Yes - I believe it would be great if it can ask for the top left cell in which the new round data is in file A as this could change in future rounds
    #2 - Yes - that would really be great to have it ask for the top left cell in which to put the results.

    Again - thank you. I can never get tired of thanking you.

  14. #14
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    War and Peace .. next Chapter... wa___ng with wanian..


    Hi wan_ian,

    .. OK next try...

    . 1 ) I assume for all tabs ( names ) in File B the order of SPII question reference numbers remains the same and are to be found in column B starting at row 26. It may be added to at some time in the future – The code will always look for and find the last entry down in column B. ( The contents of this column are held in a 2 dimensional 1 column Array uQMr() . The code will arbitrarily always reference the range from the first sheet, That is to the say the first tab looking from the left, regardless of its name

    . 2 ) Similarly I assume in File A the SPII question reference numbers are always to be found in column B starting at row 26, ( But the order can be different in ( jumbled up ) and may vary for different names. ) ) . I have modified the code over earlier versions to allow for the possibility of a different number of SPII question reference numbers in different tabs ( names ) in File A

    . 3 ) I assume that the number of the SPII question reference numbers in File A is less than or equal to, but not more than, the SPII question reference numbers in File B
    . 3 a ) ( If the number of the SPII question reference numbers in File A is less than the SPII question reference numbers in File B, then the extra rows in the SPII question reference numbers in File B are not ones that can be found in File A SPII question reference numbers – this point needs a bit of thinking about.... )

    ....................
    . Anyways I did a new code for you....
    . I did my head in a bit , after I thought I was getting strange results from the code...
    . But then I sussed it out
    . 1 ) Your “After” sheet was wrong ( I think )
    . 2 ) In your File B I think someone played a nasty trick on you or me... In the range where the Output should be pasted the background color and the text color were both Yellow – Neat trick.. when my code posted .Values in I thought nothing was coming in!!!!

    .. coming to point . 1)

    Please examine your File A :

    Using Excel 2007
    This From Ians Before FileA
    FileA FileA FileA FileA FileA
    402F
    0
    0
    1
    403A
    0
    0
    1
    405C
    0
    405P
    0
    406A
    0
    0
    407D
    1
    0
    0
    Not sure
    408Q
    0
    0
    405W
    0
    0
    1
    405X
    0
    1
    0
    405A
    0
    0
    1
    Food
    405Q
    0
    1
    0
    405F
    0
    0
    1
    406B
    0
    1
    0
    WAHR
    John B
    ....
    Now look at your File B After.. ( I think Bad results )

    Using Excel 2007
    This From Ians After FileB
    FileB FileB FileB FileB FileB
    405A
    0
    0
    1
    405C
    0
    0
    1
    406B
    0
    1
    0
    WAHR
    407D
    0
    408Q
    0
    405P
    0
    0
    403A
    1
    0
    0
    Not sure
    402F
    0
    0
    405W
    0
    0
    1
    405X
    0
    1
    0
    405A
    0
    0
    1
    Food
    405Q
    0
    1
    0
    405F
    0
    0
    1
    John B
    .....................................
    .... now look at the results my current code gives..( I think Good results ) .. ( With the SPII columns just tacked on here for demonstration.. )

    Using Excel 2007
    FileB FileA This From Alan's Code
    405A 402F
    0
    0
    1
    Food
    405C 403A
    0
    406B 405C
    0
    1
    0
    WAHR
    407D 405P
    1
    0
    0
    Not sure
    408Q 406A
    0
    0
    405P 407D
    0
    403A 408Q
    0
    0
    1
    402F 405W
    0
    0
    1
    405W 405X
    0
    0
    1
    405X 405A
    0
    1
    0
    405A 405Q
    0
    0
    1
    Food
    405Q 405F
    0
    1
    0
    405F 406B
    0
    0
    1
    John B

    .....
    . I think if you check carefully through the rows you will see that my code gives the correct order. Your After has a few rows in the wrong place.

    ......

    Current code in the next Post Post 15
    Last edited by Doc.AElstein; 08-13-2015 at 08:00 PM. Reason: just wanking about.....

  15. #15
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Code for last post. Post 14 It includes the two Input Boxes that come up to ask for the Top left corner of your Header ranges.. as requested.
    . The code appears to fulfil your current request


    Please Login or Register  to view this content.
    Results as Pasted in Johny B.. Good Results....

    Using Excel 2007
    Row\Col
    S
    T
    U
    V
    W
    X
    23
    24
    Comments
    Round 3 Quantitative Ranking
    Comments
    View Category
    25
    High Medium Low
    26
    0
    0
    1
    Food
    27
    0
    28
    Asked
    0
    1
    0
    WAHR
    29
    1
    0
    0
    Not sure
    30
    Cocomet
    0
    0
    31
    0
    32
    ML
    0
    0
    1
    33
    0
    0
    1
    34
    0
    0
    1
    35
    0
    1
    0
    36
    0
    0
    1
    Food
    37
    0
    1
    0
    38
    0
    0
    1
    John B
    Last edited by Doc.AElstein; 08-14-2015 at 04:13 AM. Reason: just wanking again

  16. #16
    Registered User
    Join Date
    04-27-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    19

    Re: Copying columns from one workbook to another

    Dear Alan - I am getting a break at # Let arrR() = .Range(rngTLR.Offset(2, 0), rngTLR.Offset(UBound(uQRr(), 1) + 1, 3)) 'Unordered Round data for this sheet.

  17. #17
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Hi Ian,
    Quote Originally Posted by wanian7 View Post
    Dear Alan - I am getting a break at # Let arrR() = .Range(rngTLR.Offset(2, 0), rngTLR.Offset(UBound(uQRr(), 1) + 1, 3)) 'Unordered Round data for this sheet.
    .. congratulations..
    .. we can all do with a good break sometimes .

    .. But seriously....

    . That does not give me much to go on, - what error do you get? What error number?

    Alan
    Last edited by Doc.AElstein; 08-14-2015 at 03:11 PM.

  18. #18
    Registered User
    Join Date
    04-27-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    19

    Re: Copying columns from one workbook to another

    Its the sticky - Run-time error '1004' Method 'Range' of object'_worksheet' failed at # Let arrR() = .Range(rngTLR.Offset(2, 0), when I bring the cursor it shows zero as in rngTLR.Offset(2, 0)=0.

    After debugging I noticed it did have a results for just the first tab "John B".

    I simply ran it with the files uploaded and made one change of the source file to "FileA".

    What am I missing - Dr Alan? Thanks for the humor sure made an intense moment light for me.

    Additional notes: I unmerged the header cells on row 24 and now getting and error X400!
    Last edited by wanian7; 08-14-2015 at 04:08 PM.

  19. #19
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Ian
    OK. I seem to be getting that error as well now in some files.. I confese I may not have worked through every sheet in every file I have from you. In the previous files I went through all sheetes and had no errors.
    . I will investigate and get back if I find out what the problem is.
    Alan

  20. #20
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    . Hi Ian,
    . I may think I may have supplied you with a pile of wank with that last code. Sorry about that. I had just started learning to use that thing that asks you for the Top left Corner.
    . And I got it a bit wrong. Oops...

    . I think this file is OK, or certainly better.
    . Any more problems, get back , I will take a look tomorrow.
    Alan

    Better code:-


    Please Login or Register  to view this content.
    P.s. It would have been nice if you could have replied to my comments in Post #14 and told me whether your After results or the results I showed from running my code were correct!! But understandable as i supplied you with a load of crap!!
    P.s.2 – Don’t forget what I said about the yellow text and background color in Post # 14 point .2) either

  21. #21
    Registered User
    Join Date
    04-27-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    19

    Re: Copying columns from one workbook to another

    Dear Alan - Thank you so much - as for the Post#14 I completely read over it, and trusted the John B..which worked .

    I want to confirm that the better code in Post#20 works in the mock up files. I used it to run in the real files, it worked for files have of the files and then got the error "Run time error "13" - Type Mismatch" and highlights at #Let arrM() = Application.Index(arrR(), rws(), clms() -

    Almost there- so close to get it .
    Cheers!

  22. #22
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Hi Ian,
    Quote Originally Posted by wanian7 View Post
    ....... I used it to run in the real files, it worked for files have of the files and then got the error "Run time error "13" - Type Mismatch" and highlights at #Let arrM() = Application.Index(arrR(), rws(), clms() -
    Almost there- so close to get it .
    Cheers!......
    ....I take it from this bit:
    Quote Originally Posted by wanian7 View Post
    ........worked for files have of the files and then got the error "Run time error ........
    .. that you mean to say that you are getting an error at line

    Let arrM() = Application.Index(arrR(), rws(), clms())..

    ... It is not clear from what you said exactly when.
    .................................
    Anyway.
    .This line

    Let arrM() = Application.Index(arrR(), rws(), clms())

    is unfortunately the only part of the code whose workings I do not understand. That is because after some 6 months of asking , I come to the conclusion that no one on this earth can understand how Application.Index works when taking Arrays as its second and Third arguments...
    http://www.excelforum.com/excel-new-...ml#post4093924
    http://www.excelforum.com/excel-new-...ml#post4093843
    http://www.excelforum.com/excel-prog...ml#post4139923
    http://www.excelforum.com/excel-prog...ml#post4093653
    http://www.excelforum.com/excel-prog...ml#post4088055
    http://www.excelforum.com/excel-prog...ml#post4082174
    http://www.mrexcel.com/forum/excel-q...l?#post4174322
    http://www.excelforum.com/excel-new-...ba-arrays.html

    ...... So it may be a bit of trial and error to find out what is causing that line to fail!!!

    ..So

    .. 1 ) the best I can offer is that you post the file that is giving you problems. ( If necessary desensitise the data by changing it But make sure if you do that you check that with this modified data you still have the error )

    . I will then when I have time try to see if i can find out by experimenting what is going wrong.

    .. 2 ) Are you familiar with setting a Watch on variables in the Watch Window, and then stepping through the code with F8 and watching see how variables are filled.?
    . -If not , then please read up on this. Basically that is all that I will be doing in order to try and find the problem. if you make the effort to learn how to do this, then you should be able to find the problem yourself. – ( The Error could be some value being taken into variable ( such as an actual error #NV, for example, ) that has an incompatible type in later calculations or comparisons in the program...

    Alan
    Last edited by Doc.AElstein; 08-22-2015 at 03:33 AM.

  23. #23
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copying columns from one workbook to another

    Quote Originally Posted by wanian7 View Post
    ....
    Almost there- so close to get it .
    Cheers!
    Hi Ian,
    . Any news?
    . How did you get on?
    Alan

  24. #24
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Copying columns from one workbook to another

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

+ 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. [SOLVED] Copying random columns from one sheet to another in same workbook..Problem?
    By u3rick in forum Excel Programming / VBA / Macros
    Replies: 234
    Last Post: 09-23-2015, 06:28 PM
  2. [SOLVED] Basic Macro for copying 2 Columns from one workbook to another
    By crumpets266 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-08-2014, 08:32 AM
  3. Copying columns from two different workbooks into one workbook
    By bittersweets in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2013, 05:37 AM
  4. Macro for copying multiple columns and pasting 'n' times to another workbook
    By busybee235 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 10-01-2012, 02:10 PM
  5. Macro Help With Copying Multiple Columns to New Workbook
    By bigkahuna2187 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2012, 11:53 AM
  6. Replies: 3
    Last Post: 05-09-2012, 07:43 PM
  7. Copying columns from one workbook to another
    By peterl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2007, 07:38 PM

Tags for this Thread

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