1. L

    List default based on users information

    Can I have some help please? (See attached image) I have 3 tabs. the first sheet has employee’s data. UserID, Name and Level Second sheet is where I want the help. There sheet shows the users name and level, the level cell is a dropdown list containing all the possible levels. (The list values...
  2. J

    Dependent data validation question

    Hi all, i feel like i've watched a million youtube videos and read a million articles and they all seem sooo similar to what i'm trying to accomplish, but i just can't quite get there... Here's the situation; Excel 2016, will be a shared workbook so no tables allowed, workbooks will likely have...
  3. M

    Validation dependent lists

    Hello everyone, This is my first post here. I've been working with Excel for quite a few years now but now stumbled upon this challenge, for which I can't seem to find a solution. If it's even supported in Excel 2016. Please note I'm not using Office 365 so I can't use all function that Office...
  4. D


    For some reason my match is exactly 1 cell down from where it needs to start and I have not been able to figure out why. Customer A should come up 1,2,3 but I'm Getting 2,3,4 =OFFSET('Customer Info'!$A$1,MATCH($B$1,'Customer Info'!$A:$A,0),1,COUNTIF('Customer Info'!$A:$A,$B$1)) Thank you.
  5. Thumper007

    Formatting on a list Dropdown

    Good Afternoon all, I have a list that contains 3 options. Watch option is a statement. I want to highlight a specific word in each statement and then on another tab, be able to select the statement from a dropdown and have the statement come over with the word still highlighted. Is this possible?
  6. S

    Define a list of files as a variable target (VBA)

    Hello, I use a code to copy files to a template file, and delete old one, then save as old file's name. But choosing every single file for like 500 files, is very boring. Since, I do this operation once a week, now I need more clever way to do it. I use "GetOpenFilename" in order to choose...
  7. M

    Multiple dropdown based on cell value.

    I'm trying to write a macro that with Dependent Multiple dropdown based on Column cell respectively and below mentioned fixed content in sheet2 & in Sheet1 i need the data based on cell value for till nrows. Sample data mentioned below Mname mvalue mtext mid mextn abc 1 xyz q1 po1 abc 2...
  8. B

    How can I generate a list of codes in Excel based on criteria?

    I'm trying to make a list of codes based on a format of 001 A 001. They should be 001 to 062, A to E, 001 to 012. I need all combinations, so they would be: 001 A 001 001 A 002 to 001 A 012, then up to 001 E 012 Then 001 B 001 to 012, and so on until 001 E 001 to 012 Then 002, A to E, 001 to...
  9. C

    Updating a dynamic list

    Hi! I am looking to learn if it is possible to update a growing list within excel through a separate sheets inputted values. I will use name, height, weight, and age as example placeholders. On the first sheet (Sheet1), I would like to have inputs for the above data which will then populate a...
  10. J

    Creating a Client List from Monthly Summary

    For our business we have an excel sheet we track income on. Each month has its own sheet then i have a client sheet where i want to make a list of all clients in each month ignoring the duplicates and also trailing spaces and capitalization. SO basically i need to use VBA to pull First Name...
  11. N

    Removing an item in ComboBox list if already selected in the other Combobox

    I have 2 ComboBoxes. Both have same items inside. What I want to do is when say if "Report1" is selected in ComboBox1, ComboBox2 should not show "Report1" in the list and vice versa. Thanks. So far I only have this: Private Sub Workbook_Open() Worksheets("Settings").ComboBox1.Value =...
  12. B

    Return multiple values in a list based on other criteria

    I'm shooting for the moon a bit here, but thought I'd ask if this is possible anyway. In the below table, I want to make a list of values appear in column E based on the number in column B (as it's shown now with hard-coded values). For example, if there's a 2 next to QB, then QB would show up...
  13. W

    Macros code to return a list of numbers according to Specific Conditions

    4 numbers are to be picked at random from a bag containing numbers 1 to 20 For convenience purposes, said numbers are grouped as; 1 - 5 6 - 10 11- 15 16- 20 Numbers chosen in the Number Pattern (2101) means 2...
  14. J

    List of values based on criteria in two places...

    Hi there, I am currently using a tracking spreadsheet to list out titles of people who started in my organization and the days it took to hire them. The problem I am running into is based on the fact they are occasionally stored in an interim place if they have accepted an offer, but not...
  15. gmooney

    Excel Custom Lists?

    I just created a custom list in an Excel file that I am using for a Slicer and pivot table filter. I emailed the file to another person and the custom list did not transfer with the file? How can I make sure that the custom list stays in the file?
  16. U

    Inserted row above total is not included in total. Any solution would be welcomed!

    I have a worksheet with a list of properties. Every time an expense is added to the list it goes on the last row for the property, just above the total. I welcome any kind of solution either a worksheet formula or a VBA solution that would insert the new row and update the =SUBTOTAL( and =Sum(...
  17. D

    Reset Button for Drop Down Lists

    I have a workbook with multiple drop down lists. Unfortunately, all the drop downs are not using data validation. We need to have the list "reset" to the first item of each list. Is there a way to do this with just one Reset Button? Thank you
  18. S

    Count unless text is in a list

    In this scenario I am trying to track how many calls a staff member made in Jan. The catch is there are some calls that are not eligable for tracking. The ineligable call statuses are in a list. Is there a way to do this? I'm not great with excel, any help is appreciated! Count if the 'month'...
  19. K

    macro list of name ranges includes some i dont want

    I have a macro for listing all name ranges in active workbook when a certain worksheet is activated. the code is Sub Rprt() Dim nm As Name, n As Long, y As RANGE, z As Worksheet Application.ScreenUpdating = False Set z = ActiveSheet n = 8 With z .[a5:O155].ClearContents .[a7] =...
  20. T

    Stupid Scientific Category

    This whole scientific non-sense that Excel defaults to for some numbers is quite annoying. Background: I have a list of phone extensions from a PBX. The list includes the port number to which each extension is associated. The following is an example of some of the ports: 01E0205, 01E0713...

Some videos you may like

This Week's Hot Topics