Need to know a way to fetch the customer ID and its matching customer name from the sheet "Customer List" and put in a ascending order of Customer ID in the Sheet "Reports". once I added a new customer in the sheet "customer list" it should be automatically updated in the sheet "Reports". the automatically populating sheet "Report" must have uniq customer ID ( I mean, there should not be any duplication)
Is there anyway to do this... currently i am doing this manually.
my file is attached!
Bookmarks