Excel Macros 1

[centaur21]

I am looking for a good or best site to find macros to use in my engineering spreadsheets. I have a few macros in mind, but would like to see a site that has some engineering macros and go from there.

 

[insult2injury]

Macros for what? You'll find that there are tons available, but you need to know what you are looking for.

I2I

 

[centaur21]

Well, I am generating an IO list for an offshore platform and being able to use macros to fill in cells given certain information would speed up the process. I am looking for something like given data in a cell or cells, insert particular info into another cell and be able to do it automatically without having to run the macro; for example, after information has been entered into a particular cell, it automatically outputs specific data into another cell. I am fairly new to VBA but have done quite a bit of programming in the past.

 

[insult2injury]

You should be able to do that pretty easily with case statements and maybe a few dropdown boxes.

I2I

 

[centaur21]

Can you give me a really good site that is specific to creating excel macros to give me some ideas?

 

[melone]

Sounds like this is a perfect application for a relational database.....

 

[bltseattle]

http://www.cpearson.com/excel/ExcelPages.htm

http://www.mvps.org/dmcritchie/excel/formula.htm

http://www.fontstuff.com/excel/index.htm

http://www.geocities.com/SiliconValley/Network/1030/ExcelTop.html

 

[joerd]

That is faq770-275

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.