Hi guys, I'm new around here but I was reading your stuff for quite some time.
I'm also quite novice to excel programing (VBA and formulas) but I'm a Java developer so I understand logic... just not the logic around Excel...
I have to maintain a staffing forecast spreadsheet and it was quite a pain so I created a bunch of formulas and macros to help me. The problem is that it's not performant and quite heavy as I keep adding data.
Can someone have a look at it and try to optimise it? I'm a quick learner, if you start it I can keep improving it... I just dont know where to start.
Also, if someone could help me to implement some kind of calendar for vacation that looks a little bit like the one found on this site http://www.en.jgm-software.com/ (not trying to steal their stuff, just want to give you an example of the improvement I'm looking for)
I dont know how to attach my spreadsheet, is ther a way?
Let me know, any help will be good!
Thansk in advance! you guys ROCK!
I'm also quite novice to excel programing (VBA and formulas) but I'm a Java developer so I understand logic... just not the logic around Excel...
I have to maintain a staffing forecast spreadsheet and it was quite a pain so I created a bunch of formulas and macros to help me. The problem is that it's not performant and quite heavy as I keep adding data.
Can someone have a look at it and try to optimise it? I'm a quick learner, if you start it I can keep improving it... I just dont know where to start.
Also, if someone could help me to implement some kind of calendar for vacation that looks a little bit like the one found on this site http://www.en.jgm-software.com/ (not trying to steal their stuff, just want to give you an example of the improvement I'm looking for)
I dont know how to attach my spreadsheet, is ther a way?
Let me know, any help will be good!
Thansk in advance! you guys ROCK!