Trying to think of a way to do this and coming up short. I know the Consolidation only gives you periods, not transaction detail so you can get detail by date, so I thought about a different sheet for each company - nope. About the only thing you could do is run the detail report for each company, generating a separate Excel sheet, then create a new sheet that pulled from all of those different reports, right?
------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625
------------------------------