@pscott wrote: I have a table that loops kinda like below only with every combination of those three variables. And I would like to create a report based on every horizonal Column of that table E.g. one report would where comany = next, serial # = 965465, Tech= Superman and another where company = next , serial # = 56465, Tech = Jed.I'm not sure the best way to do this but I tried this and it failed.    I have no idea what this means. Post an example please, you'll get an answer much faster.   For example, what are you defining as a report? Is that a sheet in Excel, a PDF page, a single Excel file and one for each company, or a single PDF file for each?  And what do you mean with the variable = (company=next...), are they printed across, or down or sideways...literally no clue with what you've stated here.    You're using arrays incorrectly and mixed with macro's, which doesn't make sense in your sample code.  Help us help you by detailing your question.  ... View more

I don't know anything of your requirement and real data - but IMO most scenarios benefit from even transpose your Row variables to rows: DWID - Stone_NBR - Row_NBR - Row_Val (whatever that is)     ... View more