I'm using Excel to keep track of my bowling scores. I can do the basic stuff with sums and averages and whatnot, but I need some help with some more complicated stuff.
I want to account for when I bowl more or less than 3 games a session. For example, if I only bowl one game and get a 180, I don't want it to think my average is 60.
I already started a basic spreadsheet if anybody wants to help me with what I'm trying to do. (Feel free to add more stuff like graphs and whatnot and make it look better if you feel like it)
I've seen a few bowling formulas within mr. excel but nothing in code. so i tried it and the only problem i have is when a player strikes.....then the code should add the next two balls thrown..... it works if the next two are strikes but not if there is no 'mark'. So basically its not adding the second ball. The code looks right unless I'm just missing something. heres the code....
I am looking to create a macro that will create a new sheet when data is added on a summary sheet. Example.
1. Summary sheet called "Variations" contains columns that will contain the information needed for new sheet (Columns A to D)
2. When data is entered on "Variations" sheet: Column B, then macro automatically creates new sheet renamed to e.g. VO1 (Number used on "Variations" tab) and is a copy of "Master" tab.
3. Data entered in Column A to D on "Variations" tab is automatically entered onto new sheet created (e.g VO1). Shown is blue on attached file. Additional data is updated on "VO1" sheet and this then links back to "Variations" tab
I want to see if i can make a formula that works out how a player got a score based on a scoring system. See the attached file for more details. I want this to show that the player scored or didn't score, played a full match or was a substitute, was booked or wasn't booked and was sent off or wasn't sent off.
I am currently working on a score sheet with list of question.
I have: On Sheet 1 (will be hidden later) List of 14 questions (e.g. question 1 = 6 possible answers, for answer 1 is score -2, for answer 2 is score 7... etc). In column C are possible answers, in column D are the score values.
On Sheet 2 (will be visible for participants) Drop-down list based on Sheet 1 questions (Sheet 1; Column C) I have set Cell link for each question so when you choose the 3rd answer, there is number 3, but I need to set different values based on Sheet 1, could be that 3rd answer is score 12. I do not know which function to use (I tried IF, but to me it seems too long and difficoult).
I have running total of bowling scores current & going back from when I first started.
What I’m trying to archive is a formula that will count the most recent 96 scores and still allow me to add new scores each week in keeping the current running total of 96 games.
The statistics are listed from A4:C215 that may have 1 or 2 scores not listed. (missed games)
Each week new statistics will be added in cell A4:C4 anywhere’s of 1-3 games.
I have one excel file with three sheets marked 1,2 & 4
Sheet 1. is the place we add the description and the member number. When a member number is entered it gets the member name from sheet 4.
Sheet 2 is the page I need to change. Currently we can enter any score number in each box between 1 to 5. If we try to enter other numbers we get an error message.
I need to change the form so we can enter 1 to 10. Any other number needs to generate the error message.
I run a golf society and need to set up a golf aggregate sheet that will allow me to enter the players weekly scores and the sheet will then look for the lowest score entered for each player and replace it with their score of this week.
I'm Seeking in InRegards To Working Out How To Display Multiple Leaders Within The Same Cell Based Apon There Score In A Game Of Golf, Or If This Cant Be Done Perhaps A Message Saying "Multiple Leaders" So That It Is Known That Its Not Just The One Persons Name That Is Been Displayed. I Have Attatched The Document I Have Been Playing With While Trying To Work It Out Before Making A Big Sheet.
As You Will See "Daniel" And "Paul" Both Have The Same Score, And Below In The Summary It IS Currently Only Showing "Daniel" As The Scratch Leader, Is There A Way Of Getting It To Show Them Both As A Leader, EG: "Daniel, Paul", Or As Said efore Just Saying "Multiple Leaders" Thus Having To Manual Go Through Them ( The Fist Option Would Be Better As There Will Be Approx 85 Names In The Final Sheet)
I have a paper-based scoring sheet that we use to determine a rating category. I cannot figure out how to convert this scoring sheet into a lookup region and use some type of LOOKUP formula to determine the rating. I have looked at the various Grading examples on the Internet that show you how to look up a grade, based on a score, but they only look up a grade, based on a single input (the score).
Here I have two values going in--the person's age and their score, and I need to look up the rating, which is the column heading.
Can anyone point me in the right direction?
I've attached a sample spreadsheet which shows the original scoring sheet.
I am trying to set up payment record sheet as follows
First Tab: This is the total value of each item, with the payment date in cell C1
Second Tab: Is the payment date of the item
Third Tab: Is the payment due tab
So what I want to do is enter the payment in C1 on the first tab. Then on the second tab I want to enter all the items that want paying on that day, but this will also have previous payment dates shown as a sort of record of what was paid on what day.
On the third tab I want it to show all the payments that correspond to the same date as C1 DATEVALUE
And on the gross tab I want to show all payments to date including the current date.
I have got the payment date to work but I cant get it to show all the previous values.
I have a code... and I am trying to use it with a different file.
The files is set up the same, the code has been unedited, but it's not working
Sub findAndReplace() Dim ws1 As Worksheet Dim ws2 As Worksheet Dim searchFor As String Dim searchCol As Range
Set ws1 = Sheets("SBK") 'sheet for which we look in column A Set ws2 = Sheets("Sheet1") 'sheet we try to match with column E
'last row on the sheet with the updated information lastRow = ws1.Cells(ws1.Rows.Count, 1).End(xlUp).Row....................
I want it to look in SBK at column A and match it to column E of Sheet1. Then copy collumns DEFG from SBK to DEFG of sheet1.... Is there some reason it's not doing it?
Once again I need your help to solve my problem. I have attached one zip file which contain 2 excel file.
1. Master.xls 2. Corporate Documents Master file- Till DEC 08.xls
What i need to do is that ? i need to execute the macro from master.xls. The macro need to ask the input file, the input file will be 2nd excel file.
Based on the "TAG" column value in the master.xls file it need to check that value exist in the second excel (Corporate Documents Master file- Till DEC 08.xls) column "INVESTOR'S NAME" for example :-
If it check for TAG value :- PVT LTD
Matching Record will be :- Record 2, 7 , 14 ... etc.
A column need to be inserted next to it and name it as "NEW INVESTOR'S NAME", What ever record matches need to remove the TAG value eg. "PVT LTD" from that name and copied to the "NEW INVESTOR'S NAME" and high light that changed field with red colour. The record which doesn't contain any TAG value mentioned in the master.xls file need to be moved like that to "NEW INVESTOR'S NAME"
After that we need to sort column "FOLIO ID"+ "NEW INVESTOR'S NAME"+"Documents", if you find any similar record we need to move all the record it new sheet we name it as "Similar Records" leaving one record in "Corporate Documents Master file- Till DEC 08.xls" sheet. In "Similar Records" sheet at end we to add on column name "Master Record Row Number" there we need to enter the row number where that similar record in the "Corporate Documents Master file- Till DEC 08.xls" sheet.
I have a table where I have dropdown menu for selecting data and a vlookup for filling other fields.However, I would like to create totals at the bottom of the sheet. But I dont know how many rows I will need because the data to this sheet are added from another sheet in the workbook. I would like to create something like this :
No. Name Weight Amount Total Weight Unit Price Total Price 1. Product 30 2 60 100 200 then I will not have no. 2 , but add new record button that will create a new row and will copy the dropdown menu and the Vlookup function so the format will be the same for product no.2 as it is for the product no.1 ... thus I will not have any unfilled rows in the table and after the last row there will be a totals row that will sum up the whole table... How to do that "add new record button" so that in the table will show up only those rows, that are actually filled with data?
I seek advice on using the value of NOW() as a record ID in an address book program. Question #1: Do Excel developers often use a record ID? Question #2: What record ID schemes are fequently employed besides date/time? I have decided to create an Excel address book as an exercise to increase my knowledge of VBA, and also as a useful application for work.
I realize that a record ID is not essential in Excel in the way that it is essential in Access, but I feel the need to have some unique ID associated with each address, so that I may have different worksheets, with data related to a given Contact, sort and manipulate it, if necessary, but have the record ID as a way to restore the relationship of rows to a given Contact, and also, as a handy way to examine the data in the date/time sequence in which it was entered. I have experimented with the following code, to assure myself that I can access the number returned by the NOW() function, manipulate it as a string, and format in various ways if necessary.
Dim n As Double n = Now() sn = Str(n) p = InStr(sn, ".") first = Left(sn, (p - 1)) l = Len(sn) d = l - p S = Mid(sn, (p + 1), d)....................
I have two sheets one = where I am entering day to day data two = For getting result
Once I entered data in first sheet then I want date wise record in another sheet in which I will enter date. After entering date all the record will be inserted in another sheet from first sheet And main sheet will remain with all records
I have a macro which changes a worksheet based on each record from another sheet, it then copies the worksheet. I.e. a new sheet is created for each record simpy with...
I have SQL data that I'm extracting and populating two sheets accordingly on daily basis. (This is done manually and sheets are refreshed with new data)
Name of tabs: (Peaked & Confirmed)
Each sheet consist obviously of different data but table extract contains the same name & number of columns.
Name & Number of Columns :Org_province Port_Of_Load Port_Of_Discharge BK_Client_Name FF_BK_Name VesselVoyage GrossWeight Export_Closing_Date_Yard................
I get some records from XML and display in the sheet. Now, I need to put an image for each record in the sheet while displaying records. And also on click of the image I need to have some code to be executed.
once I get the pretty boxes and such, how do I link this form to a sheet to record data? How do I get it to run? I have tried searching the forum, but it seems that most of you already know that part and don't have any problems there.
I know this is probably very very basic and I will smack my face with my hand when you point it out. I just have never created forms with Excel before. I am used to using SalesLogix and when I create forms there, I have a database table that I can link each field to, so I keep looking for how to link to the table and I can't figure it out.
a macro or code to copy row B10 To another sheet as a record but paste it down a row as i keep overwriting previous paste, tried offset etc but still stuck. I HAVE THIS SAME PROBLEM ON 2 SPREADSHEETS NOW. All i need it to clone the top row everytime data is put there, but where the data goes to paste it down a row so creating a record. Also i need another macro to search the G10 cell of the same row for the word replace and if so copy that row to another sheet as well.
I have the day of the week in B1 Emp Nbr in B2 Hours worked on B11
What I need a macro to do is match B1(day of the week) with the corresponding offset column in F1-R1, Pos and Post the Emp NBR(b2) and Hours(b12) in the corresponding column (F4 and G4)
I then will key in a new Emp and the hours and click the macro to execute the move over to the correct column and down one row.
Do this until I post Emp 999 at which time it will exit the macroOzgrid weekly hours.xlsx
The next day I will change the day in B1 to 2, corresponding to TUE, and it will move over to the correct column (H4 and I4) and post the daily data until I key in EMP 999
I am a bit stuck with an excel spreadsheet I do for work and would like to ask your advise, I will try to explain as best as I can. I am running a small store that feeds 13 buildings.
On the spreadsheet there are 13 sheets, one for each building. The items will go out monthly.
What I need to do is record the total items from each sheet in a column called All Totals on the first sheet, this will add up the totals for all the buildings.
If I put an attachment that may help out a bit. If you can look at P3 it is all the P3s to add together, next down will be total of P4,P5,P6.
I am creating an asset management sheet. For the formula I am trying to work out there uses 3 fields : ID, start date, and end date.
What I want to do is be able to show if the ID is duplicated within another record with an overlapping date. So an item is flagged if it is in the list within the same dates as another record. I tried a few countif formulas but with no success.. I may just be approaching the problem incorrectly though.
This problem seemed to revolve around "digital signing" with further macro changes done from a different machine (without the proper certificate). Excel warns of the problem and then "unsigns" the project.
I've got a problem with spreadsheets that I've been working on. Now, when I tell it to record a macro, I get the macro name, shortcut assignment dialog box and then an error "Unable to record." After "Ok"ing that dialog box, the normal recording macro dialog comes up. Also, lo and behold, there will not be a macro recorded.
I've got no protected cells or sheets and it doesn't matter what security level is set. It is a "signed" macro but I can take off the signature and still have the problem. I checked for "Help - About" for deactivated modules and there was none.
im using spreadsheet works which seems to be very similar to excel. i am making a table full of numbers and i want to count how many times the number 1 appears and for that amount to be displayed.
i have a list of names in column A and a corresponding score for each name in column S. on a stats sheet B10:B15 was trying to make a top 5 list using =LARGE(Week1!S15:S46,1) ... with Large i am able to get my top 5 from the week1 sheet but how can i assign the corresponding top5 persons from column A15:A45 in week1 to the stats sheet in column A10:A15