What method would I use to import data into excel that contains line item numbers that increase each week? Additionally each week the number of line items grow and there would be changes in the stages of line items imported from week one. I would like to create charts that show a total of line items at various stages in a process. Week two import would have the same line items as week one, but they may be in a different stage of the process this week. Plus there would be new line items as well. Week three would have totals of week two, plus new items, and updates to new process stages that week one and week two items are in. And so on and so on. Could each week import be on separate tabs that data on each tab could be compared to the previous week's tab to display on graphs? Thanks for ideas!
Related:
Weekly Data Imports to track status changes and new line items
