If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
IF AND OR functions
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'... |
#22
|
|||
|
|||
IF AND OR functions
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 |
Thread Tools | |
Display Modes | |
|
|