aschenbrenerm
New Member
- Joined
- Feb 19, 2017
- Messages
- 3
Hello all - I'm looking to see if it's necessary for me to go the route of writing a macro for this project.
I have about 150,000 lines of data monthly. Each line contains division, branch, manufacturer, supplier, part number, Internal number and price. There are about 20 divisions, 500 branches, 150 manufacturers hundreds of suppliers and thousands of part numbers.
I'm trying to sort them out and create a report for each branch that shows the lowest cost of a specific manufacturer. i cannot seem to get it done with a PivotTable so I'm looking at writing the macro for it. Just don't want to head down that path if someone has any idea??
Michael Aschenbrener
Excel VBA Noob
I have about 150,000 lines of data monthly. Each line contains division, branch, manufacturer, supplier, part number, Internal number and price. There are about 20 divisions, 500 branches, 150 manufacturers hundreds of suppliers and thousands of part numbers.
I'm trying to sort them out and create a report for each branch that shows the lowest cost of a specific manufacturer. i cannot seem to get it done with a PivotTable so I'm looking at writing the macro for it. Just don't want to head down that path if someone has any idea??
Michael Aschenbrener
Excel VBA Noob