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...
Hello,
The best way to go about your data is to have a single sheet. Put all the years in a single column for example
In column A, have all the ID listed.
Column B, Date of Transaction ie. 01/12/2017
In column C, Seller Name.
Column D, Units
Column E, Price
Column F, Total
Then, you have extract the Year and Month from Column B into columns G and H using the formula
Column G, =YEAR(B2)
Column H, =TEXT(B2,"mmmm")
After doing all the above, you can easily use PivotTable to create a nice report. So easy!
The best way to go about your data is to have a single sheet. Put all the years in a single column for example
In column A, have all the ID listed.
Column B, Date of Transaction ie. 01/12/2017
In column C, Seller Name.
Column D, Units
Column E, Price
Column F, Total
Then, you have extract the Year and Month from Column B into columns G and H using the formula
Column G, =YEAR(B2)
Column H, =TEXT(B2,"mmmm")
After doing all the above, you can easily use PivotTable to create a nice report. So easy!