courses

  1. S

    Selecting one Cell highlights all others with the same data

    Morning all I have a worksheet that contains a list of courses for 2 of my departments, Column C pertain to courses "Department A" have completed and Column G pertain to courses "Department B" have complete. There are over 450 courses detailed in each of these columns, with multiple courses of...
  2. S

    Keep cells together when printing

    Hi all I've created the this spreadsheet: https://www.dropbox.com/s/y9nykdyne8p04ku/Executive%20PA%20Diploma.xlsx?dl=0 but I need to stop cells relating to the same course from being split when I print the document. I was going to put additional rows between the courses but this...
  3. R

    Struggling to learn Excel VBA

    Hi I know this isn't a unique question but I've been dipping in and out of Excel VBA for over 15 years and not learned much. Most of the role I currently undertake uses Clas modules, collections, dictionaries, arrays etc... It takes me an age to get even the simplest basic tasks done and...
  4. T

    Using ArrayFormula with Spreadsheet Attached to Google Form Does Not Always Yield Correct Result

    I have a spreadsheet that needs to do X, Y, or Z (which are all various sums of columns of numbers) depending upon two variables: If A=5 and B<>0, then do X. If A=6 and B=0, then do Y. Else, do Z. I have a formula that works correctly without using ArrayFormula: =int(if(and(E2="5 courses each...
  5. G

    Identifying Time Overlaps

    I have a large data set that looks like this: <tbody> COURSE START TIME END TIME Conflict Module 2 28/01/2019 16:00 28/01/2019 18:00 TRUE Module 5 13/02/2019 09:00 13/02/2019 12:00 FALSE Module 6 10/10/2019 09:00 10/10/2019 17:00 FALSE Module 10 28/01/2019 16:00 28/01/2019 17:00...
  6. W

    Copy cell values to another worksheet, reformat

    Hi All, I have a real head-scratcher here. I have a workbook that is being used for document training courses. In it, there are two worksheets: The Data worksheet contains the location of training, trainer, trainee and course data. It is formatted to "look nice". The Summary worksheet contains a...
  7. M

    Conditionally format rows of information

    Hiya, I'm hoping somebody can help. I want to use conditional formatting in the end column called all courses complete. I want the end column to be red and say no until all 6 courses have been completed. Once I put all 6 dates into each course column I want the end column to turn green and...
  8. D

    Create Header Row From Data & Place Column Data Across 4 Columns

    Hi all, I'm required to format .txts into a series of reports. After removing some columns and filtering the courses, this is an example of what I have left (Cols. A to G), with each person having 4 rows of data. The number of people on the report varies. I don't know how to do the final bit...
  9. Z

    UserForm with Checkboxes to grab PDFs and combine

    I am not sure if this is possible, but it seems like theoretically it could be done. I am trying to create a Macro that pops up a userform with a list of courses. Once the user has selected the relevant courses and started the generation process, I would like for the code to be able to first see...
  10. J

    COUNTIF looking at two columns and 13 facts

    I want to automate something I do manually that takes a long time. I have a spreadsheet with training course data. I need to countif (I think) and show learner name (column B) who have "completed" (column F) a list of 13 courses (column G). I have the names of the 13 courses as they show in the...
  11. T

    Accredited Courses?

    Hello, My company has decided they have a small budget for employee development and I was thinking of trying to apply my portion towards a VBA or Excel course. I already do quite a lot of work with Excel and have self taught myself VBA but I thought a course to learn best practices and some new...
  12. O

    Wanna learn VBA to use in Excel - Microsoft Course 2559B or 2373B?

    Hey, Guys I'm graduating in 1,5 years from an MSc Finance and I'm really looking forward to learn how to write code in VBA in order to be as productive as possible when I start working with excel on a daily basis. I have been looking for courses where I can get this knowledge and, to be honest...
  13. K

    Populate ListBox1 with rows that have expired dates in.

    Hello, I have a complex sheet that has hundreds of employee's on who have completed courses. As each month i have to give a list of name to my boss about whose course has been expired (Courses last 2 years). I have the userform all set up, however i can't seem to get the code to search and...
  14. J

    Spreadsheet/Pivot Table

    Hi I wonder if someone can help. I work in a school and book courses for other schools. At the moment I've got one spreadsheet set up with a different tab for each Course. On that tab, I enter the delegate name and schools that are attending the training. On the first tab of the...
  15. L

    Use results of VLOOKUP to auto populate a validated list

    Hi, I would like to use a combination of a VLOOKUP and a validated list. e.g. the choices in the validation list are either "internal" or "external" (methods of delivering courses). The courses can be delivered either way but we have historical data which tells us what is the usual method...

Some videos you may like

This Week's Hot Topics

Top