iam having two cells one contains Particulars of item purchased  and another contains amount and status of payment. i have separated two sheets which I have used the index function to split the items based on the name of the item. My requirement is If I update the status of payment as paid in the sheet 2 of the particular item it should get updated in the sheet 1 of the master data also if I move the particulat item to Sheet 2 and if the change thevalue to not paid then it should get updated in the master data. Need help.



By: Prasanna

Leave a Reply

Your email address will not be published. Required fields are marked *