LinkBack URL
About LinkBacks
I have two sheet (input & output). please check the attachment.
input sheet having data in the CELL A1:A , & form them i want to retrieve desire text in the output sheet A:E.
I have two sheet (input & output). please check the attachment.
input sheet having data in the CELL A1:A , & form them i want to retrieve desire text in the output sheet A:E.
Try
Please Login or Register to view this content.
This would be almost impossible to achieve through the use of formulas only. However I am thinking this may be possible with a macro. I will see if I can come up with some working code in the next few days.
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
Didn't see your post before I posted!Originally Posted by jindon
Try
Please Login or Register to view this content.
That code is very impressive jindon. You are almost there.
Hi, jindon
Outstanding performance. Your macro is very speedy which is appreciated. Now my desire job almost 99.99% ok. it will be very helpful if the desire output I get in the “output” sheet, it is required because after retrieving desire fault code then I will be vlookup from sheet “faultsheet” so that I will get the meaning of actual fault code. Please check the attachment.
In your output results: “MO TYPE” is missing , other than all are ok..
Please Login or Register to view this content.
Edit;
Missed "MO type"
Please Login or Register to view this content.
Last edited by jindon; 02-08-2013 at 10:19 AM.
Hi, jindon
Just Great. My requirement is 100% fulfillment. The speed of your macro is extremely first which was unexpected !!. now I am very much happy to get the macro. I will be more happy if I can implement vlookup macro in between Output sheet & faultlist sheet . if you have time then you can help me , other then I will Do my job by formula.Then it will look like worst as partial macro & partial formula. I think you understand me ..take care..
"Output" sheet will be like below
above red marks is done by vlookup from below sheet "faultlist"Please Login or Register to view this content.
Please Login or Register to view this content.
Hello nur2544,
I wasn't sure if you wanted the values only or if you intended to have the VLOOKUP formulas in the final result? (I have worked out the code for values only result but it's currently commented out).
I have created something that mostly works. See the attached file. (I say "mostly" because I am not happy about it for the following reasons:
- It requires a custom column in your faultlist tab (I have added this)
- It returns 0 values if there is no lookup value found
- It can't handle multiple fault codes (e.g. row 10 in the output tab)
- The code I created is not to the standard I would like (it's very sloppy because it was rushed together in a few minutes mainly by using Macro Recorder)
I can easily fix the second point if you tell me what you want instead of 0.
I can't think of a solution to fix the third point at the moment.
Last edited by mc84excel; 02-11-2013 at 09:52 PM. Reason: punctuation
Missed that one.
All in one.
Change to
Please Login or Register to view this content.
Hi, jindon
Brilliant job, Just outstanding performance. every day I would spend more than one hour to make the fault report, but your macro takes only few second to get the report & which one is the 100 % accurate. I am really very happy to get the wonderful macro. Thanks you very much for saving my valuable time. Keep faith on me , yes obviously I will not forget your help….
Take care & wishing you very healthy life….
Hi, mc84excel
Thanks for your time, your idea & my idea are same & that is done by vlookup. But it is just slow as I have lots of data to work . & for this I am going to use jindon’s macro as its speed is extremely fast !!
No problem nur2544. I only offered a partial solution anyway (the row 10 problem).
Just pleased to hear that your problem has been solved. (It can get very frustrating when you start a thread and you don't receive any solutions or suggestions!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks