Good morning all. I'm looking for a way to automate a task I find myself repeatedly doing even though the first time it was asked a few months ago, it was a one-off thing. NOT! :-)
- I extract data from our systems via Excel.
- All raw data is dumped to a single worksheet in Excel as shown in the attached spreadsheet.
- I need to separate data based on company name column and move only that company data (all rows and all columns, even if date columns might be empty) to it's own worksheet within same workbook and that worksheet name being the company name for that worksheet by running a macro, or by clicking a button with said macro attached to it.
- I will start with a properly formatted "raw data" workbook with only the rawdata worksheet in it each time I do this and save it out as it's own "dated" file when I'm done
My issue is i'm not good with Macros and I don't think recording a macro would do me much good here because the amount of data in the raw data worksheet will in almost every case be different in row size but not column size. Meaning I could have 20 rows for Company A, 5 rows for Company B, 18 rows for Company C, and so on - this round and those numbers of rows be completely different next time. The columns will always stay the same and contain same data points.
Also, each worksheet will need to summarize the following to be able to be replicated via a bar chart graph on a final and separate worksheet.
Sum of Volume in $ for that company
CountA for Date Quoted Column
CountA for Date Sold Column
Percentage of Date Sold and Date Quoted for "pull through"
Any help would be appreciated.