Quote:
Originally Posted by PolvoPelusa
I doubt I'm "further down the road" than you, but my plan is to attack some of the project manager type roles at my current company as soon as I absorb a bit more of the business-knowledge (supply-chain) and people management skills. Simply put, I want to be the link between senior management and a team of my clones. Currently (at the company I work for), there are only a handful of these type of people (that I'm aware of) and they are treated like gold.
Part of the reason i moved was that i wasn't ready to get a 9-5 job back home because I didn't know where i wanted to be. I think the best use for my skills would be external to a company if only because i get bored easily and i wouldn't last at a single company long enough to move up the ladder. My hate for the corporate ladder is another topic
Quote:
Originally Posted by CopTHIS
Thanks, I'll fiddle about with coding when I'm next at work. I just find it fiddly - eg I'm sure that I've been able to use the range command when the variable is the row but not when the variable is the column. I think range("A" & var : "C" & var2) worked but range(var & "1" : var2 & "2") or something similar wouldn't - if you see what I mean.
Yes, i just looked at the code and it won't actually work, you can only use range(var & "1" : var2 & "2") if var2 is a letter (you could use ASC() ) and convert it to a letter but it's not a good way.
This is the only time i use the .cells command
e.g.
range(cells(1,var1),cells(2,var2))
hope that makes sense
edit: if var1 and var2 are letters then the correct syntax would be:
range(var1 & "1:" & var2 & "2")
note that you need the colon inside the quotes
Quote:
Originally Posted by jjshabado
What do you mean by this? What kind of things do you do?
I can't imagine a whole lot of things where Excel is the right tool for the job for back end work. At the bare minimum I could see writing a simple script to import the Excel data into Access for proper processing/querying/reporting.
Edit: Actually I think its super easy to import Excel data into Access using VB - but it's been a long time since I've done Excel/Access programming.
Templates used company wide, write a macro to go through every file in a folder and aggregate in a spreadsheet, i mentioned this before but most companies don't want to use access and are happy living their lives in excel. A lot of the time I will be doing things where the company has an existing process with a designated input and output that they are happy with. For example a movie studio had a list of all DVD release dates in a master file with data spread across 4 different tabs, when ever they wanted to make a monthly one someone would spend hours copy and pasting from all the different sheets and creating a monthly workbook. The workbook design was already decided on and everyone was happy with it, all i did was automate the creation of it.
Sure it might be more efficient to move all the DVD releases to a huge database but that would require a huge change which no one wants to pay for.
This is especially true with anyone in the finance industry who would never leave excel if they didnt have to.
edit: i see copThis covered this, this is the attitude of every company i have worked with
Last edited by zomg; 09-12-2010 at 06:17 PM.