LinkBack URL
About LinkBacks
i created a good lookup and calculations in excel but i need final improvement on it. the zipped file size is 655 kb so i cant post it here, please contact me if you have time to create a macro.
i created a good lookup and calculations in excel but i need final improvement on it. the zipped file size is 655 kb so i cant post it here, please contact me if you have time to create a macro.
Last edited by VBA Noob; 06-25-2007 at 04:28 PM.
I have a bit of time to look at your work send me the sample here denis.jette@ccra-adrc.gc.ca
Denis
Please always attach the sample workbook without sensitive information when asking for help
To add a module
Press Alt + F11 (this is the Visual Basic Environment)
Insert Menu, select Module
Past code there
Close Visual Basic Environment (X)
hi there,, i just sent you an email explaining the procedure, please check it out.Originally Posted by jetted
Last edited by haplo39; 05-17-2007 at 08:26 AM.
is there anybody to help?
How do you expect help, if you can't be bothered to post the question correctly - some example of code & or formulas might help. Trimming the workbook to attach it would be better.
I certainly would not give my email address out as jetted did.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
my problem is: i need a submit button of which function will be create same sheet in an order and there will be a summary sheet will collect specified cells from newly created sheets.
i created very good lookup, iterations, formulations etc. but i dont have any idea about macro to do what i want above...
my e mail address is aykut39@hotmail.com
aynone who will help me, can add me to his/her msn for any questions. because my excel uses a xla and having little bit complicated procedure.
is there any one can do that..
my problem is: i need a submit button of which function will be create same sheet from L(0), name will be L(1), L(2)....in an order and there will be a summary sheet will collect specified cells from newly created sheets.
the blue cells are input in L(0), other cells are calculated. the pink colored sheets are data bases for lookup, etc.
also there is steam.xla is used for calculating density. please activate from tools/add-ins .. (of course, you know)
i created very good lookup, iterations, formulations etc. but i dont have any idea about macro to do what i want above...
please help
Halpo, a good start would be to record your actions using the macro recorder, it does give a lot of code you don't need but its a good way to see how the macro progresses and what it does along the way, once you have done this post back with a specific question rather than asking someone to perform the whole task for you from top to bottom!
Not all forums are the same - seek and you shall find
Duplicate post
Halpo, you have not complied with the rules of the forum, your titles have no descriptive information, you have duplicate posted, you have not done any work yourself or posted any example to go with the very poor explanation you have given.
This thread is now locked
Please feel free to post again with a specific question to a specific problem, be descriptive and supply any code you have been working on in order to assist those that may help you, whenever possible supply a sampleworksheet with the structure you are working with.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks