Report macro

Good morning

The reports ran is for all items and I want to write a macro to split each item into a separate sheet. I have 935 line items which I need to split. Reason for me needing to split the items is that some items have little or no forecast and other have more forecast than total stock. The idea behind it is to get the forecast to consume the oldest stock first and after the forecast has been removed from stock on hand I can then determine the SLOB ( slow moving obsolete stock ) that I will be left with.

Hi nightcrawler-jay;

You didn't include a sheet that showed an example of how you wanted the results to look.

Here's how I would handle it based on what you have said so far: I would write a macro that created a sheet named "9080007" and copy all the data for 9080007 from Sheet1 onto that sheet.

If that's all you want, an easier way is just use "autofilter".
In the menus: DATA>FILTER>AUTOFILTER. That will make every column heading like a listbox. You just go to "Material Number" heading and select the material number you want, and it is automatically filtered. Then you can print the sheet as is. When you're done printing, you can turn off autofilter the same way DATA>FILTER>AUTOFILTER

If you want the macro to figure out what batches to include in a report, you will have to tell us how to figure it out. Describe it like you would describe it to a new employee that doesn't know anything at all about your business. Remember I'm a new employee, and I have no idea what SLOB or SAP or Material Group are, so explain it to me that way, and I can write a macro to do it for you.