Transferring values from each sheet to a new sheet

    Hello all,


    What I am trying to do is transferring values from a column in each sheet to a new sheet in the workbook, does anybody know how to do this?


    //Robert

    .¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

    Re: Transferring values from each sheet to a new sheet


    Hello hgus393,


    Can I suggest that you post an example of the file and the expected result, it would make it easier to understand your request and for other people in the forum to help you.


    The answer depends on whether you want to use formulas and link to the columns in the spreadsheets or alternatively use VBA code to extract the information.


    But again an example would be helpful.


    Gizzmo

    Re: Transferring values from each sheet to a new sheet


    Right sorry,


    Please see the attached example I would like to have it in VBA!


    //Robert

    .¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

    Re: Transferring values from each sheet to a new sheet


    Hum I think I am on the right way here, I am checking the number of rows that has values ie COUNTA for each worksheet and by that being able to determine how many rows to transferred (copied) to the new sheet. The problem I am facing now is getting the values into the new worksheet with all the values.. anybody know hos to do this?

    .¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login