Is there a way to open an excel file so that it automatically shows two tabs/sheets side by side? I know how to manually do this each time using the Window box of the View tab, but it would be much more efficient to have this done automatically every time I open the file. I'm open to doing this however...VBA is fine if that's the only way.
The nutshell version of what I'm doing is I've got one worksheet that has planning information (tasks, hours for each task, dates the tasks will be worked on, etc) and another sheet that automatically figures out how much time I've got left available each day after taking all the information from the first sheet into account. At first I just had everything on one tab, which works okay until I start sorting the planning items. When the sort hides certain rows, it obviously hides some of the schedule information with my available time. That's why I moved the schedule to a different worksheet.
Bookmarks