Search results

Found a couple: http://qualoperadora.info/ http://consultaoperadora.com.br/ http://consultanumero.info/ https://www.qual-operadora.net/

:( Let me do a quick search for another website. Just a sec.

The concatenating part works perfectly, the issue is when I have a list of names in sheet1 and no comments for that on sheet2. The code re-fills the list in sheet1 with only the name that contain comments from sheet2. Please find attached an example.

Hey. So, the results we're coming as invalid. Then, suddenly, after running the subroutine again, an error appeared: "Run-time error '5': Invalid procedure cal or argument."

Hi Marc, Could you help me, its been a while and I tried running the code today and it didn't work. Please find an example attached. Rgds

Hey Somendra, Nice job! But, is there a way to find the name in sheet 1 and then paste the output? Rgds

Hello! I have a problem, which can be manually managed through "Sorting, Concatenate and Transpose". However, this method can consume a lot of time, if not days! Every "comment" I make is entered in Column B @ Sheet 2 and is given a "name" in Column A (each person has more than one comment)...

Thank you guys, but its too big and I need it to be dynamic. Maybe the trick is to just get the job done and use the columns.. Thanks again for helping!!!

Hey Prasad, The % from table1 is my "projection" of how much will be payed from the "Value ($)" per month after the "Date". So for instance, Table1/Row[1]: Date = 5/31/15; Value ($) = 100; Payments = 6 *months for the total value to be payed in full. 1 = "10%" The First month after...

Hello, How is everyone? :) I am trying to find a better solution to calculate the column named "Total Per Month" using the minimum amount of columns possible. Please find attached an example workbook. Thanks in advance! exc4.

I have the telephones lined up in column A, how do i change the code so that it runs through all of them? "&telefone=11976773331" [/]

AWESOMEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE

Hey Marc, I tried the code but, there was an invalid use of keyword: Application.ScreenUpdating = False: [B2].CurrentRegion.Clear: Me.Paste [B2]

Wow Hui! That's awesome, it worked perfectly. Thank you very much!!!

Hey Master Hui, thank you for replying. So I tried what you suggested but the information I imported was different from the website. Rgds, Exc4.

I have a list of mobile numbers in column A:A and I wanted to find out what phone operator they belong to. So, if you open the website link: http://www.qualoperadora.net/ and type inside the box "11976773331", the result will be the following: Número:(11)97677-3331 Operadora: Claro - Celular...

Somendra, Thank you for the solution! And thank you all for helping!

Hey Narayan! Thank you for that, I will take it in to consideration. I saw many examples of entering raw data in different worksheets and turning off row/col. labels is a habit of mine, because my laptop screen is very small :) Anyways, I appreciate your attention and remarks! Rgds Exc4.

Hey Luke, It didn't work, still giving incorrect results. I attached another worksheet less confusing and more friendly. We can do this!!!! :) Rgds

Hey Luke, Lol :) Formulas gave incorrect results. Rgds

Hey, yea I figured that out. Just substituted some formulas in the worksheet it must be working now Somendra. I've attached the file. Rgds

Ohhhh, I see somendra. Check this version, I saved it in "*.xls". Project Year is the year based to determine the "$ per sqm" of the contract. For instance; For any 'new' contract rented (signed) on the 3/31/2016, the monthly rent due $ per sqm during the first 12 months (contract year 1)...

Hi guys, thanks for replying! I tested both and they didn't work. Somendra, Hi, what was confusing? I can try and explain better! :) Please find attached the file with both solutions from Luke and Somendra. Rgds

Hello, How are you guys? :) I'm with a bit of a problem and for a while now I can't find a solution. Its very hard for me to explain it in writing, I might confuse myself and others (lol). So, I've attached a worksheet that explains exactly what I want to accomplish. Thank you in advance! ex4.

Faseeh, thank you for the help. However, the data was set that way, because I couldn't add more columns. Cheers!