Hi there,
I have Master sheet (with Cust.No, Name,Sales Person,Phone,Status) and 2 more sheets sorted based on sales person contacts from master sheet. Now after somedays i need to update the record in master sheet say record no 3 in status col. —sametime I want it to get updated in the respective record of resppective sales-person sheet. Can you let me know if there is any solution. Thanks in advance

    2 replies to "autoupdate in subsheet"

    • BenneTan

      hi there. you can try this extremely long, but robust formula. even if you want to add another sales-person worksheet, it wouldn’t be a problem. click on this link to download the file

      https://www.excel-course.com/wp-content/uploads/2012/12/excel-Q-to-Jason_solution.xlsx

      this can not only help you fill up the status, but you are also able to apply it throughout column A to D by copying the formula across. do note that my formula is only ranged up till row 1000 of your Master sheet. so do adjust that if it exceeds.

      hope that helps

    • Swati Ghanekar

      Ok Thanks Benne Tan.. will try and see

Leave a Reply