draft

Anyone else into fantasy sports? This year for our fantasy football draft, I'm attempting to use similar methodology to the NHL and NBA drafts. I posted about it on Reddit just trying to get the general methodology understood, but now I need to figure out the "how-to" portion. Can anyone...

Hello all, I hope everyone's healthily and happy and enjoying the sun. (if in the Southern Hemisphere) I don't actuality have an issue or application question as such but more of a quick check over so I know if I'm applying the correct methodology. Apologies if I've post in the wrong forum, I...

I need help figuring out what function to use in order to assess the accuracy of a mock draft based on a point system I found online. I created 2 sheets: Sheet 1= which contains the actual results of the upcoming NFL Draft (which I will update as picks are made) and Sheet 2= the predicted...

Hi All! I'm creating a dataset type of spreadsheet where I monitor data of three different types for example distance , velocity and acceleration. Each has its own sheet and results are logged for different years 2015,16,17,18 etc. Id like to program an input data tab where i can paste the...

I draft a bunch of fantasy football teams and would like to take all the players I have drafted (from about 20 drafts, 28 players each) place them into an Excel file to determine ownership percentages. Trying to determine my exposure to player. The app I use to do the drafts allows me to...

Hello, I am doing a vlookup between two workbooks in each of four cells (A3 - A6) based on the value in A1. In A2 I have 4 different options that get inputted, separate from these vlookups. What I would like to accomplish is to only show values in cells A3 - A6 based on the value listed in...

Hi Champs, Here is a challenge. I'm having a generic outlook email draft to be sent out 100 times in one batch to different recipients. There would be a couple of editing done before sending it out. E.g. is below Outlook draft: To: xyz (Editable) Sub: This field is static Body: Dear...

Hi. I have created a macro to which works as below First part one procedure refers a CSV file, create mails based on the row input & saves them in draft folder. this is important because I want to review mails before sending them / i may decide not to send / send later.... Second part other...

Hey all, I am trying to set up "draft boards" for a youth sports organization and we run the drafts in standard snake order (see example below). I have to do this multiple times per year for for varying number of teams (sometimes as few as 8, sometimes as many as 22) and it gets tedious...

Hi All I have a Userform that passes its values to the next empty row and now I need to update the version number column. If cell in column B is Draft then find last draft version and add 0.1 to the value in column A unless if last draft version is less than last Approved version then in that...

<tbody> 1=No, 0=Yes Day Date Status OPEN BOL # Invoice TTL Draft Date Add Days Monday 1/1/18 N 1 1/11/18 0 Tuesday 1/2/18 Y 0 1/12/18 0 Wednesday 1/3/18 Y 0 1/13/18 1 Thursday 1/4/18 Y 0 1/14/18 1 Friday 1/5/18 Y 0 1/15/18 1 Saturday 1/6/18 N 1 1/16/18 0 Sunday...

I have a excel VBA to help draft email using a common email address, after that will help to move the email from my personal draft box to the common email draft box. Everything's lok fine if the one who run the macro go to send the drafted email, but if another person wish to send the drafted...

Hi , I'm sure this is something that I should know but i'm still a bit of a beginner. I have a VBA form to input data to a spreadsheet. When you enter the details it gives the option to email the info to the required person. It brings it up as a draft so you can add or change anything before...

Back Story: A couple years ago I created a FF Draft Board for my fantasy league. I hook up my laptop to my two smart TVs. One screen shows the draft board. The second screen shows each team's roster as they are drafting. The draft board will fill in the players team and position after their name...

Hi and Thanks in advance! When I want to sent a mail using outlook and VBA I can use: With OutMail .to = "peter123456@gmail.com" .CC = "peter123457@gmail.com" .BCC = "peter123458@gmail.com" .Subject = "My Name is Blas!" .HTMLBody =...

Hi, I have a 'draft timetable' sheet like this: <tbody> Harry Trumpet Wednesday 10:30 Wednesday 11:00 Jackie Saxophone Wednesday 11:30 Bob Flute Wednesday 12noon Jill Trumpet Thursday 10:30 </tbody> And 'final timetable' sheet that I want to look like this (no empty cells)...

Hi, I am trying to edit below mentioned code. Brief about below code. This code will check each item which is open. Open here means, user has manually clicked on e-mail for 'Reply' 'Reply to All' or 'Forward'. Code will check all such open items from Outlook. However, I want to edit...

Dear All, I first thank the Admin & contributors of the forum for having provided a platform to learn & discuss. This is my first post in the forum. I'm in need of a help. I'm in process of making a Tracker for 10 Elements in order to complete 1 Activity. There are 100 such activities...

Hello all - I am trying to search for a solution to my issue but have not had any success thus far. Firstly, I should admit I have only used VBA in Excel - and I have never used in Outlook. Now with that being said, let's get to some general information... I have a template email saved for...

Hi there, I am using a PC with Microsoft 10 at work. I couldn't find a code online that would do exactly what I need. Sorry that I have no code to offer. DETAILS: 1) The set of PDF's to be emailed will be in the same folder. 2) There will be several PDF's in that folder, but I may only...