Where I can find a sample of an Excel Quiz question randomizer. I am attempting to create a multiple choice quiz with the capacity to randomly select 40 questions from a total selection of 120 questions.
I've got a handle on creating the questions but I'm struggling with the randomization part.
I'm creating a fantasy football manager game for a friend, and want help doing the team list and as it all needs to be random, I thought this to be best.
I need to randomize a players name from a first and surname list in Sheet 1, the first names in A1 and surnames in B1 going down to A150/B150, and put them into sheet 2.
On sheet 2, the name would go into A1. I also need it to create a random rating between 30 and 100. This will go in B1. I need this done for 3 players, so these will go into Rows 1, 2 & 3.
Going in column C would be a players age, which I'd like to randomize between 17 and 30.
I have a table in excel that i need to use to mark a 20 question quiz. I have the correct answers in one column and the students answers in the next column. I want to mark a correct answer with 1 and an incorrect answer with 0 marks. I know how to use IF, however the students answers can vary eg, correct answer could be B and D but the student writes B + D. Is there any way of marking this correct even tho it is not exactly written out correct?
I have created a macro in excel 2010 which enable the file to save (extract) data into separate location and name. The vba code for macro is as follows: Question: How can I save this workbook with reference to the value containing in cell B2? (it is named temporary now - as defined in the code)
I have some daily text files in a folder (so about 30 of them each month), which in the end of month, I need to open them up in excel, format them so that I can use the information for my analysis.
I would like to create a macro, to quickly open them all up at once and save them each individually in .xls or .xlsm format.
I am new to VBA and after some research online, I was able to have the files open with the following code. but now I don't know how to proceed further to save them one by one with the same name but in .xls or .xlsm format.
Sub Opentxtfiles() Dim MyFolder As String Dim myfile As String
Recorded macro. The hope is to insert a excel formatted table a set number of times. I have found a loop code that references a Cell A1 and repeats that amount of times. So if A1= 10. There should be 10 tables inserted. However on the second time there is a fault with the table name. I need the name to change each time the loop is run. ie Table1, Table2, Table3 etc up until the loop stops (A1 contents).
I am using excel for windows 2010. The macro that i have so far is below.
Sub LoopTest() Dim n Dim V Range("A1").Select V = ActiveCell.Value
I tried locking an excel document and i ticked a box that said protect structure, and then entered my password and now I cannot open the document. It is a white square on my desktop now with no options to do anything, it cannot even be attached to an email or deleted. This was on excel 2008 on a macbook.
I have an Excel 2003 file that contains hyperlinks to OneNote notebooks on a Sharepoint site. An Excel macro looks for these links and determines the full hyperlink address which is then assigned to a variable. An Outlook message is generated which includes the hyperlinks.
The hyperlinks work in the Excel file. I can also copy them from OneNote and manually paste them into an Outlook message and they work. However, when I obtain their full address and transfer that to the email through code, the links do not work. The hyperlink address from OneNote starts with "onenote:http" which is not recognized as a link.
If I can do this manually, there must be a way to do this with vba. Are there characters I need to include in the OneNote hyperlink address to make this work? Is there another way to transfer the working link from Excel to Outlook?
Is there any macro that can be used to convert data which have been converted from PDF to Excel. Currently I'm using a traditional way by pressing F2 and enter to convert the data to excel format. It's tedious ( since the data range is quite big) and crammed my finger.
I have seen excel zipped but it is visible as excel only. when i double click it it open a folder where same excel document is placed i have to double click it again to open it. how can i save the excel as zip having its same format.
I have defined a name for a data range in an excel file. Now I want to use the same name in different excel file. I tried through various sources but not sure how to do that. Current Soln: I am copying the data from the source file and re-defining the names for the range. But this seems to be duplicate and creates unnecessary space.
see attached excel sheet. On Colum G (highlighted in green) there are hours and minutes. Is there a way I can create a function or macro so that it will convert the values to minutes. For example if the value 1:48 it will convert it 108 minutes or 0:36 will be 36 minutes.
I know I can use =Hour() or =MINUTES() formula but this is long way. My sheet has over 10k data.
I have 8 columns of data that needs to be alternating every third row by subject data, however there is no option under "paste special." I have been googling and I think I might need a "macro" but I am not sure. The values for each cell are unique and do not repeat.
The format should be like this:
1st row =subject A data 2nd row =subject B data 3rd row =subject C data 4th row =subject A data ect..
I have a spreadsheet that contains all of our staff members (around 50 going down the "a" column) and the mandatory training that they must complete (10 subjects going across the top). They are a couple of things that I want to do with this sheet but how to do this.
1) I want the dates in which people's training expires to change colour to blue, those that is about to expire in a month to go green.
2) Copy the names and their training required onto another worksheet so I can keep a list of who I need to arrange training for. Rather than looking down each column and hand writing the names out.is it possible for the sheet to then email me people who's training has expired or is about too?
I need a front worksheet with either buttons or tick boxes that will list different options for a machine
Once a tick or push button is activated a hidden block of text related to that specific tick box needs to be selected and placed onto a final print out sheet (allocation)
when futher boxes have been ticked I would like all the information blocks to build up on the final print out sheet.
I'm talking about the little black box that appears anytime you put the mouse on a cell, or drag the mouse around a group of cells - mine doesn't show up. I can still edit the cell, but I have to guess about which cell I am on.
I am hoping someone can help me out of a problem i have. I have some numerical data (temperature readings) that was recorded / stored to a wordpad file.
I have to do some analysis of the data, such as finding mean / maximum and temperature differentials, which i thought would be as easy as opeining up the wordpad file in excel, and then doing formulas (such as =D7-E7).
However, i cannot get any formulas to cork - they all arrive back with VALUE and although all the data is numbers to look at, it might be stored as a text format? (my laymen knowledge isn't that great!)
am i missing out any steps to be able to use the data i have in wordpad as numbers in excel so i can use formulas?
I have a huge PDF table which I want to export to excel. I tried exporting it using Adobe 10 but all I get is mixedup numbers. Most of the time all the data of one row when exported is only in one cell, which means all the numbers that should appear in individula cells are all place in one cell with spaces. how can I properly export the numbers in the table to excel where each number is in it's own cell.
I'm trying to scroll down my work sheet but it's not letting me. Every time I move the scroll bar down the page it just keeps showing me the same part of the sheet eg cells 1-30 when I want to see all the way down to the bottom. I have some 20,000 lines I need to scroll through but I can't see all of them. To add to this, I keep having lines hide between other lines so theres a big gap like going from line 120 to line 4000 and I have to manually unhide them every time to see them.
I notice that sometimes the "Go To" function does not work. When I click on the named range Excel just brings the cursor to a the first cell of a worksheet rather than the actual cell/range. I find that I need to restart Windows in order to fix this. A simple restart of Excel does not work.
Is it possible that excel can copy a template tab and create a new tab automatically when requested?
I am trying to create a spread sheet to log all spends within the department but need to be able to generate a front sheet for each purchase order request. I have attached the spread sheet and have highlighted what I am trying to create.
I have never used visual basics so am completely in the dark, can excel do this sort of thing?