Hello. I was tasked with coming up with a master sheet for a balance sheet over 10 years. Of course, there have been changes during each of the years, and the rows for each tab vary from 300 to 350 line items. Is there a tried and true accounting way to create a master sheet (without losing the format, and keeping ANY line item that was ever in any of the sheets...to do lookups on) for this type of task? Otherwise, it's just a manual task of aligning the rows, which takes about 30 minutes and is booooooring.
Bookmarks