Automatic Update of Multiple Worksheets to /Master Worksheet

  • Hi there,


    I am working with one of financial company. And we have few Trade names and each Trade names there is one worksheet. We want every employee work with assign Trade Name worksheet and later all worksheet data should be automatically update into Master worksheet.
    My Master WorkSheet has - Trade Name, Client Name, Cottages model, Appraised Value, MTG Approval Amount, Final MTG fields and each worksheet name as Trade Name and having all same columns. Now if suppose one of the name of Trade Name is "ABC' and there is worksheet name as "ABC" if I update in ABC worksheet data it should automatically update into Master worksheet.


    My Master Worksheet - (there are around 60 Trade Names means I have another 60 Worksheets) [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 1152"]

    [tr]


    [td]

    TRADE NAME

    [/td]


    [td]

    CITY

    [/td]


    [td]

    PROVINCE

    [/td]


    [td]

    MA

    [/td]


    [td]

    Client Name

    [/td]


    [td]

    Cottages Model

    [/td]


    [td]

    Appraised Value

    [/td]


    [td]

    MTG Approval Amount

    [/td]


    [td]

    Final MTG

    [/td]


    [/tr]


    [/TABLE]

    Subworksheet - "ABC" as TRADE NAME
    N
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 1325"]

    [tr]


    [td]

    TRADE NAME

    [/td]


    [td]

    CITY

    [/td]


    [td]

    PROVINCE

    [/td]


    [td]

    MA

    [/td]


    [td]

    Client Name

    [/td]


    [td]

    Cottages Model

    [/td]


    [td]

    Appraised Value

    [/td]


    [td]

    MTG Approval Amount

    [/td]


    [td]

    Final MTG

    [/td]


    [/tr]


    [tr]


    [td]

    ABC

    [/td]


    [td]

    Peterborough

    [/td]


    [td]

    Ontario

    [/td]


    [td]

    Alex

    [/td]


    [td]

    Niky Shah

    [/td]


    [td]

    Cottages

    [/td]


    [TD="align: right"]45000[/TD]
    [TD="align: right"]45000[/TD]
    [TD="align: right"]42000[/TD]

    [/tr]


    [/TABLE]
    Now, as soon I save all data from "ABC" worksheet should update into Master worksheet.
    Also, no duplicates so we can also clear Master file before updating all worksheets data.


    Thank you very much.

Participate now!

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