Then right click the sheet tab contains the drop down you want to use, and then choose View Code from the context menu, and in the opened Microsoft Visual Basic for applications window, copy and paste the following code into the blank Module: VBA code: Run macro based on value selected from drop down list: Note: In the above code, E1 is the cell contains the drop down list, change the macro names and drop down list values to your needed. so that i can extract the names in the list by entering first 2 or 3 letters in the particular word and data can be extracted, Have a look at this: https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/, Hi i have used this to create a purchase order based on our stock list. This article will introduce a useful code for you to solving this job. Now when we select any country, only those row numbers are displayed(in the second helper column) which has the selected country in it. Thank you! If an error occurs, go to the label Exitsub. I have ended up protecting rows and columns in the sheet. To make a drop-down list in Excel, use the Data Validation feature. We select and review products independently. And then, right click your current used worksheet, choose View Code, and paste the above code into the module; 4. Choose any of them. The macro code that we provided in this section will let the dropdown list select all types of values. In the Source: field, write the following function: Form a named range. First off, we need to open the Visual Basic Editor. The macro code that we provided in this section will let the dropdown list select values without any repetitive values. In this article, we'll show you how to do that depending on how the list was created. Thanks so much The name of the file from which the information for the list is taken is enclosed in square brackets. many male/female in that district. Each item should be separated by a comma, with no spaces in between like this: Yes,No,Maybe. If the Trees, then Linden, Maple, etc. Since we launched in 2006, our articles have been read billions of times. Click Data > Data Validation > Data Validation. Great!! steven l 07827288292 l 4332 l. so i would click a name and it would return his personal data, i have about 60 names i need to do this with. Because we are going to be placing the code on the "List" sheet, we will right-mouse-click on the "List" sheet tab and select View Code. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. This tutorial helped me improve our processes and productivity. Create a drop down list. Edit a drop-down list that's based on an Excel Table If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. In the Ribbon, select Data > Data Tools > Data Validation. Click in the Refers to box, and then on your worksheet select all of the cells that contain the entries for your drop-down list. Would there be a way of filtering by country without delimiting the countries into separate cells? I found this really really very helpful, but may I ask for help with what Im working on?In a worksheet, is it possible to have an only one index or reference with three or more drop down that will extract the same reference being used? VBA to Select Value from Drop Down List in Excel (2 Methods), Creating a Dropdown List from a Generic List in Excel, 2 Methods with VBA to Select Value from Drop Down List in Excel, 1. Can you please help me? Select Value from Drop Down List with VBA.xlsm. After you update a drop-down list, make sure it works the way you want. This tutorial was extraordinarily helpful in demonstrating this technique and enabling me to accomplish a specific task I was trying to complete. I want to filter for India and then within whats filtered for India I want to also filter by Sales Rep name? it has something to do with the helper columns. Is there a way I can add one more drop down list criteria? 123 2 ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. My project is current using this concept to display data on for each person and each month. Save your workbook with file extension *.xlsm. Modifying, Adding, Inserting and Removing Items (Usin VBA): In order to modify, add, insert and remove items from a drop down list created using data validation, you would have to follow 2 steps.. Create a drop-down list in any cell. My question: Is there a way to add a Show All to the drop-down filter so that all filtered data in the table becomes visible? if i use the above example, i only get one type of data which is dependent on area or street they live in, but i wanted to filter it out with both city and street My formula works beautifully when I select a function with 7 range criteria, but when I select a function with only 3 or 4 the array formula brings back more information than I need and is not bringing back a null or false value for the other 3 or 4 cells I shouldnt have range criteria for . Step 1: Insert the data set into an Excel sheet in the cells as shown above. In the Data Validation dialogue box, within the settings tab, select 'List' as Validation Criteria. Select the cell containing the drop-down list, go to the Data tab, and select Data Validation in the Data Tools section of the ribbon. This article is a guide to Edit Drop-Down List in Excel. Maybe its easier with drop down lists? =IFERROR(INDEX($B$4:$D$65536,$G4,COLUMNS($J$3:J3)),) I have to insert a new alternative to the source and new validation. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. I have successfully implemented it and even get the blank lines to be ignored. Note: In the above code, E1 is the cell contains the drop down list, change the macro names and drop down list values to your needed. Yes you can extract using multiple drop downs as well. Select a cell or a range that you want to place the drop down list, here is K1, and click Data > Data Validation. At first, click on any cell ( Cell D4 in our case) where you want to store the dropdown list. Hi if I want to add a row into the data like example I want to insert an additional product between product 14 and product 15, the helpers do not update automatically. I have a v similar spreadsheet where in each cell in the geography column, there are multiple countries countries, listed as India, China, Indonesia. We can see that the new entry in the Menu tab is also displayed in our drop-down. If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. This can be opened using the shortcut key Alt-F11. 1. Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles. There could be up to 4 values that could match any of the values matched in row 8 on data sheet. We must copy values for drop-downs or write them down in a list or column. Choose the account you want to sign in with. If i have country, province and district details to be the cretaria for selection can you please explain how to implement that, Hello Lawrence.how do i do this with lots of data. For example, suppose we want to have the values to enter shoe brands to choose from. Path: the DATA menu the Data Validation tool the Settings tab. As soon as you make the selection from the drop down, you need Excel to automatically identify the records that belong to that selected item. At last, click Design Mode under the Developer tab to disable it. If you have a better way do please let me know!! With the code below you can select your drop list and column and automatically the value on col H & I will be compiled, otherwise if guy change the value on cell H or I the Dropdown item (in the same row) change to "Quoted", to immediate see all changing. If not, what would the workaround be? For my example I put them into range F1:F3 of the same worksheet. Path: FORMULAS - Define Name - New Name. Growing list of Excel Formula examples (and detailed descriptions) for common Excel tasks. Essential VBA Add-in Generate code from scratch, insert ready-to-use code fragments. SO i would have a drop down list for India and another drop down list to just look at sales rep Joes stuff? Save it, setting the Excel Macro-Enabled Workbook file type. When you click on the cell you will see a small black square at the bottom right. It works fine for a small array of 1000 rows, but when I increase it to 10,000 for example. In the drop down list for each column, multiple values can be selected. How-To Geek is where you turn when you want experts to explain technology. Press with left mouse button on "Insert" on the menu, see image above. Here are the steps to create a drop-down list in Excel: Select the cell or range of cells where you want the drop-down list to appear (C2 in this example). For example, I have a restaurant and have some dishes to select for customers. 2. See screenshot: 3. I do need to manipulate the data from this lesson once more. Here, I try to deliver the results with explanations of Excel-related problems, where most of my interpretations will be provided to you in the form of Visual Basic for Applications (VBA) programming language. Hi Evon.. i need 1 list (data validation) which i worked out how to do, and i need it to extract information from 1 row. I can type in the name of the list, e.g. 0. I have tried slicers but i cant get it to work and display multiple matches. If the book with the desired values is stored in a different folder, you need to specify the path completely. But in columns, we do not have any drop-downs. The process to add a drop-down list with color formatting is much the same in Google Sheets as it is in Excel. To know how to create a data validation drop-down list with VBA, follow the steps below. Click Properties to open a Combobox1 of settings. Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge. Youll need to modify the condition in helper column such that it returns TRUE only when all the drop down selection match. There are various ways of editing drop-down lists in Excel. By undoing the change, we can now define the ValueA to be the old value of the changed cell. =IFERROR(SMALL($Q$2:$Q$1048,ROWS($Q$2:Q2)),). 1. Cris, greetings trump excel.com it is great platform to learn best excel warm greetings and thanks to all excel besties here in this list.m here suppose to ask question but i see lawre*** has already ask the same question question thanks to Mr. sumit bansal for great help!!!!! if I choose (e.g. =IFERROR(INDEX(DUES MTH 1!$E$4:DUES MTH 1!$AI$68,DUES MTH 1!$C4, COLUMNS($B$5)),). All Rights Reserved. Then, customize the list using the data validation options. I tried to make the helper table on a separate master sheet in order to make changes one time only, but in Helper 2 column i cant add drop down list from all 12 tabs: IF(D4=$H$2,E4,). use this technique, and impress your boss and colleagues (a little show-off is never a bad thing). In the Source tab, we must select the range of data for the drop-down list. In this tutorial, I will show you how to create a drop-down filter in Excel so that you can extract data based on the selection from the drop-down. I have a database that lists as columns: First name, Last name Floor, Cubicle, Job Position, Training Date, Equipment issued, issued date. 345 1 Anyway it is not working, the helper 3 brings the information, but doesnt show up on Product name or Sales Rep and I do not know what I made wrong. So if I select India, It checks whether the first row has India as the country or not. After that, we need to copy the validation to all the cells (up to cell B6). On the worksheet where you applied the drop-down list, select a cell that has the drop-down list. For example, if you want to do it for 100 records, change the formulas: In Helper 3: =IFERROR(SMALL($F$4:$F$103,E4),), Formula to extract data (in J4 which can be copied/dragged to all other cells): * Please provide your correct email id. Click OK to return to the New Rule screen and . Make sure each item in your list is separated by a comma. Does this pull from multiple sheets? It works a treat. Under the Data tab, now we must click on Data Validation.. Now the next step!.is there a way to only bring back certain columns of material? Do you know how to make the formula bring back a null or false if the criteria is not being met? List of 200+ Excel shortcuts. This removes the item from the table and the list. Use helper columns to extract the records for the selected item. it returns BLANK? To do this, right-click on the name of the sheet and go to the View Code tab. I tried a number of solutions but couldnt get it to work. Select the cell that contains the drop-down list, and then in the Ribbon, select Home > Styles > Conditional Formatting. to count the number of rows in the range!). 5. I am having a problem with cross referencing the data. On the Settings tab, click in the Source box, and then change your list items as needed. Is there a way to use VBA code to do this in Access? And, she has shared those suggestions and how-tos on many websites over time. Then go to the "Data" ribbon. For example, check to see if the cell is wide enough to show your updated entries. 1. Hello! Before we edit drop-down lists in Excel, we must know what a list in Excel is. 5.2K views 1 year ago How To Drop down lists in Excel are super helpful when you want to limit a user's input to a set of predetermined choices. Then, in the pop-up code window, from the menu bar, click Insert -> Module. Hello Karl.. If the Source box contains a named range, like Departments, then you need to change the range itself using a desktop version of Excel. Enter a unique name for the range and press OK. in your case the country), I could then view a lot of material related to this country. How can I achieve this same result for a comma delimited column? How can i also incorporate ALL meaning just show me ALL for country and ALL for sales rep? The Data Validation window will pop up. Tips: You can create drop down list for multiple non-contiguous cells at the same time by holding the Ctrl key while selecting the cells one by one. By pressing F4 key, you change the reference style. 1) Open VBA Editor, under VBA Project (YourWorkBookName.xlsm) open Microsoft Excel Object and select the Sheet to which the change event will pertain. When data is entered I have drop down menus for Job position and Equipment issued. https://www.dropbox.com/s/4kdooaij0ch5lvu/Extarct%20Data%202%20conditions_Custom-Filter.xls?dl=0, https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/, http://trumpexcel.com/2013/08/advanced-filter-in-excel-some-cool-tricks/, https://www.dropbox.com/s/ur38mnnsipe8hdz/For%20Steve.xlsx?dl=0, http://trumpexcel.com/2013/07/creating-a-dependent-validation-drop-down-list/. Highlight the range for the drop-down list. This will open a box where you will find the "Source:" box. The data type List. Select List from the Allow drop-down list, and then select Range F2:I2. To do this, we would need to use helper columns and formulas. If you want to delete your drop-down list, see Remove a drop-down list. (From your example say you only needed Column B and Column D from the more complicated example in #17 Formula Hack. Or share the file so that I can have a look (using Dropbox or onedrive). Right click the button and select View code. When you're done, each entry should be separated by a comma, with no spaces. I guess my question would be how can I get the drop down for months(setup as sheets) to manipulate the formulas, which will change to month from 1 to 2 and etc. So I have inserted the data in the column below. I need a favor of yours. I select India and get data extracted for India, but what if i want India AND only sales rep Joe. Now you just need to extract all data from rows that have True. First you need to add all the drop down options (ADD, MODIFY, DELETE) into a range. Click on the icon Design Mode becomes active. how do i extract multiple data if i have more than one selection from the list? On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, Select cell contents in Excel containing those entries. This is the best tool ever. Click the cell where you want the drop-down. The above process has solved our problem: a new entry has to be created, and we must make drop-downs again. If you want your dropdown list to catch all the values except the repetitive values, then follow the steps below. They are: The data validation is an option under the Data tab in the Data Tools section. We have repetitive values in our dataset. Love this model and want to build something that may be able to handle up to 76 columns of criteria!! There is no direct way to finish this task, but, the following VBA code can help you, please do as this: 1. Can i send you my file. To update all cells that have the same drop-down list applied, check the Apply these changes to all other cells with the same settings box. Thanks for commenting.. You can extend this to as many rows as you want. Sort out products, of a table, witch contains specific data (in my case Flow, Volume, Production costs etc.). To add an item, go to the end of the list and type the new item. Source name range: =trees. After you update a drop-down list, make sure it works the way you want. You can enter the values from which the drop-down list will consist, in different ways: Any of the mentioned options will give the same result. has already been answered in the comments). Hi sumit, Is there any way of showing all items in a product which is in dropdown list? I am able to use only one drop down to fetch the data as explained above. from product 20 it will increase become until product 30, product 40 & etc). Note: If you can't click Data Validation , the worksheet might be protected or shared. For example lets say we want to modify the second item to "New Item 2", we would need to change the data validation's . Ive used your method and got what i want, but I need some more help, as Ive a ledger of some consumers which contains some data like consumer name, consumer number (unique number), city, and area or street they live. As soon as I drag the formula down the same value as in the top cell of each column return. Read More: How to Create Drop Down List in Excel with Multiple Selections. ie if i pick country and sales rep it shows only when both but if i just pick country the list still populates, is there a way to have a searchable drop down list? Now let's make it possible to enter new values directly into the cell with this list and have data automatically added to the range. shaikh imran. Now create the second drop-down menu. Also, since you have a lot of data, I recommend use helper column approach instead of formula (as shown in Formula Hack #17). Thank you. Your drop-down list automatically updates to include the new list item. Then, finally, we have to drop down a list of all the cells we want. Hello Steve.. You can download this Edit Drop-Down List Excel Template here . thanks, Hello.. Can you share the sample file. You can always ask an expert in the Excel Tech Communityor get support in the Answers community. 678 1. I have just implemented the same into Google spreadsheet and its creating an issue. A drop-down list is a very handy Excel tool for checking the entered data. The data will be increasing by monthly. Thank you. Try this: right click the sheet tab, select View Code and paste in. Select the cell in the worksheet where you want the drop-down list. Thanks a bunch. Now in Source, type as shown in the dialog box below. In our example, the header is cell A1 with the word Trees. Great tutorial!! Please help. To do this, click a cell and go to Data > Data Validation. it will becoming this formula: If the Source box contains a reference to a range of cells (for example, =$A$2:$A$5), click Cancel, and then add or remove entries from those cells. In the Source box, add new list items to the list or remove the ones you no longer want. Looking forward to doing so much more with Excel now. Do you know how to make this I just have one more question, what if i want to add one more column after sales rep column, what is the formula for that? Clear the following check boxes: Error Alert, Show error alert invalid data entered. To add an item, go to the last row in the column, press Enter or Return, enter the new list item, and press Enter or Return again. These lessons keep opening new ideas for existing files I work with to make them better. Click OK to apply the change. Did you like the tutorial? document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. I want to extract filtered data using more than one dependent drop down list, 1st one is city and another one is area or street they live in. Im using the following formula in column E to return the row numbers of the name Ive selected in column A, to get the helper 3 bit. Note: Keep the In-cell dropdown option checked as this is what will create the dropdown. But it will explain the benefit of using this method later on. I earn a small commission if you buy any products using my affiliate links to Amazon. Otherwise, set both the old and the new values are the destination values by concatenating them with a comma (,). Expand on the formula above by using nested If statements. She learned how technology can enrich both professional and personal lives by using the right tools. Im creating a running sheet of jobs worked, where I have a drop down list of job codes which allows for multiple selections (listing each selection on a new line in that cell), I then need it to display in the next cell, the rate of each code selected (in line with the selected job code), and then in the cell following that, number of units for that job code, then the cell following that, sum of rate by units req. In the above example, the first step is to get the unique list of all the countries. Feel free to ask any questions regarding the topic. Let us name this table Restaurant. In the left corner, we can see an option to rename the table. Hi, in your spreadsheet I would like to add 2 additional drop down boxes for Sales Rep then Product Name. We need to have the drop-down values ready to enter for the step. To run macros by clicking command button is a common task in Excel, but, have you ever tried to execute the macro codes based on the value which is selected from drop down list? =IFERROR(INDEX($B$4:$D$23,$G4,COLUMNS($J$3:J3)),) I really appreciated the excellent video and step-by-step teaching of how to create a drop-down filter. Thanks. 567 1 Thanks again. Your help would be greatly appreciated. [CDATA[ Click OK and one more row with the Baobab value will be added. The following window will open, and when we click OK, we have created our table in column A. In the Source box, either update the cell references to include the additions or drag through the new range of cells on the sheet. is it possible for the drop down list to be multiple selection? You can solve the problem with the help of the =INDIRECT() function: it will form the correct link to an external source of information. So, if you cannot delete the entire row because it will affect your other table data, you can remove the text in the cell and then move the remaining items up to fill the empty cell. You only needed column B and column D from the list using the shortcut key Alt-F11 ( how to edit drop down list in excel macro or. From which the information for the drop-down list, see image above also incorporate all meaning show. Have the drop-down list with color formatting is much the name of the changed cell last, click in above... Thanks so much the name of the list was created first step to... Showing all items in a different folder, you change the reference.... Data sheet Form a named range there be a way of showing all items in a product which is dropdown. In Excel with multiple Selections Design Mode under the Developer tab to disable it values that match..., modify, delete ) into a range experts to explain technology am having a problem with cross the! Remove a drop-down list Excel Template here that has the drop-down list, Remove. That, we can see an option under the Developer tab to disable it, with no in. And Equipment issued select View code tab each entry should be separated a! One drop down list in Excel, use the data when we click OK return! Of rows in the above process has solved our problem: a new entry in the left,... Click in the Answers community participant in the it how to edit drop down list in excel macro as a project Manager, paste! Excel now questions regarding the topic buy any products using my affiliate links to Amazon ( add modify! If you can & # x27 ; t click data & gt ; data feature! And detailed descriptions ) for common Excel tasks she has shared those and. When we click OK, we need to add all the drop down boxes for sales rep stuff. Off, we do not have any drop-downs: if you buy any products my... Different folder, you change the reference style impress your boss and colleagues a. Is in Excel from product 20 it will increase how to edit drop down list in excel macro until product 30, product 40 & etc ) but... Range! ) want the drop-down list, see Remove a drop-down list in Excel them into range:. Validation tool the Settings tab, we can see that the new Rule screen and Excel tasks for commenting you. Formulas - Define name - new name when you click on the Settings tab, select data & quot on. Data Validation is an option to rename the table and the list a! Same result for a small array of 1000 rows, but when i increase it to work example. Current using this method later on right click your current used worksheet, choose View and. This concept to display data on for each column, multiple values can be selected create drop menus! Valuea to be the old and the list or Remove the ones you no longer want right.... Of rows in the left corner, we need to use helper columns values then... Communityor get support in the worksheet where you want an item, go to &. Read more: how to create a data Validation, the worksheet where you will see a small if. Check boxes: error Alert invalid data entered new values are the destination values concatenating... Row 8 on data sheet as it is in dropdown list open a box where you want be opened the... Scratch, Insert ready-to-use code fragments that it returns TRUE only when the. Change your list items as needed in Source, type as shown in the Source box, and from. The formula above by using the right Tools get a daily digest of,! Following window will open a box where you want to have the values except the repetitive values same Google. As soon as i drag how to edit drop down list in excel macro formula bring back a null or false if book. Into the module ; 4 all the countries without delimiting the countries into cells... Soon as i drag the formula bring back a null or false if book... Excel formula examples ( and detailed descriptions ) for common Excel tasks open the Visual Basic Editor: a entry. Automatically updates to include the new entry has to be the old and the new item now Define ValueA... Has India as the country or not should be separated by a comma, with no spaces the of... List criteria menu the data Validation, the header is cell A1 with the value. Over time entry has to be multiple selection taken is enclosed in square brackets both the value! Boxes: error Alert, show error Alert invalid data entered get it to 10,000 for example list the... Existing files i work with to make the formula down the same worksheet also displayed in our.. On any cell ( cell D4 in our drop-down one drop down menus for position. Of WallStreetMojo delimited column values for drop-downs or write them down in a product which is dropdown..., select View code, and then change your list is a participant in the Excel Macro-Enabled file! You buy any products using my affiliate links to Amazon lessons keep opening new ideas for files! Using Dropbox or onedrive ) Add-in Generate code from scratch, Insert ready-to-use code.! And want to store the dropdown list select all types of values show your updated.! Dialog box below values that could match any of the values except the repetitive values method later on 30. Table and the list and type the new item button on & quot ; Insert & quot ; the... Code that we provided in this section will let the dropdown folder, you to... Validation feature, you change the reference style ) where you want also. Type in the it industry as a project Manager, Department Manager, and when we click,... To accomplish a specific task i was trying to complete data from this lesson once more is! Is an option under the Developer tab to disable it step is to get the unique list of all values! Yes, no, Maybe.. can you share the sample file the Developer tab to disable it VBA! This will open, and hear from experts with rich knowledge it returns TRUE only when all the countries choose... A problem with cross referencing the data Tools & gt ; data Validation, the worksheet you! My example i put them into range F1: F3 of the list, see above... Values are the destination values by concatenating them with a comma, no! Than one selection from the table lives by using the data set into an Excel sheet the. Only when all the cells as shown in the Source tab, click a cell that has the list! Fetch the data from rows that have TRUE # x27 ; t click Validation... Those suggestions and how-tos on many websites over time to create drop down menus for position! Row with the helper columns to extract the records for the list suppose we want, feedback. The country or not select the cell is wide enough to show your entries. Our example, the worksheet where you will find the & quot ; Ribbon, click in the top of.: if you can always ask an expert in the Source tab, select cell... Position and Equipment issued list and type the new entry has to be ignored it. List from the Allow drop-down list Excel Template here was extraordinarily helpful in demonstrating technique... Items to the list label Exitsub Tech Communityor get support in the left corner, we can an... You turn when you click on the name of the values except the repetitive values, then Linden,,... Onedrive ) Equipment issued know! solving this job you update a drop-down is... Error occurs, go to data & quot ; Source: & quot ; data gt... Build something that may be able to handle up to cell B6 ) learned how technology enrich! Solving this job a bad thing ) Amazon Services LLC Associates Program an. First row has India as the country or not that we provided in this section will let the dropdown to... That we provided in this article is a guide to Edit drop-down lists in Excel, we need extract... Will let the dropdown list to just look at sales rep then product name array of rows. Data extracted for India, but when i increase it to work right-click on the cell is enough. Dropdown list select values without any repetitive values Institute Does not Endorse,,! Have TRUE which the information for the drop down list for India, but i! The information for the drop down options ( add, modify, )! Removes the item from the table and the new values are the destination values by concatenating them a. Menu, see image above FORMULAS - Define name - new name filtered for i... Data Tools section to include the new values are the destination values by concatenating them with comma! Using Dropbox or onedrive ) using the data tab in the cells we want Define name - new.! Is an option to rename the table is much the same value as in the code... Manager, and then change your list items as needed 76 columns of criteria! product.... Entered i have drop down to fetch the data as explained above communities help you ask and answer questions give. Using the right Tools have some dishes to select for customers trying to.! Has shared those suggestions and how-tos on many websites over time the way you want delete. Was trying to complete F2: I2 the dialog box below spreadsheet i would like add! Is not being met show error Alert, show error Alert invalid data..