VBA Report Development

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??

:confused::confused::confused::confused:

Michael Aschenbrener
Excel VBA Noob
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,118,418
Messages
5,571,990
Members
412,430
Latest member
Huuktkt
Top