teams

  1. T

    Open file in MS Teams for editing ?

    Hi I want to open a sort of Back-End-file (.xlsm-file) stored in MS Teams, edit some data and close the file with av macro from a Excel “master file”. But I can’t find out how to do it. Everything I do will open the BE-file as “read only”. Please help! I think it is the same if stored in...
  2. I

    Is it possible to link Excel UserForm to OneNote?

    Hello, I've created a UserForm in excel and I'd like the userform to appear on my teams OneNote notebook. Does anyone know how to do this? Or if it's even possible? Thanks,
  3. N

    Excel worksheet in Teams

    Hi all, My workplace has recently moved across to O365 and use Teams. Within our Sharepoint file structure/Teams, we have a workbook that is manually updated each week. In the workbook, I have a sheet, called 'Dashboard'. On it there are a series of view only charts. Does anyone know how I can...
  4. B

    Practice Schedule Help

    Hello all, I need some help I have 10 teams that need to be scheduled for practices for a season. I have a spreadsheet of he time slots that are already predetermined. Is there way to distribute the teams across the time slots to reach their required practice counts? For example, tier teams...
  5. P

    Countif issues

    i have this scenario where i wanted to count the number of days an agent was present on the summary field with two criteria <tbody> Teams Emloyee 1Aug 2nd Aug A mark P A B zack P P </tbody> There are two validation field somewhere on the sheet itself with the list having the...
  6. S

    Sum non adjacent cells with criteria

    Hello I have data to analyse game result as follows. Every team has to play twice with the same opponent yielding Score1 and Score2. I have to add total score of each player on a table 2 shown below. The main problem is the number of team will be changing. If a team is added then every team...
  7. S

    Copy then paste to specific cells where criteria matches

    Hello everyone! I have an excel file where some data is provided by other teams (call this the "Source"). I need to take this information and copy it to specific columns in another excel workbook (not worksheet) (call this the Destination) where the Province matches in both worksheets. I am...
  8. M

    Allocation Tool

    Hi. I'm a an excel novice so apologies in advance. I need to create an allocation tool which distributes work evenly amongst teams. We receive a different amount of queries to get through everyday so would need to amend the daily allocation. Each of the teams have different targets which vary...
  9. J

    Data Dictionary Best Practices

    This is probably something simple but I just wanted to know all my available options. I own and maintain a data dictionary that I keep on Excel. There are around 12 columns, all with headers. The columns are meant to identify all the attributes of a particular data element. Each row is a...
  10. M

    list contents of a vertical table's rows in columns?

    I have a table of football teams one column wide and of 10 rows. I want to create a table with teams down the left hand side and along the top so effectively creating a grid of all teams playing against each other 100 cells (I know you have to blank some) I'm using tables because teams might...
  11. C

    Search for duplicate data for a specific date

    Sorry if title is a bit misleading. I am trying to find a way to search for duplicate data in columns 1 and 2 to see if they are on the same date that is in column 3. To clarify a bit more, I am creating a sports schedule. In columns 1 and 2 are the home and away teams. In column 3 is the date...
  12. D

    Excel on MS TEAMS

    Ok first I will apologize cause this is not just an Excel question. I have Excel workbooks linked to each other on a file share. I wan to move them to TEAMS which essentially is SharePoint on the backend. The question is how do I link sheets form one file in TEAM A to a file in TEAM B? I can...
  13. L

    I need VBA code to copy data from grid schedules to teams worksheets

    I want put NFL grid schedule into teams worksheets. look at worksheet Teams by division. I want a vba code on the button is on worksheet that is called Put schedule into teams worksheet. GET PICTURES HERE IS ZIP https://1drv.ms/u/s!AnJwxxiz0Ezpg8c5giTqpAFxNZfW7g GET FILE HERE...
  14. S

    Getting macros to function in MS Teams???

    Hello All, If there is a technique for enabling macros in Microsoft Teams, please tell me. I developed this shift pass-on macro filled workbook, and now my employer wants to upload it to MS Teams, and of course all of the macros are disabled. I searched the Forum here and am surprised that...
  15. A

    Schedule creation

    I don't know if excel will work for this so let me know thoughts. Trying to create a macro to create a racing schedule. Criteria : Multiple clubs, each club might have 1 to 6 teams. 2 teams race at a time against each other. Each race might be a 3 of 3, 4 of 4, 5 of 5, or best 3 out of 5...
  16. H

    help with efficiency on football database

    https://imgur.com/r5isISk hi everyone the link there takes you to a screenshot of a spreadsheet I have operated for several years to record results of a weekly indoor football game with friends with teams chosen at random. hopefully its reasonably self explanatory how I have set it up as it is...
  17. B

    IF Statement

    I am trying to do an if statement based on another if statement: So if someone is In a team I want the formula to do another If statement based on this. Below is my current formula: =IF(C2<54%,"1",IF(C2>=80%,"2","3")) But I need to repeat this if statement 3 times as I have 3 teams with...
  18. S

    Generating Random Teams While Rotating Players In

    Hi All, I ran into a wall and hope someone can help. I currently have a clunky spreadsheet that will randomly distribute 16 people into 4 teams of 4 for our volleyball games. What I actually need to do is for the spreadsheet to distribute 20 people into 4 teams of 4, and hold the 4 remaining...
  19. T

    Excel to insert cells based upon a value

    Hi All I am going to try and explain this a best I can. I am trying to create a spreadsheet for my football league. On one sheet I have a table of all the teams in the league and then individual tables for each teams showing the players. On another sheet I want to enter the results from the...
  20. K

    schedule generator 2 game per day (darts)

    hello im looking for a fixture creator for playing on the season 4 to 5 time each teams and we are playing against 2 teams each tuesday the number of team can also change from 12 to 14 can anyone help me ? Regards

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top