Posts by gigglesmumpty

    Hi all, I've got some sales data for the last couple of years and i can chart it cumulatively, all branches or the first one in my list, however i really don't know how to go about altering it to pick up the next rows, but not the first - if that makes sense? It will generate a large number of graphs - 250+ but that is what has been requested.


    I'm very new to VBA and I have used the very basic

    to compile both my first branch chart for the last 5 years and my cumulative. I've added a test file to see if anyone is in a position to assit with how i would generate the separate graphs


    Many Thanks in Advance

    Hi all,


    I currently have a number of spreadsheets in excel which will be updated by other member's of my team on a fairly regular basis, is there any easy way to retain a 'master' copy which can be automatically updated, or would i be better doing this is access?


    I have very, very rudimentary access and sql skills and although i'm not too bad with formulae in excel, i've never used vba. I guess I'm really just looking for guidance as to what would be the most efficient way of doing this, and hopefully not too complicated!


    Thanks in advance!