Posts by JackWhittaker

    COPY MULTIPLE SHEETS INTO DATA


    I am building a database where I Currently have several macros.

    At the moment, the macros in use are perfect however I need some vba which feeds 4 separate sheets into the one data sheet.

    The 4 sheets for example are: “a”, “b”, “c” and “d”

    And the data sheet it called “data”.


    All 5 sheets have the same column headings, so should be easy when copying over.


    The main emphasis of this VBA is to just add to the existing sheet as new items get added to each Of the 4 data sets.


    Please can you help, it would be much appreciated! I am tearing my hair out !

    Hello All,


    I work in risk management and I am currently building a database where I Currently have several macros.


    At the moment, the macros in use are perfect however I need a further some vba which feeds 4 separate sheets into the one data sheet.

    The 4 sheets for example are: “a”, “b”, “c” and “d”

    And the data sheet it called “data”.


    All 5 sheets have the same column headings, so should be easy when copying over.


    The main emphasis of this VBA is to just add to the existing sheet as new items get added to each Of the 4 data sets.


    Please can you help, it would be much appreciated! I am tearing my hair out !