Hi all
I have a file with 22.000 lines. They contain our stock codes plus their suppliers (plus some more information but not relevant for this thread). I want to create a separate excel file (or CSV, whatever I can get) for each supplier as there are over 300 suppliers.
I suppose someone with macro skills would be able to do this? So I know how to start recording and stop recording and enter the shortcut, how far can I get with this?
I have a file with 22.000 lines. They contain our stock codes plus their suppliers (plus some more information but not relevant for this thread). I want to create a separate excel file (or CSV, whatever I can get) for each supplier as there are over 300 suppliers.
I suppose someone with macro skills would be able to do this? So I know how to start recording and stop recording and enter the shortcut, how far can I get with this?
