Axiom Home Page Forums General Discussion The Water Cooler Excel VBA Question

I searched Google with 'vba cheat sheet' and it came up with stuff like this. Perhaps you've already done this. I don't know if it helps, or not.

Yeah, google has been my main reference.

Success!

Have everything running now in a loop from 1-27. Updates all files in less than 4 minutes.

Probably a good 3+ days worth of effort if done manually.

Thanks again Kruncher.

Now to ask for that raise...

Glad to hear that you've accomplished what you set out to do. And damn quickly, at that. A man on a mission!

As with many skills, it'll take some time to get to that level of comfort where you can write a block of code with refering to any other resources, but it's a great feeling once you do, and you're able to say "I did that!"

VBA has its critics, and they tend to have some good points. The two things, IMO, that VBA has going for it are it's (generally) easy syntax (as compared to other programming languages), and its availablity. It's included with every copy of the best selling office productivity software, and has been for years.

I've often commented to people that you don't get a programming environment free with a good spreadsheet, you get a spreadsheet free with a good programming environment. Is it perfect? Heck no, but man, you can do a lot with it just the way it is.

Kruncher,

Excel seems to be your game.

I've got a spreadsheet that wants to be a relational db, but it can't be and I need some help.

For one section I need about 4 variables picked by the user and then do a look up based on those variables for a description, cost, etc.

Problem is we are a talking thousands of possiblities ( I can handle that part) but I need to have excel do the same lookups in 8 to 10 different sections of the workbook with the possibility of different results on the same dataset. The results also does lookups for additional options based on user input for the 8/10 sections. And the workbook would be to big recreating that data 8/10 times. Not to mention the maintenance

btw, I don't know VB, just excel

Are you willing to look at the file?

Thanks

Jeff

Hi Jeff,

I've just sent you a PM, if you hadn't noticed.

Kruncher

Ironic that i received a notification at work just today about training on VBA and Excel.

I'd like to think that it's because people are finally seeing the tangible and quantifiable economic benefits, as David has so nicely summarized for us with a real-world example, that can be acheived by those with a suitable background in not just Excel or programming, but also in the nature of the actual work at hand.

I once worked with a great programmer who didn't know the first thing about accounting, and therefore it was taking him forever to build some simple financial statements. But he knew his way around optimized code.

Many thanks, response sent