I'm converting a lot of quickbooks reports to a neater excel report. I need to copy some data and sum others (see attached example)
These reports may be for 400 people or 2000 so formulas need to continue as far as I drag. I can copy and paste values then filter for clean up of 0, N/A or whatever but doing this manually is taking forever.
Bookmarks