choose

  1. S

    Multiple Cell Check without VBA

    Hi, I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved. I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in...
  2. M

    Do i need Vlookup or Indirect or something else?

    I have a simple workbook with two sheets. Sheet 1 contains: <tbody> NAME AGE HEIGHT WEIGHT JOHN 34 52 23 PETER 23 12 62 LUCY 45 23 86 DANIEL 23 42 34 </tbody> Sheet 2 contains a message: Choose a person I then has a dropdown/combo box (data validation list, the source being the list...
  3. J

    "Choose" function for the Best Running Time

    Hi, I am storing all of m running times on an excel sheet. I have the distance run in column A (lets say A1:100) and the time in column B (B1:100). In a separate table columns E and F have ranges of distances (0 - 10[in E1 and F1 resp.], 11 to 20 in row 2, 1 to 30 I row 3, etc). What I want is...
  4. A

    Data Validation

    Dear Excel Experts, In first row from Cell C1 to M1 there are name of persons and below 4 rows have specific numbers. I have set in column A all first row name by using data validation list criteria. I want a formula in column B. if a particular name select in cell A2 then at cell B2 shows all 4...
  5. S

    [VBA] Custom two-option user Popup

    Hi all, Hope you're having a good day. I want to create a popup for a user to choose between three options Select a file, Select a folder, Cancel I made a userform to handle this. If they choose to select the first option, I want to use Application.FileDialog(msoFileDialogFilePicker) to...
  6. D

    Responsive list / pivot - No VBA

    Hi Guys, Forgive me the thread title, but I had no idea how to call it. I'm having a table, where I have to choose Yes/No. If I choose Yes, I want this choice to be displayed in another table. It can be partially done with a pivot, but I need to press refresh each time I make any changes in my...
  7. S

    Show different worksheets with Camera Tool but the ability to edit data shown?

    Using this YouTube video as a guide https://www.youtube.com/watch?v=lCsvSdk4Tro I have created a Dashboard of sorts which has a Dropdown box and this shows data from numerous sources. The sources are mainly Pivot Tables but is there a way to actually edit whatever is being shown in the Camera...
  8. S

    Help with CHOOSE function

    CHOOSE function has syntax CHOOSE(index_num, value1, [value2], ...) I have 100s of values (text values) to deliver to CHOOSE function. Instead of typing all those values every time, I want to keep those values as defined name. I tried to define a name and handed overt to CHOOSE, but it...
  9. A

    Code link optionbutton ,compobox with textbox and cells in sheet

    hi, expert i would help finding code connect the data sheet with optionbutton , compobox and textbox in userform for explanation i have data in sheet1 in columns c,d are two prices price the column b is the brand and userform 2 optionbuttons and compobox1, textbox1 here when i choose the...
  10. danhendo888

    Cannot filter by months in Pivot Table

    https://1drv.ms/x/s!AvjBsEPEq12ngURD4J_Yxbfrn7OV?e=ln2Olm I have a sheet of data. I converted it to a table. Loaded it into Power Query, unpivoted the dates columns, and then created a pivot table. But I want to be able to choose the months in the pivot table, but I'm unable to do so. What do...
  11. sharky12345

    Prompt user if file save is cancelled

    I have a routine which prompts the user to choose a folder to save an embedded Word document as PDF; FilePath = Application.GetSaveAsFilename(InitialFileName:=File121, FileFilter:="PDF Files (*.pdf), *.pdf", Title:="Select Folder to save") It works fine, except if the user clicks cancel in...
  12. danhendo888

    Help with dynamic (?) formula for adding values

    https://1drv.ms/x/s!AvjBsEPEq12ngT4paIVYB5-Ol3Y2?e=XitD7z Hi guys, I have monthly revenue data that I want to add (YTD figure) Need a formula whose output updates based on say if I choose YTD May. Then it should add months 1 to 5 for the year. How would you approach this solution?
  13. D

    macro from drop down list

    I have 4-6 marcos that i want to be able to choose from in a drop down list.
  14. K0st4din

    Select specific worksheets and save to a new workbook

    Hello friends, I searched a lot on the internet and found countless similar solutions, but not exactly what I was looking for. I ask for your assistance. I have a workbook with 38 worksheets. I made myself a UserForm1 in which I inserted 28 worksheets with their names. These names are with...
  15. A

    My one week effort code, can you check it up ?

    Hey there :) I have been busting my A** out in the last week to generate one consolidated report from two different reports i know it may look simple but i just learned vba one week ago haha.... anyhow, first i would like to thank everyone here for their support. second, can you please...
  16. E

    force a letter to a certain time

    Hello. The tittle is wierd because I'm not sure how to call it. I have a sheet that allows me to choose night shift times for some cells. and based on the time I put there it gives me more or less night hours worked I need to know if I can make, for exemple, be able to choose the time i want...
  17. R

    Use Date Picker to Locate and Select a Cell

    Is there a way to code a DatePicker so that when you choose a date it will look in column A and select the cell that date it in? so if i choose 11/1/2019 in the date picker it will look through column A, find the date, and select the cell.
  18. A

    Counting cells

    Hello, In one column (B), users can choose between 'Essential' and 'Desirable'. In another column (C), users can choose between 1 and 5. Do you have a formula for counting the numbers of Essentials in column B and the number of 1s in column C, etc.? It's one formula I need, for doing both...
  19. A

    Subquery To Select Checks by Varying Age Requirements

    Hi all, I have a need to select all checks that fall within an age threshold determined by a client's preference. For example, one client might choose a 30 day threshold, another might choose every ninety days. I am receiving an error: "at most one record can be returned by this subquery."...
  20. MFish

    VBA Click option on a Combobox to another userform

    Hi, What I'm trying to complete is this - I have a combobox1 that has data, "1-1", "1-2", etc. and within this same user form (userform1) there is 3 different option buttons to choose from. I want to write a code that executes this... I want to show userform2 when I choose optionbutton1, no...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top