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)
TRADE NAME CITY PROVINCE MA Client Name Cottages Model Appraised Value MTG Approval Amount Final MTG
Subworksheet - "ABC" as TRADE NAME
N
TRADE NAME CITY PROVINCE MA Client Name Cottages Model Appraised Value MTG Approval Amount Final MTG
ABC Peterborough Ontario Alex Niky Shah Cottages 45000 45000 42000
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.
Bookmarks