Hello,
I have a consolidated details of customer A & B like invoice numbers, dates, amounts for different month in sheet 1. I need a formula that updates customer A & B with individual invoice details in separate tabs. I know we can use pivot and splitting it by customers. But do we have any...