I have two sheets on my excel work book. sheet1 contains whole customers data, sheet 2 contains data of customers who made payments. both sheets contain a column named "customer id" , I enter payment details details only in sheets 2 . **i need to get updated sheet 1 automatically based on "customer id" the corresponding row should be highlighted or marked " paid " in another column**.
sheet 1:- all customer data with customer id (1000,999.998.... in descending order)
sheet 2:- details of customers those who made payment with customer id(the order in which the payment made)
Bookmarks