Directing data to new worksheets

  • Thread starter Thread starter sallie
  • Start date Start date
S

sallie

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
 
I have used the example referenced noted below to "update
sheets from master", and have been almost successful in
getting this project figured out. I can get the macro to
create the Office worksheets, but I cannot get it to
populate it with the data from the transaction file. The
macro is pulling the office names from the transaction
file, but the rest of the data does not transfer to the
created worksheets.
One item in the example that I have a question on is the
tab for Global Mapping... I cannot see where that is
defined, or comes into play, although it shows the format
that all of the worksheets uses.

Thanks so much for the great help already.
 
Do you have a range named Database on the transaction sheet?
(Insert>Name>Define)

In the sample file, Global Mapping is one of the cities on the Main
sheet. It's missing from the City list, and is added when the macro runs.
 
I did create the name "Database" and defined it according
to the example... on that name sheet, if I am in one of
the worksheets in the example, it shows the
name 'Extract', but when I try to create the similar item
in my worksheet, it doesn't end up looking the same...
cannot figure out how it is created, where it is used or
called.
 
If you'd like me to take a look at it, you can email your file to me
(remove the capital letters from my email address)
 
Back
Top