forgot to attach the file. Here it is:


+-------------------------------------------------------------------+
|Filename: sorter1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5235 |
+-------------------------------------------------------------------+

--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=572736

Hi Bearacade... Thank you so much. I spent a lot of time yesterday
with this. I wish I knew/understood more on macros - I'm going to buy
a book.... Because the sort by company macro works great. I'm just
trying to figure out how to tweak it to create the look I need.

I can't get the sort by week to work properly... I'm determined to
learn & understand what & how you created these. I really want to be
that good with it.

I can't thank you enough for the time you spent helping me.....
really 'thank you'...

Not a problem, if you sort by week within the sheets that the companies
were sorted into, it will then break it down by sheets.

The things is that if you have 5 companies, and you broke it down by
computer, then by week, you are looking at extra 25 - 30 sheets on top
of your master sheet.

It's better if you created a new workbook, then inserted sheets as you
go.

If you need any additional help, don't hesitiate to ask.


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=572736