help please

Hi I had made a cool post asking for help but it got deleted so Im going straight to the point. I have an excel and In Column B I have the name of different race car drivers. In columns C and D I have their ranked position in practice 1 (C) and practice 2 (D). In column E I have their rank...

Hi All, I am strugling (rookie) with a loop. I think I have the ending of the loop wrong some how? Currently the code selects the folder location then says 'CC Reports completed'. As I am trying to test it, column A has data 4-100 rows long. Column I has data 4-19 with 4 showing true the...

Hi, Can anyone help please. I have a table where I need to extract just the numbers from a cell. The problem is that not all cells contain a number so the cells that do not contain numbers need to be ignored. I have added an extract from my workbook below. <tbody> Walton Vale 1977 UK HQ...

I want to keep a running total of Points, Events, and Cashes from 40 events. The players will vary from each event. And the list of players in the "Total Table" will grow. Also the Player "Rank" will be resorted after every event. I'm still a beginner, and learning as I go. What am I missing...

look in cell G[row] at that number. See if that number is greater than or less than the median of all items in G:G *.8 with the same county in C:C.

<tbody> A 1590 B 11/05/2011 C UK51197810242517032013MSMX 01 D UK511978 E 102425 F 17-03-2013 G M H SMX 1591 18/08/2011 UK52197850242918032013MSMX 01 UK521978 502429 18-03-2013 M SMX 1592 17/02/2011...

Hello The Scenario: the company I work for have four main customers who near the end of every month will e-mail a list of the stock they want, the maximum quantity they can accept and the price they can afford to pay per unit. Say for example we have 28 units of one item and the customers have...

Hello everyone, I am stuck. I am trying to combine several different reports we fill out daily into one workbook with different pages for each report as opposed to seperate files for each report. My problem is these reports were created by someone that is no longer with us and one of the...

I have a workbook with multiple sheets. I am using the following formulas to find the 3 largest numbers in a defined cell across each sheet (L12). I need to return the name of the sheet as well. number will change, and I need the sheet name to be variable based on what the formula pulls in. Any...

Hi all, I'm looking for some help that would probably save weeks of work for me even if a little progress is made. I have a spreadsheet that is as follows (around 7000 rows) Some demo data below ---A--------- B ----------C USERID ----Name1 -----Name2 BSMITH----- BOB ------SMITH AJONES...

First of all thank you in advance for reading this and providing any and all help to this newbie. I am using Excel 2010 and am working on a commission tracking sheet for my company. What I am having trouble with is this: we have a tiered pay out system, that increases every 25 points you get...

Hi there, I am making a rugby player database system in Microsoft Access 2010. I have a main database table with player information AND parent information all in the same record. This is because I couldn't find a better way of relating the player to parent. The difficulty comes because I have...

I have data that comes in at variable lengths in terms of rows and want to have the macro insert a Totals row. The problem I have though is I can't get the sum formula to start from the top and go down through the bottom. If you can help me with this, I'd greatly appreciate it! Thanks!

Thanks for coming to this thread - I appreciate it. I have been working on a macro to automatically prepare a report from some data that is almost in the correct format. I have two issues that are holding me back from finishing the macro (and saving a lot of time). 1) I would like my macro...

All i want is to control the format of the data input to a text box, ie; Date = dd/mm/yy, Time = 00:00, Reference = (maximum 6 digits, numbers only), Post code = #### ###. Any ideas why the below keeps bringing up my msgbox? If Me.TextBoxDate.Value <> Format(Date, "DD/MM/YY") Then...

Hi All, I am trying to convert a table that looks like this: Time; Event 1; Event 2 12:00; 0; 0 13:00 ; 0; 0 14:00 ; 10; 0 15:00 ; 4; 0 16:00 ; 5; 4 17:00 ; 3; 5 18:00 ; 5; 0 19:00 ; 0; 0 20:00 ; 0; 0 21:00; 0; 0 22:00 ; 0; 0 23:00 ; 1...