I am currently trying to figure out how to make a profit loss report it took me 2 days to get as far as I have but I would like to find out if I can use my monthly report to break down into weekly or if I have to set up the cells in a weekly fashion rather than monthly? I have the drop downs for the months and truck id numbers figured out already just more or less wondering if weekly calculations can only be done manually entering them or if excel has a way of doing this on its own. And if I did enter it manually the report list of data would be infinitely long I would assume as I have weekly reports coming in and would have to enter them in constantly on a monthly or weekly basis anyway. Or if anyone has an easier way of entering in the information so that pivot table would pick it up was kind of wondering how the external data thing works if I could link to a database and just have the info refreshed onto pivot from there? would be nice but again I have only been using excel for about 2 days and have prior experience with it so would appreciate any pointers
Bookmarks