we work with a process that involves receiving a large spreadsheet (that contains info for multiple companies), and need to segregrate out the rows specific to each company. There is a "bank number" column which identifies the company, and it is sorted by this column.
I'm looking for a quick way to say, at each break in bank number, create a new sheet. Is this possible without any sort of visual basic/programming? I'm trying to help find a quick solution for someone but don't have a lot of time to invest at this point.
thanks in advance!