Info From One Worksheet To Others For Hockey Draft?
Feb 16, 2012
I've got an excel master roster sheet filled with youth hockey player info and stats. Fields are in columns, and a couple hundred rows of players. What I'm planning to do use this info for a spring teams draft. I've got a blank field/column ready to write in the team names to which each player will be drafted.
What I'd like to do is have several other 'team pages' in the excel workbook that first look through the master roster sheet, checking for a matching team name. Next, those team pages would populate themselves with all the player information on the master sheet, provided the team name matches. Basically I want to have the rosters created automatically rather than doing any autofiltering after.
I did try a VLookup function, but it would only pull the first matching record, and nothing after.
View 2 Replies
ADVERTISEMENT
Sep 29, 2009
I have a complex sorting macro with userforms & Modules. Works great! Now I need to save the final Worksheet without the macros. The final step to my project is a Application SaveAs. Can I add a delete-all-macros step when the user clicks the Save As button which would create a new workbook with the finished worksheet and NO macros?
View 9 Replies
View Related
Apr 21, 2006
This might be a little long/difficult to explain so I have attached the excel sheet for viewing.
I am trying to adapt cell I11, which now equals cell B10 or B12 (depending on where you type in the "x"). I am trying to formulate it to be either cell B10, B12, B18 or B22, I want it to read the highest seed number (5, 6 or & 7) again depending on where you place the "x". Let me know if I have left anything out.
View 8 Replies
View Related
Apr 24, 2014
I am trying to build an excel spreadsheet for a hockey program I'm coaching that will do the following:
Create 4 teamsThere will be a Team 1 White/Dark, and Team 2 White/DarkUse 2 lists to distribute players evenlyThere are a disproportionate amount of players on each list. There are 8 Majors, 12 Minors. 2 Majors maximum need to be on every team.Every week, the roster will be different (some don't show). I need to be able to hit 'randomize' and exclude certain people, and still have the lines 'relatively' similar This is an essence two 3 vs 3 games, with a white vs. dark on each side of the ice (2 half-ice games). If there are 3 majors on each side (6 in attendance), one side will have a white with 2 majors, the other side will have a dark with 2 majors.
I'd also like a way to keep track of who's played with/against who, so if I can export that data set to ensure I don't get a duplicate team...or a primarily duplicate team.
View 4 Replies
View Related
May 20, 2009
I am using the following code to send emails, it's from Ron DeBruin's site. It works, but how can I edit so that it doesn't send the file, but saves it to your drafts??
View 3 Replies
View Related
Aug 8, 2014
I'm having trouble writing a forumla that will grab a second player from a list.
For example, there are 3 possible QB spots. I need a formula that will grab the 1st QB, the second QB if a 1st has already been selected and a 3rd if a 2nd has already been selected. This is what I have but it's not working right.
=IF(NOT(ISBLANK(B2))="True",IF(QB!E2:E71=Summary!A1,QB!B2:B71,"N/A"),"")
View 4 Replies
View Related
Dec 23, 2013
Creating email drafts with the use of VBA in excel.
I've used some of his code to create an email draft to send a particular range within my excel spreadsheet. The trouble I'm having with it is keeping the hyperlinks within each cell in the range which will take the user to a particular website. How do I keep this formatting when the range is copied into the body of the email.
Example Cell A10 = HYPERLINK("URL","Google")
The hyperlinks are lost. How to keep these? Here is the code
Sub Mail_Selection_Range_Outlook_Body()
Dim rng As Range
Dim OutApp As Object
Dim OutMail As Object
Set rng = Nothing
On Error Resume Next
Set rng = Range("EmailRange")
[Code] ........
View 8 Replies
View Related
Jun 20, 2007
Im trying to take information and have it copy to a different worsheet when a certain selection or type is put into a column.
Example:
On worksheet "Alpha"...
Column "A" will have "Maintenance, Supplies, or Payroll" in it.
Column "B" will have a currency.
On Worksheet "Bravo"...
I would like to have everything from Column "B" on "Alpha" to be placed here that has "Maintenance" in Column "A"
On Worksheet "Charlie"...
I would like to have everything from Column "B" on "Alpha" to be placed here that has "Supplies" in Column "A"
Etc...
View 10 Replies
View Related
Sep 7, 2009
using VBA, I created a simple problem that I can't figure out how to solve in worksheet 2, I have 3 worksheets.
1. Players - Complete info of players
2. Members - When I select the team name, I'd like to display the info First Name, Last Name and Team only for the team name I've chosen. This should automatically change whenever I select a team name.
3. Team Codes - Tables I used for my vlookup and drop down list.
I have attached my file for your reference.
View 9 Replies
View Related
Nov 2, 2008
i need to get certain info from one worksheet to another is there any way to do this automatically
View 9 Replies
View Related
Jul 31, 2007
I am working on a product quote pricing worksheet. I have several products and on my one worksheet I have about 5 different columns with drop down boxes with several different choices. I want to know if there is a way to select something from the drop down list and once something is chosen information on that particular product can populate a cell on another worksheet.
View 3 Replies
View Related
Jun 11, 2013
I don't really know how to search this question but what I am trying to do is pull information from one worksheet to another only containing numbers greater than 0. For example, i have an order sheet containing everything that is in stock, then I go down the list and put in the number of items being sold (1,2,3, etc). Some items will have a value of zero.
Then the items that have numbers (the ones that are being sold) I want to be able to pull these numbers along with the item description onto another worksheet which will be the invoice. Then excel will add up the prices of only the items being sold and give me a total value on the invoice. Is this doable?
View 9 Replies
View Related
Mar 5, 2009
I have one worksheet with 238 rows and another with 163 rows. I want to pull information into the sheet with 238 rows whenever there is a match to a record in the 163 rows. I tried VLookup, but as soon as it gets to a record in the 238 that doesn't exist in the 163 it gives errrors and stops. I've looked at =offset and =offset(match) but I'm not finding anything that deals with the situation of not always being a one-to-one (or even one-to many) relationship. Ultimately I want to pull the Category & Project fields into the records matching on IDNumb in Sheet 1 but Sheet 1 has more records than Sheet2. example......
View 5 Replies
View Related
Sep 29, 2009
The worksheet perfectly performs as expected, big thanks to JBeaucaire again. Now, as am looking around of the file and doing some exploration on the array, as I was trying to make this applicable to real life application, I noticed the following mysteries...
1. When I tried to delete some rows, The Members Sheet output went wrong and displaying #N/A. I noticed it's because the formula range have change. But it would be hard for a new user to re-arrange it over and over again everytime when a row is deleted.
2. I've been trying to solve this problem to no avail. I found this link that gives me an idea how my worksheet should work, this was already solved but I can't apply it on my worksheet...
http://www.excelforum.com/excel-prog...nd-resort.html
3. I would like to add another column on A to put the 0 and 1 on, but I don't need to delete this column after the resort so that next time if I need to delete another row existing row i'll just replace the existing 0 with 1 on column A.
View 2 Replies
View Related
Nov 4, 2009
I need a macro to clear data on 2 worksheets that i can add to a button. lets say sheet1 B55:Y55 and sheet2 b102:y102
View 3 Replies
View Related
Jul 11, 2008
I have a userform which is designed to get and enter data into one worksheet.
When I call the userform up from a different worksheet it doesnt refer back to the data source worksheet?? How can I do this?
I have used
sheets("dataworksheet").activate
in the user form initialise event but this still doesnt work.
View 9 Replies
View Related
Aug 8, 2014
I need to create a new excel template for work. I was planning to copy a few worksheets from an old workbook over into the new workbook, mostly just for formatting for some graphs/tables that I would then link to the new workbook. A coworker said I cannot do this as copying from an old workbook will bring in "hidden" data that could some way impact the integrity of the new workbook and that the copied/old worksheet would FOREVER be linked to the new workbook no matter what I do. Is this true? If so, are there things I can do to remove any reliance to the old workbook.
View 1 Replies
View Related
Jun 28, 2013
taking a spreadsheet that has vertical repeating info in Column A and results in Column B and converting that to another sheet in a horizontal list. The main problem is that the repeating info in Column A may or may not always be the same for every customer; therefore, when it is placed in a horizontal format some cells may or may not have results. I tried a arbitrary lookup. Here is the formula I used:
{=INDEX(INFO!$A$1:$B$300, SMALL(IF($A$1=INFO!$A$1:$A$300, ROW(INFO!$A$1:$A$300)-MIN(ROW(INFO!$A$1:$A$300))+1, ""), ROW(B1)),COLUMN(B1))}
That got me started. I am willing to use a macro. Here is some sample data:
Table 1 has a sample of the info:
IDENTIFIER
CUSTOMER INFO
2000
111111
[Code].....
View 8 Replies
View Related
May 12, 2014
I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?
View 3 Replies
View Related
Aug 22, 2014
I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g
The info in these columns at present has been manually entered but I am sure it could be automated.
OOL Roster Final 18-31Aug14.xlsx
View 1 Replies
View Related
Feb 27, 2007
I want to be able to connect two spreedsheets.
I have a "surplus inventory" sheet and a "inventory shipped" sheet. How can I input how much I shipped in the "inventory shipped" sheet and make it take away from my "surplus inventory" sheet automatiaclly?
View 9 Replies
View Related
Aug 5, 2014
I am using VBA to open an IE page and try to get some info however i cant seem to grab it
This is the code i have..
[Code].....
I have inspected the code from the website and it is this
[Code] ........
The problem is i dont know how to get the info in the "Metaname, ICBM".
View 7 Replies
View Related
Dec 19, 2007
I am trying to recall info from the rows in another part of a worksheet when I type the first column. For example, I have over 300 rows of:
Apples 155 12oz red
Orange 120 10oz orange
Banana 50 11oz yellow
etc.
I want to select or type only the word:
Apples
And have the rest of the columns fill in with the rest of the info, like so:
Apples 155 12oz red
A filter would work well to select, except I need about 7 in the worksheet as it is a form and excel only allows one. I can’t seem to make the advanced filter work. An IF function would work, except I'd have to put all the words to match in " " marks, which would be very time consuming.
how I can recall the info from my list to the 7 lines I need to copy them into?
View 10 Replies
View Related
May 11, 2012
how to use vba in excell. First question. 1) I have a spreadsheet with names in column one and other info in columns B-I. I would like to make excell do the following. If I enter the name a second time and so on, then can excel take the info out of certain cells from the first entry? Say column C, D, and G and auto enter them for this new row. 2) can I copy parts of a sheet to a new sheet and then when I make changes or new entries then they will update the copied sheets info?
View 7 Replies
View Related
Oct 31, 2008
i have this code that gives me 1st row of data , from Row 10 of every sheet in workbook, how can i modify to give me row 11 ,12,13,14,15,16 as well upto row 21 if there is Data in Col C ( max range is C10:C21) ,
For intX = 1 To Sheets.Count
For intY = LBound(arySkipSheets) To UBound(arySkipSheets)
If Sheets(intX).Name = "MachCapRpt" Or Sheets(intX).Name = "MachAdSht" Or Sheets(intX).Name = "Times" Or Sheets(intX).Name = "MachSchd" Then
Else
.Range("A" & intNextRow).Value = Sheets(intX).Name
.Range("B" & intNextRow).Value = Sheets(intX).Range("B10")
.Range("C" & intNextRow).Value = Sheets(intX).Range("C10")
.Range("D" & intNextRow).Value = Sheets(intX).Range("E10")
.Range("E" & intNextRow).Value = Sheets(intX).Range("H10")
.Range("F" & intNextRow).Value = Sheets(intX).Range("M10")
.Range("G" & intNextRow).Value = Sheets(intX).Range("W10")..............
View 9 Replies
View Related
Nov 28, 2009
I have the following macro that I found through Search (written by Peterss) and have been able to modify it to work for me.
Sub MergeBooks()
Dim myFolder As String
Dim myBooks
Dim ws As Worksheet, wsMaster As Worksheet
Dim nr As Long, rws As Long, i As Long
Dim LR As Long
Application.ScreenUpdating = False
Application.EnableEvents = False
myFolder = "C:Documents and SettingsNalaniDesktopForecast"
I have been trying to get the information from the Next Workbook to move over 5 columns (E), then the Next book to move to col (I), etc.
View 9 Replies
View Related
Dec 18, 2013
How to return the value of what i looking up. for example i want to find the value of A1 from a range of B1:B10 if A1 is B1 then it return the value beside B1 for example the value of B1 is C1
View 2 Replies
View Related
Jun 5, 2014
I have a spreadsheet with info about students in a summer program. I need to pull out the students who have allergies along with what their allergy is and their emergency contact phone number. I would like this new info in a new spreadsheet.
Here is an example of the spreadsheet:
allergiesnamephoneallergy type
nobob410.555.1234
nojim410.555.5843
yesmeg410.555.7458nuts
nolex410.555.1159
yeswill410.555.5005fish
Is there a formula that I can use?
View 1 Replies
View Related
Jul 8, 2014
I'm copying and pasting data from a PDF and need to eliminate some unnecessary data. The original .pdf has 4 columns: Account, Dollar Amount, Name, Notes
When I copy this to an excel document, it copies the row from all 4 columns into column A. The two columns I need are Account and Dollar Amount. All account numbers are 8 digits so I was able to create a formula to weed that out with this: =left(A1,8)
The problem I'm running into is obtaining the dollar amount within the cell. For example:
A1 contains: 11112222 $1234.56 Sample, Name Sample Note
I pull the 11112222 with =left(A1,8) in column B but not sure how to pull dollar amount to column C.
Further, the dollar amount varies from $1.01 to $10,000+
View 9 Replies
View Related
May 21, 2014
I have names in cells in this format.
Smith John
I would like to switch that around so the name in the cell looks like this
John Smith
Is there an easy way to do this?
View 6 Replies
View Related
