Search results

Hi guys :) I am studying for the gmat and I have put together a question bank to study for later. I need to place all questions from the data table into a single column and in between each question I need to insert 10 or more blank rows so I will have plenty of space to workout out each...

Hello all :) I want to break a text string of 80,000 by 32,767 characters which would split it by 3 (Round[80k/33k]) columns. But I can't seem to split the string correctly. This is where i got so far, but its wrong. Any help would be appreciated, thank you :) If Len(Text) > 32767 Then...

Hi guys! :) How are we all? Well i hope. Quick summary: I am going through all ("*.txt") files in a folder and finding and replacing values from an excel list. I need to modify the code below so that I can do multiple find and replace. The values to search for are in column "A" and the values...

Hi all, I am web scraping and I found this code which open IE on memory and extracts the information I need. However, I keep getting this message: "Run time error 429: ActiveX component can't create object". I tried changing the "Set IE = New InternetExplorer" to "Set IE =...

Hello fellas! :) I am trying to extract all store locations from these two websites: 1. http://www.reidomate.com.br/lojas.php 2. http://www.franscafe2.com.br/lojas/ Store locations in website 1 are displayed as various tables and in website 2 as a map. I tried using excel's web query and...

Hi all, Normally, I organize my files through excel. I list and describe them, sometimes I need to rename a few and sometimes I want to get the files inside subfolders. Can anyone help modify the code below to add these new features with a msgbox yes/no; 1) include subfolders, 2) rename files...

Hi fellas :) How are u? Let's cut to the chase. I am doing a map research to find the count of stores that are close to each other, inside a 3 km radius. I have a solution but it's long and takes a lot of space. So if anyone can come up with a different more convenient solution, I would...

Hi guys, I am trying to list all the values inside "{ .... }" from the string below. http://casadopaodequeijo.com.br/resource/scripts/custom-map-default.js. I have attached a sample workbook with the example below: Link http://casadopaodequeijo.com.br/resource/scripts/custom-map-default.js...

Hi guys! :) I am trying to: 1) concatenate table headers with there respective data inputs then, 2) summarize inside one cell all the data by person. I've attached a book with an example made manually. Thanks in advance! :)

Hi guys, I have a set of data in column A that goes like this: [A1] Market: Cheetos & Coke | Supermarket X | $ 3.65 [=2.65+1] (Visa) [A2] Lunch: Chicken (200 g) & Salad | Garden Grill | $ 21 (MasterCard) I want to extract the numeric value after the money sign from each string "$". So, what...

Hello, I am having a hard time trying to figure out how to do this, so any help is welcome! I need a macro to add new files not listed in my table to the end of the list with the date that it was added and delete files listed in the table marked with an "x". Thanks in advance! :)

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)...

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 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...

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.

Hi guys, Nice facelift to the forum! It looks awesome, cleaner and more user-friendly than a lot of others I'm part of! Congrats. Let's cut to the chase shall we :) I have a little problem, I am trying to find the total sum using find and other formulas, but I didn't have any luck so far...

Hello guys! I am having a bit of a problem, it looks like a bug of some kind! I created a smartart diagram in Sheet1 3 days ago.. It was working just fine, then, all of a sudden, it just didn't display the diagrams anymore! So I pressed ALT+F10 and I saw the shapes were still there (checked...

Hi all, I am having trouble trying to figure out another way to calculate my total ($) sum of settlements which is triggered through every 1st payment. I wish I could explain this more eloquently, so I built an example spreadsheet...