options

Hi everybody - I'm trying to replace blank cells in a set of data with 0 in order to utilize the Pivot Table functions. For some reason I cannot get this option to work. I've simply clicked on Pivot Table Options - checked the "For empty cells show:" box and entered 0. I'm stumped as to why this...

Hello everyone ! I recently created an order form in which people have dropdowns in which they can select multiple options (same options in each dropdowns). I'm hoping to have a text box open (with 3 check boxes options) when one of the option is selected in order to ask what additionnal...

Hello, I have a column with various employees names. In the column next to that I have a variety of drop down options to choose from (day, night, etc.). What I would like to do is determine the number of options that fall under each person's name. For example, Charles is listed 50 times in...

Hello, I am attempting to return a value from a range of cells, based off another range of cells. Here's an example of what I would like to do: Tab 1 A1 - Is one of ten hand-keyed in options (cancel, order, hold, etc.) B1 - Returns a date from a range of dates located on a second tab, based...

Hi Guys! Please help me with my problem about Switchboard. I created my Switchboard with the usual process of creating a simple Switchboard. I used the Default Main Switchboard and i think there is no problem with that if I use that or by creating a new one. Then I input the items on the...

Hi, my first message I have likert scales (1-5) that I created with Vba. There are groupbox in every row and include likert-scale(5 option buttons) in columns. The number is quite over 100. When you select each options, this options values writes the linked cell. I want to ask...

I have a dataset that contains in the first column the name of a company, column b contains two options that apply to that company, so each company could be in the sheet at least twice, then in column c to g contains financials that are associated with each option (column b). I need to...

Hi I need a little help on this one. I am separating (or trying to ) separate data that has come from a SharePoint list where the user can select multiple options. Everywhere I have looked has suggested using this formula =TRIM(MID(SUBSTITUTE($A1,";#",REPT(" ",99)),COLUMN(A1)*99-98,99)) as...

Dear all, I am struggling getting the following done: In column F you can choose out of a Data Validation List of 4 options. In case of selecting Option 4 I would like to show the outcome of a certain formula in the corresponding cell next to it in column G. I have set up the Data Validation...

Hi, Is there a log file available in VBA? I could put the log in the worksheet but wanted to know if there were other options. Thanks

Hello, Looking for solution to sort some data, I have 4 columns with numerical numbers from 1 to 500 with in this range i have a.b.c.d.e. next to various numbers in the last column. When i use the sort function it will sort the first 3 as normal as they are only numerical when i sort the last...

Hi there, I am currently using the following formula in a spreadsheet, however I am trying to include an IFERROR option to pick up cell Q3 if there is no match. I have tried a couple of options however they do not seem to work...

I have a user form with three options. I need to be able to select 1 of the options, two of them, or all three. i have the following code but if the first if statement is not true it does not work at all. how do i get it to allow for any selection combination at any time to work? Private Sub...

HI Everyone, I need the code for a message box that gives the person 3 options when run the message box needs to say "You have not Submited Data Yet" new line " What would you like to do? Then if possible give the options of "Cancel" "Submit & Continue" "Continue" if cancel just come...

Hello, Is there a way to password protect a form and also hide the different viewing options of the form. I only want the user to be able to see the form view not design and database view. Is this possible? Thanks!

Hi I have a column which has random dates. I inserted a filter. I click on Date Filter and I see all options, after, before, between etc. Then I see custom Filter and I see AND and OR. I just want to know an example that I need to use these 2 options. I thought everything is already covered...

Is it possible to return the values of each column visible in a filtered pivot table? I have a PT set up that holds a column of data called 'Type' which is a text string. After filtering the PT down using the PT filters I have a drop down that gives me all the options that are in the data but...

Hi there, Just wondering how I would go about creating this button? The button has two options, 1 to either Print or 2 Print to PDF. I would need this to be recorded as a macro and then assign the button. So create a button and give it 2 options but how do I do this? Any help is...

I have a list of data and i'm trying to extract info from the list using an index/match formula. This is working but only until I change one of the drop downs from the 1st option to the next and then the answer for the formula is coming back #REF . I think somehow I need to incorporate the other...

Hi all, I am trying to create two separate drop down lists on one worksheet and in the same column (N). One titled 'deliveries' the other titled 'collections' both contained in cells N2:N5000 and varying each time someone pastes in to it, I want the drop down list to look at the two options...