Dear Friends,
I am Arun S, Working as a Structural Design engineer.
To ease of my work, I have develop excel sheet for my calculations and to avoid human error some macros or programming to develop, please help me.
Arun S
Dear Friends,
I am Arun S, Working as a Structural Design engineer.
To ease of my work, I have develop excel sheet for my calculations and to avoid human error some macros or programming to develop, please help me.
Arun S
Last edited by saruncivil; 05-03-2015 at 10:16 AM.
As this is your first post I will look at this for you.
But I cannot post a reply until you change your title to reflect exactly what you need this forum to do for you.
Our members search by the Title, so to be of any benefit to other users it must accurately describe your problem.
Ok your problem is very basic.
Please change your title to: "Use Data Validation with VLookup"
Last edited by mehmetcik; 05-03-2015 at 09:51 AM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hello Arun,
Welcome to the forum. Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Also, I am confused with your description of requirement. On one side you are summing up the value of B1+B2 for particular S.No.
On the other hand side, in query you mentioned you looking to have the MAX value. Can you be clear on one requirement.
Thanks
Nisha Dhawan
If you like my answer please click on * Add Reputation
"If you can dream it, You can do it "
Dear Experts,
Thank you for your Quick reply to help you member's.
and my apology to not following the rules.
Actually my Query is not in Vlookup or Data validation, i have to enter each Data in Cell- i5 to find maximum values in cell- O9.
i need to get result (maximum sum value) without entering the Data validation values (Cell- "I5").
Looking for your reply.
Best Regards,
Arun S
Ok
What you are seeking is a macro to help you replicate a goal seek function.
Changing I5 to find the max possible value of 09.
I have put a button in K10 that will run the macro below and put the max value in O10.
Please Login or Register to view this content.
If you can add a total column, then you can use max function to get maximum value easily.
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
If you are trying to find the max sum this will do that and provide the S.No that it belongs to:
Last edited by newdoverman; 05-03-2015 at 03:21 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank you so much Mr.mehmetcik.
you saved my time.
can you please brief about this macro and how can i learn this macros and VB.
Thanking you
Arun S
[email protected]
Please Login or Register to view this content.
Dear mehmetcik,
Thank for your explanation and can you please guide me how to learn macros and VB from basic level.
I'm having one question.
by running the macro I got the maximum value but how to find which "I5" character gives maximum value.
Dear newdoverman,
Thank you for your time and help, you gave the solution for the attached excel but that is not my exact case. for example I put summation of two values.
The best way is to record yourself using the macro recorder and then use your recording s the basis of more complex programs.
Once you have a recording an can understand Loops then you are quite a way into VBA.
If you record a macro using the recorder [ Still in development ] you can use my VBA editor to help minimise the code.
That in itself will give you some insights.
Copy the Recorded macro into column A of an excel spreadsheet and then run the editor.
Please Login or Register to view this content.
Thank you for your guidance and I will learn ASAP.
Please find the attached file for error by applying the above code.
why this error is coming.Error.JPG
Dear mehmetcik looking for your solution, please help for this error.
Try...
Please Login or Register to view this content.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
Please Login or Register to view this content.
Dear Experts and Herry,
Herry the macro which you gave was working superb and i had applied same concept to my work but it couldn't done, can you please check the debug.
Dear experts,
Looking for your solution, please help to save the time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks