We have worksheets inside of workbooks, so what is the next step? Workbooks are inside of what...what are inside of worksheets?
I have info from weeks that I need compiled into monthly totals and then I need the year-to-date totals.
I'm trying to keep it VERY simple (excel=illiterate users) by putting the months into folders to choose from and then a set of worksheets for the corresponding weeks. I also found that it takes too long to save the info if I have it in the same workbook.
It probably takes either a macro or hyperlink thingy, but I haven't a clue about how to set it up...
Help!
I have info from weeks that I need compiled into monthly totals and then I need the year-to-date totals.
I'm trying to keep it VERY simple (excel=illiterate users) by putting the months into folders to choose from and then a set of worksheets for the corresponding weeks. I also found that it takes too long to save the info if I have it in the same workbook.
It probably takes either a macro or hyperlink thingy, but I haven't a clue about how to set it up...
Help!