options

  1. mikecox39

    grayed out menu options, time formated delivers 0000

    When I rt click a column or cell and set the format for time and date and enter [4-25] I get [1/13/1900 12:00:00 AM] in the address field and [4/25/19 0:00] in the cell. First, why are the options grayed out; they seem to be working otherwise and is there a way to get the program to plug in...
  2. C

    Why doesn't Mr Excel HTML maker work? - Reply requested!

    I have downloaded the add-in, extracted the add-in to the Add-ins folder, UnBlocked it and installed it in Excel. I have a menu option called "MrExcel HTML Maker". On that ribbon is one group called "Generate HTML (Specify Options)". The options listed are: All Formulas First Cell Only First...
  3. I

    Macro to Retrieve, copy, paste and update on other worksheet

    Hi all, While I've performed simple Macro's in the past, the relative complexity of my current project has me a little stumped! I have created dependent drop-downs that display varying options of which users then score. I am wanting to paste these answers into the next worksheet, with the...
  4. D

    How to count Option button clicks on same userform?

    Hi, Please can someone help me? I have a userform called OPTIONS. I have 6 different options on the userform. What I would like is if an operator selects an option it counts the number of times that selection has been selected in a textbox on the same userform. For example: If...
  5. A

    Timeline Connection to Slicers visually indicating items with no data

    Hi there, I have a spreadsheet that connects several slicers to pivot tables and their associated charts. Along with the data slicers I have a timeline connected to all of them as well. When a slicer selects one or more field options, other surrounding slicers will visually indicate which...
  6. F

    Power Query - leaving detailed notes of steps

    Does anyone know of a way to keep notes on what each step does in Power Query? When I write VBA, I write up a detailed explanation of what each line of code does so if anyone needs to modify it they can understand the method to my madness. The closest options I can find in Power Query are...
  7. H

    Drop-down list as suggestion

    Hi, I have a cell that requires user input. I would like there to be a drop-down in that cell that would allow a user to select some potential options. However, if the options don't work for the user or they want something else, they would still be able to type in whatever they'd like without...
  8. P

    Problems with 'Fill' function, ie filling Date in Column

    Windows 10 v1809 Excel 2010 I'm struggling to simply fill a column with consecutive dates for a month, ie Fri 1 Mar 2019, for some reason. I've done this many times before but, today, this just won't work properly. I've checked with Google but the links all same the same thing, ie type date...
  9. N

    multiple sheets into one with dropdown options

    I have 8 excel sheets (basically all quote sheets that have product listed with options that can be added on listed by category. I.e. Product lists are Truck, Car, SUV - Options Categories are - Radio, Interior color, Exterior color Then each category has multiple options to chose from I...
  10. B

    Problem using Ctrl + F to find a number on a spreadsheet

    I'm using Excel 2016. I have always used Ctrl + F to find a number on a spreadsheet. Now, whenever I try to find a number on a spreadsheet (that I know is there) by using Ctrl +F, a dialog box pops up and states, "We couldn't find what you're looking for. Click Options for more ways to search."...
  11. D

    Power Query 2016 - Missing Options - Merge dropdown - Joins

    Hi Everyone, I am using Microsoft Office Professional Plus 2016 and Inoticed I am missing some features inside of Power Query. I came across some ofthe missing features while attempting to merge two tables. The merge button inthe queries button does not have the drop down feature to allow the...
  12. F

    Combining IF and SUMIFS: Only getting #NAME? error

    Looking to sum a column of values based on: - Direction of service (options are North, South, Both, based on filter value in cell) - Journey (noted by OD) (starting location and final destination) (options are All or only one, based on filter value in cell) - Start time of journey (options are...
  13. B

    searching for duplicates and replacing with the new information

    My present coding moves information completed on a UserForm to a Spreadsheet. Individuals may need to update the information submitted so if they submit another form, I require a search to happen by the PRI number and replace the old information with the new information. For example.... If the...
  14. G

    =MAX(IF(ISNUMBER Assistance

    Hi, I've been using the following formula which is working fine for my current needs :- {=MAX(IF(ISNUMBER(CB:CB),IF(A:A="Set 107",CB:CB)))} I now want to add another criteria to this function after A:A="Set 107" to B:B="Ready" I've tried various options but am not getting the correct answers...
  15. D

    slicer - how to return records that have all slicer options selected?

    Dear Experts, I am wondering if there is a way to set up a Slicer to return records ONLY if they have ALL slicer options selected? For example - I don't want to see records that have slicer options 1 OR 2 OR 3 etc. but records that have slicer options 1 AND 2 AND 3 etc. ? Case Scenario...
  16. James_Latimer

    Currency List

    Excel 2016. Hello Excellers. Here is the 'stupid question du jour'... is there any way to loop through the list of currency options using VBA? I'm referring to the options when you format a cell, click currency and then you get a long list of options (currency symbol and region). I'm wanting to...
  17. L

    Adding percentage to cell amount using a checkbox

    Hi All First time poster, and very new to excel, so please be kind. :) This may be a simple question for most of you, but as I'm relatively new to everything in excel bar basic formulas, I'm struggling. Been googling this for hours and can't find an answer (or don't know how to word in...
  18. P

    Vlookup/index match or something else?

    I'm looking for a formula that will break out all values associated with a specific reference. Below shows a single reference ID but I believe I'll be using 2 for this project. Any help is GREATLY appreciated. ******** language="JavaScript"...
  19. S

    Creating a lookup grid from delimited text

    We receive updates from our supplier in the format below showing products we have ordered by stock number and the options we have chosen against each product in a // delimited format. So the data looks something like this except there are around 50 available options and typically around a dozen...
  20. X

    Excel Dynamic Table

    I have had this issue for awhile and can't seem to fix it. When i have table set up I will occasionally enter data on the next row outside of the table. The table auto expands as it should. However, i later realize that i don't need the new data i entered and delete. In order to make sure my...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top