Hi,
I have a formula for vlookup with 3 criteria (1 column and additional text), i wanted to convert this into vba (with button) since the formula is getting slow when runs or add a new row data.
I have attached the excel file, the main sheet is the table range, query sheet is where i input the location together with the text for each column i will vlookup with.
The output sheet is what will be the output for vlookup without the formula. Transaction ID: 8X848174UJ644040R
br,
Ivan
Re: USD $10: Extract Material Types from CSV to Excel
Works fine now. Thanks! 
Re: $10.00: VBA Search and Summarize
Dear Krishnakumar,
i sent pm. where should i send the payment?
Re: $10.00: VBA Search and Summarize
Thanks Krishnakumar.
Re: USD $10: Extract Material Types from CSV to Excel
It works fine.
What i meant was, it also copied the other(all) rows which doesn't have AM, NNU, SFU, on the table.
If my table have 10 rows, and only 1 AM, it will copy the whole 10 rows which should only have one row since only one AM is found in the table data.
Re: USD $10: Extract Material Types from CSV to Excel
Hello i have tried you code with modified code. i received an error "Compile error: Object required".
From the first code, after running, it also copied the whole data rows, which is not needed. if i have a 50k of rows.. it take some time to finish it.
Can you modify it so it will only copy the string values that is needed.
Thanks.
Re: USD $10: Extract Material Types from CSV to Excel
Hello AlanSidman, I got an error source.Sheets("Materials_v1")=<Subscript out of range>
Also it is possible to prompt the user which csv file to open.. since sometimes the name of the csv file varies.
Thanks.
Re: Analyze Name - 15USD
Work perfectly. Thanks a lot.
Dears,
Need help in vba to summarized my table based on two sheets, at Sheet1 vlookup the col Alias value with respect to the value at col Links which is separated by a delimiter semicolon. This values can be found at table at sheet2 col A-B, if found, concatenate the value at col C with semicolon and sum up the value at col D.
The values at sheet1 col B should disregard the string "/1" at the end of each values which is separated with semicolon.
Same with values at sheet 2 col B should disregard the string "+" at the end of string values too much each other.
Please see the output sheet to see the result.
Thanks.
Ivan
Re: USD $10: Extract Material Types from CSV to Excel
Unable to upload csv files.
Pls see updated csv via google drive.
https://drive.google.com/open?…xDeeb_bRtwbE5NdFo0OGs1aW8
br,
Ivan
Re: USD $10: Extract Material Types from CSV to Excel
Dears,
Please see attached file. I just change the csv to txt, but the actual file is csv. The output should be like the attached excel file.
br,
Ivan
Hi All,
I would like to extract my csv data with respect to there material type and position.
@CSV file with Column name TypeOfUnit to be exctracted on excel sheet format as per below link
Column PlaneType: Name with string that contains value of "AM"
Column NNUType: Name with string that contains value of "NNU"
Column SFPType: Name with that contains string value of "SFP"
Pls check the CSV file here..
https://drive.google.com/open?…xDeeb_bRtwN0dUbDhZZVZqS28
The Excel Output here..
https://drive.google.com/open?…xDeeb_bRtweTJtd3ZLSHZqcWc
br,
ivan
Re: Analyze Name - 15USD
Thanks GCExcel. It works fine now, only the exception "BH_BSC".
Re: Analyze Name - 15USD
Good day.. I just test your code.. some part seems ok but still need to fix some debug.
i have a node names like below, the last row i added an exception on the code but it gives wrong result.
[TABLE="width: 382"]
ER_XCBMakati_TN1
[/td]OK
[/td]ER_XCBMakati_TN2
[/td]Wrong Index / Missing other node
[/td]ER_XPGMakati_TN2
[/td]Wrong Index / Missing other node
[/td]ER_XCBBH_BSC_TN1
[/td]Site is not a number / Name not found
[/td]
[/TABLE]
[TABLE="width: 413"]
[TD="class: xl66, width: 111"][/TD]
[TD="width: 59"][/TD]
[TD="width: 243"][/TD]
[/TABLE]
Also, it is possible to run the code without typing the function anymore, since i'll be having a thousands of rows to analyze it and it taking some time to process.
br,
ivan
Re: Analyze Name - 15USD
Thanks a lot GCExcel. Im out of my desk, i'll test it after a day and send you if there's something to be fix.
Re: Analyze Name - 15USD
I already made the payment. Pls check. Thanks..
Re: Analyze Name - 15USD
Hi GCExcel,
Yes, i already paid 10% in paypal.
Yes the parameters is in sheet1.
The exception is for the site number not for the cities. Since some node data name have this instead of a number. so by checking it logically.. if it doesn't found a one to four digit number.. it should check this exception list.. if doesn't found put the remarks.
The site number list mentioned is just a sample.. so the possibilities 4 digit number is from 0000 to 99999.
Thanks..
I would like to analyzed my table node sheet at columnA with respect to the naming criteria mentioned on sheet1.
The remarks is based on what will be the findings when it was analyzed.
br,
ivan
Re: Excel VBA - Search and Remove String Data
Wow.. It's work perfect. Thanks a lot MickG.. :wink:
Dears,
I have a thousand of data rows, which i needed to rename and remove a specific string from sheet2 if found in columnA data string in sheet1.
Please see sample file.
tnxs..
ivan
