I need to create an Excel spreadsheet from a table with
transactions from numerous offices. The table is sorted
first by office, then by transaction. Each office needs
to have a separate worksheet listing all of its
transactions. How can I tell Excel to switch to a new
worksheet when the office changes? Can Excel create the
names for the worksheets using the office codes, or do I
have to create all of the blank worksheets first?
Thanks