autoupdate in subsheet


December 10th, 2012 by Swati Ghanekar Swati Ghanekar

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 Responses to “autoupdate in subsheet”

  1. BenneTan BenneTan Says:

    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

    http://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

  2. Swati Ghanekar Says:

    Ok Thanks Benne Tan.. will try and see

Leave a Reply

You must be logged in to post a comment.

s2Member®