choose

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...

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...

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.

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...

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."...

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...

Hello Using Excel 2010 I have these two pieces of code below that put 2 fields into the page area of a pivot table. I want to choose 2 out of 40 items in OrderID I want to choose 1 out of 20 items in CustomerID Is this possible without having to write true vs false code for each item in VBA...

Hello Using Excel 2010 I have these two pieces of code below that put 2 fields into the page area of a pivot table. I want to choose 2 out of 40 items in OrderID I want to choose 1 out of 20 items in CustomerID Is this possible without having to write true vs false code for each item in VBA...

I have a file that generates several worksheets which need to be archived daily. In order to save space, in the past I wrote a macro that would save these sheets as an .xps file. However, our IT department made the decision to upgrade to Windows 10, which does not support .xps files without...

Hi. I have a data set which shows daily data for each variable. I have attached an example. I want to present the daily data in a column graph still, but have a dropdown list so i can choose between the months. If i have 3 different graphs, apples, pears, bananas i want 1 dropdown list to be...

i'm trying to learn a few new reports at work. one of the things i need to do is based on a pivot table. i've been able to create the data just fine but i'd really like to make it look like the previous person who did this. i can't seem to find a way to see all the formats applied to a pivot...

I recently started using the Insert Timeline function for Pivot tables. However, generally I just want to choose today's date as my filter for the pivot table. Thus, the Insert Timeline is a bit cumbersome since first I have to choose it, then choose date, then month, then actual day. Is there a...

Hi All I need help with a code that i want to apply to my Button that does as such. Choose a pic from desktop, and insert it into specified Cell(Merged). The pic should then be centered in the cell, and enlarged/shrank to fit, while maintaining it's aspect ratio. Appreciate any help that you...

I'm running an NFL knockout pool with 750+ people and have a sheet prepared where each player has a drop down menu to choose a team every week to win and it is already validated to where they can only choose a team one time all year. I need to lock certain cells after a certain time and date...

Hi, Dropdownmenu: car1, car2, car3, car4, car5 (selected now Car1). <tbody> A B C D E Test 520000 20-02-2018 580000 60000 (formula): D1-B1 Test2 Test3 320000 25-02-2018 325000 5000 (formula) D3-B1 Test4 test4 </tbody> What I want: This values are...

Dear Experts I am using a choose Formula as follows: CHOOSE((VALUE(F2733)>0)+(VALUE(F2733) > 50)+(VALUE(F2733)>145)+(VALUE(F2733)>500)+(VALUE(F2733)>750)+(VALUE(F2733)>1000),0.65,0.6,0.55,0.5,0.45,0.4) At the end of formula I have few fixed factors which i want to name as Set A, Set B, Set C...

Good day all, I was wondering if it is possible to create a list to choose from in a pop up box references another sheet. For example... this is my current script below and it basically copy's another sheet from a closed workbook in my drive and renames in based on a certain cell range. What...

I have cell J11 with a drop down list which are 1,2,3,4. I need that: 1. When I choose 1, in cell c16 appears cell 'Tank 1'!E9 2. When I choose 2, in cell c16 appears cell 'Tank 2'!E9 3. When I choose 3, in cell c16 appears cell 'Tank 3'!E9 4. When I choose 4, in cell c16 appears cell 'Tank...

I have cell J11 with a drop down list which are 1,2,3,4. I need that: 1. When I choose 1, in cell c16 appears cell 'Tank 1'!E9 2. When I choose 2, in cell c16 appears cell 'Tank 2'!E9 3. When I choose 3, in cell c16 appears cell 'Tank 3'!E9 4. When I choose 4, in cell c16 appears cell 'Tank...

Hi, I have cell C12 with a drop down list which are 1 & 2,3 & 4,5 & 6. I need that: 1. When I choose 1 & 2 from the drop down, cell E17 appears as METER 1 and cell H17 appears as METER 2. 2. When I choose 3 & 4 from the drop down, cell E17 appears as METER 3 and cell H17 appears as METER 4. 3...