Forum Discussion
Need help extracting information from different worksheets onto 1 report
I am struggling trying to find a solution for this problem. Scenario... Excel file with three worksheets titled 2018, 2019, and 2020. Each worksheet has the following columns... seller ID, seller n...
jmorales A similar solution to what Abiola1 suggested is demonstrated in the attached workbook. I've used the column headers as you specified. First add one column to each sheet with the year. Then put everything in one sheet and create a pivot table (as shown in the file). Add a "Calculated Item" for the difference between two years.