challenge

All right . . . I have been bashing my head against a wall for two days now because I got interested in solving this issue. I have a cell that contains thousands of names in the following format: Smith MD, Bob; Savage DDS, Fred; Doe MD, Jane; . . . et cetera I have already fixed the issue...

Hello everybody, I posted this question a few days ago and haven't gotten any replies. Not sure if this functionality is just too hard to do in Excel or if I wasn't very clear in what I'm trying to get the spreadsheet to do. Any help would be appreciated! I am working on a project in Excel...

Hi, I am inputting alot of raw data from the field and Excel programming of this sort isn't my strong suit. Basically I have Seven Columns, Column "A, B,C, E" are the one i need to sort, column A is a type of configuration FFC-0###, where the number signs correspond to different locations, the...

Hi Everyone, Here is my challenge. It may sound easy but I have not been able to find a solution as of yet. I am creating a template so that when I upload data it auto populates and I have little work to do. Here is my problem: I have a list of Sales and wish to rank them (easy...

I am in charge of inventory for various pieces of computer equipment. My office loans out equipment on a daily basis. I would like to either write some code or a macro that will fill a cell with a certain color (like red) if an item is checked out based on a specific value in a cell. For...

Hello I have a friendly challenge for the board. I have some code I built that I want to see if anyone can improve the performance of. I never had any formal VBA education other than the trial and error method and learning from looking at different code on this board. Here is the challenge...

Hi, AMP, an Australian financial services firm, has built a retirement calculator on the web that made me hear a "klunk" sound when my jaw bounced off the ground. It has a bar graph with a second Y axis. The second Y axis features a horizontal line with a spin button on the end that moves...

Hello, I have a HUGE list of either 2 digit or 3 digit numbers in column I. I'm trying to set up a macro that would convert this whole column into a single digit number by using the numerology method. This is it in a nutshell: If cell I1 was to have '157' in it, I would like cell J1 to contain...