Excel utility

Hello Sir Im excel VBA macro and formula Expert :) i can generate output like in your sample from input like your sample :) please ping me now and im able to start build right now Thank you Galih

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "

Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5+ Yrs. of Experience in EXCEL & VBA. • Knowledge of FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • Macro coding for USERFORM and other COMPLEX TASKS possible. • Password removal from Excel and VBA editor. • Work in TIGHT DEADLINE & HIGH ACCURACY. • Can start working IMMEDIATELY. Please ping me for more discussion.

Hey, I'm interested in your project. Please send me a message so that we can discuss more. Best Regards Monirul

Hi, I would love to work on your project. I have done Masters of Computers (MCA). I have worked on similar project (Take a look on attached sheet) I am Excel Expert by profession & have 13+ years of exp. working on complex excel sheets. Feel free to contact and discuss more abt the project Thank you

Hi there! Taking into account your budget I propose to create an Excel Add-in that will work as a quick entry button to perform this task in any workbook you require. I established 3 days for the work, but for sure I'll be able to deliver before the deadline. Thank you so much in advance. Best regards.

Dear Client, This macro will work. Just create a new output sheet and name it Output2 and run this macro to see the effect, if satisfied, i can finish it up for you for the remaining columns L to S, i couldnt paste the whole macro here due to space constraint, i can send the complete version to you via chat Thanks Sub hhh() Dim Row As Integer, Col As Integer, x As Integer, lRow As Integer Dim Rowopt As Integer, Counter As Integer, iterator As Integer Dim Coursearray(1 To 12) As String Dim Unitarray(1 To 12) As String Dim Scorearray(1 To 12) As String Dim Gradearray(1 To 12) As String Dim details(1 To 6) As String For Row = 2 To 11 Counter = 0 details(1) = Worksheets("Input").Cells(Row, 2).Value details(2) = Worksheets("Input").Cells(Row, 3).Value details(3) = Worksheets("Input").Cells(Row, 4).Value details(4) = Worksheets("Input").Cells(Row, 5).Value details(5) = Worksheets("Input").Cells(Row, 6).Value details(6) = Worksheets("Input").Cells(Row, 7).Value For Col = 8 To 19 If IsEmpty(Worksheets("Input").Cells(Row, Col)) = False Then Counter = Counter + 1 Coursearray(Counter) = ExtractElement(Worksheets("Input").Cells(1, Col).Value, 1, "(") Scorearray(Counter) = Left(Worksheets("Input").Cells(Row, Col).Value, 2) Gradearray(Counter) = Right(Worksheets("Input").Cells(Row, Col).Value, 1)