I am seeking help from experts in this forum to help to resolve the following issues other than Pivot table by using ExcelVBA.
1. I am getting data "input" list from different users so the column heading is same but located in different column number from each user. ex. Posting date is in column "A", but from different user it can be column "D". same way products and quantity also.
2. I want to summarize the data as per "Output" sheet.
Since I know how to tweak the code to suit my requirement, i can use this code to generate daily and weekly report. Thanks