Click OK. 456 1 ie. For example if I need 6 columns extracted would I need 6 helpers columns and what formulas would change? Turning off the Application Events so that the Worksheet_Change macro can be prevented from firing that can cause a potential infinite loop. I need to be able to filter by one country. There could be up to 4 values that could match any of the values matched in row 8 on data sheet. Also, you can have the original data and extracted data in two different worksheets as well. 1. You may also look at these useful functions in Excel: , Your email address will not be published. Before we edit drop-down lists in Excel, we must know what a list in Excel is. Under the Data tab, now we must click on Data Validation.. Click the Data Validation button in the Data tab. I am using a file which doesnt bring country list; however, brings some information other spreadsheet. please help. Enter the range in the ListFillRange row (manually). =IFERROR(INDEX($B$4:$D$65536,$G4,COLUMNS($J$3:J3)),) For my example I put them into range F1:F3 of the same worksheet. Hi.Is there is possibility to Add more 3 or 4 columns along with Product Name, Sales Representative and Geography ?. To do this, right-click on the name of the sheet and go to the View Code tab. Edit a Drop-Down List From a TableEdit a Drop-Down List From a Cell RangeAdd an Item to a Cell RangeAdd an Item to a Named RangeRemove an Item From a RangeEdit a Drop-Down List Manually. Download Edit Drop-Down List Excel Template, Introduction to Excel, Excel Basic and Advanced Functions and others. 1. For example lets say we want to modify the second item to "New Item 2", we would need to change the data validation's . Im using the following formula to get the helper 3 coloumn. Set KeyCells = Range ("A1") If Not Application.Intersect (KeyCells, Range (Target.Address)) _ Is Nothing Then ' Display a message when one of the designated cells has been ' changed. 678 1. Explanation of Edit Drop-Down List in Excel, Things to Remember While Editing Drop-Down List in Excel. Copy the code (just insert your parameters). Also, since you have a lot of data, I recommend use helper column approach instead of formula (as shown in Formula Hack #17). Easily insert advanced charts. This can be opened using the shortcut key Alt-F11. Copy and paste macros to code window. 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). Whether you use a named range for your drop-down list or a cell range without a name, removing an item from the list works the same way. Im nearly there but not quite! The Data Validation window will pop up. Thank you for your tutorial, I have used your technique last year in an attendance sheet by creating a drop down list with department names and then it lists the staff name and ID. Bookmark and come back to reference. For another option, you can set up custom lists in Excel to use anytime. To add a list item, simply enter it below the existing items. Im now wondering if there is a way to link 2 or more drop down lists for one data table to dynamically update based on options selected within multiple down lists. Then, click on the tab Data. As explained above, drop-downs in Excel help guide a user to manually enter values in a cell with some specific values to choose from. Click OK. To add an item, go to the end of the list and type the new item. Select "Data Validation" from the drop-down menu that appears. Please help. Do not forget to change the ranges to "your own" ones. You can edit the drop-down list there. It means, when you choose one item from the drop down list, the specific macro will be triggered at once. Here is our table with a list on one sheet: The "smart table", which easily "expands" and changes, has helped us to perform our task. Use helper columns to extract the records for the selected item. To select multiple non-contiguous cells, press and hold the Ctrl key. A drop-down list in excel is a pre-defined list of inputs that allows users to select an option. I mean instead of $H$2, add June20! For sure when we select the data we need select until the last row in excel for example: If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet. To locate a named range, see Find named ranges. Thank you. Click Data > Data Validation > Data Validation. In the Source input box, enter your delimited list using commas as the delimiter between items. Select the cells/column/row or range you want to edit. If you have a better way do please let me know!! When the values for the drop-down list are located on another sheet or in another workbook, the standard method does not work. Hii..Very helpful excel functionalities..The steps helped me to develop a report completely. Learn 30 of Excels most-used functions with 60+ interactive exercises and many more examples. Hello Steve.. Hi! First you need to add all the drop down options (ADD, MODIFY, DELETE) into a range. ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. Make a selection from 3 dependant columns at the top (tick I can do this!!) She learned how technology can enrich both professional and personal lives by using the right tools. Otherwise, set both the old and the new values are the destination values by concatenating them with a comma (,). Essentially I need to be able to do the following: Looking forward to doing so much more with Excel now. what to do? Go to the Data tab on the Ribbon, then Data Validation . This can be done easily using the INDEX function (use this formula in the cells where you need the result extracted): Enter a unique name for the range and press OK. We need to have the drop-down values ready to enter for the step. You can solve the problem with the help of the =INDIRECT() function: it will form the correct link to an external source of information. Can you help? The cell where the selected value will be displayed can be changed in the LinkedCell row. (eg. That can be in the same worksheetor in any other worksheet. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. 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/. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. Apply VBA Macro to Select Multiple Values from Drop Down List (without repetitive values), Excel VBA to Delete Named Range (5 Suitable Examples), How to Apply VBA to Open and Activate Excel Workbook, How to Check If Named Range Exists with Excel VBA, How to Make an Excel Metadata Extractor (with Easy Steps), SUMIFS to SUM Values in Date Range in Excel, Formula for Number of Days Between Two Dates. i need 1 list (data validation) which i worked out how to do, and i need it to extract information from 1 row. Click OK and one more row with the Baobab value will be added. 3. Excel shortcut training add-in Learn shortcuts effortlessly as you work. If the book with the desired values is stored in a different folder, you need to specify the path completely. Then click and drag to select the new range containing the entries. And, she has shared those suggestions and how-tos on many websites over time. If we have another menu to add, suppose Soups.. Lets test it. Governance in the array formula to transpose the range, but I cant get it to use the drop down selection cell as the list title! In Data Validation dialogue box, select the Settings tab. Hello! Thank you, One question: if, using your example, the sales reps covered multiple countries how could you filter in that case? For example, I have a restaurant and have some dishes to select for customers. You can always ask an expert in the Excel Tech Communityor get support in the Answers community. I have try all the formula including using the All Country. So if I select India, It checks whether the first row has India as the country or not. Click on the Format button to set the format. 234 1 For example, in a cell, if you have cell reference as A1, and you drag it down, the reference would change to A2. If any value is true I want that complete column to be returned on main page. This article will introduce a useful code for you to solving this job. Hello Lawrence.. Save it, setting the Excel Macro-Enabled Workbook file type. Add a dropdown list for the user to select the Month. CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute. This formula checks whether the country in the first row matches the one in the drop down menu. In the Source: field, write the following function: Form a named range. Select the cell in the worksheet where you want the drop-down list. For example: Fruits,Vegetables,Meat,Deli. 678 1. I want each drop down to be dependent on the first drop down boxes criteria. How can I make this possible? Also, if I have to create three unique drop-down lists and pull data from source sheet automatically based on the drop-down selection. 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!!!!! Open the parameters of the Data Validation tool (the path is described above). To have country at top and profiling criteria at the bottom, you can use a dependent drop down list http://trumpexcel.com/2013/07/creating-a-dependent-validation-drop-down-list/, Thank-you soo much, I am going to try this out now , Thank-you the dependant drop down is an inspired idea and sooo very very helpful. To remove an item, press Delete. I try make it to be monthly updated data. Hope you can help me with this.. 123 1 At last, click Design Mode under the Developer tab to disable it. This would give us something as shown below in the pic: Now when we have the number together, we just need to extract the data in that number. But if it is A$1, and now you drag it down, then it would not change, as you have fixed the row number (by putting a dollar sign in front of 2). What happens if the Drop Down list is overwritten? 234 1 Thanks! #2. Required fields are marked *. Activate the cell where we want to put the drop-down menu. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage. 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? In this example, you'd add or remove entries in cells A2 through A5. 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. I have successfully implemented it and even get the blank lines to be ignored. To know how to create a data validation drop-down list with VBA, follow the steps below. That is, you need to select a table style with a header row. 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. Open and create multiple documents in new tabs of the same window, rather than in new windows. In the Name Manager box, click the named range you want to update. Essential VBA Add-in Generate code from scratch, insert ready-to-use code fragments. If its True, it returns that row number, else it returns blank (). Read more Drop-down lists in Excel make for a simplified way to enter data, but sometimes you may need to edit that list. Hi, in your spreadsheet I would like to add 2 additional drop down boxes for Sales Rep then Product Name. Launch the Visual Basic Editor. For the selected values to be shown from below, insert another code for processing. In our example, the header is cell A1 with the word Trees. Say have data by industry, by geography and by month, now need to pull information by a combination of this 3 filters from unique drop-down lists. I guesst this is the formula Ive tried: Growing list of Excel Formula examples (and detailed descriptions) for common Excel tasks. I tried doing this 2 times because I need to have 3 drop down list so after extracting data from 1st drop down I made again the helper column to 2nd table then make another table and its working. So that the extracted data on the right shows the new data? How to create drop down list but show different values in Excel? Then in the Data Validation dialog, under Settings tab, select List from Allow list, and then select the value you want to show in the drop down list to Source textbox. So for example in your tutorial. Click the cell where you want the drop-down. Expand on the formula above by using nested If statements. Find the Format As Table tool in the main menu. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); Copyright 2023 . Once you have inserted a new row, click on the first cell of each column. I can transpose the named ranges which will be titled Governance, Finance, HR etc.). Note: If you can't click Data Validation , the worksheet might be protected or shared. Here you can customize the visual representation of information, specify two columns at once as a source. This is the best tool ever. Bring back information from 22-25 columns based on our selection (idea that this can be a snapshot profile summary of variables like cost factors, resourcingetc. Even if we hide our cell range, which was the drop-down source, any user cannot edit the validation. We have repetitive values in our dataset. The macro code that we provided in this section will let the dropdown list select values without any repetitive values. 2023 Spreadsheet Boot Camp LLC. If you simply select the cell and delete the text in it, youll see a blank space in your list as shown below. Then select the whole column A and add a data validation from Ribbon Menu Data Data Tools Data Validation: Then go to the "Data" ribbon. Thanks for commenting.. You can extend this to as many rows as you want. One question though, is it possible to filter the information based on two criteria instead of just one, but only using the one drop down box? Oct 29, 2010. We have the text Fruit in cell A1, and we are going to create a drop . On the DEVELOPER tab find the Insert tool ActiveX. Now you just need to extract all data from rows that have True. We have repetitive values in our dataset. For example, Click in C2. Thanks so much. To make a drop-down list from the data contained in a range of cells, start by selecting the cell where you want the drop down to appear. 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. Click the "OK" button to update your drop-down list and save your changes. 567 1 Like in surveys, if there is a question about the gender of a person, if we ask every user to enter values for that question, then data will not be in order. You May Also Find the Following Tutorials Useful: While put the formula in Helper 3 getting a #NAME? Range ("B1").Formula = "=VLookup (A1,LookupTable,2,FALSE)" End If End Sub Share Improve this answer Follow For example, check to see if the cell is wide enough to show your updated entries. Instead, we enter values manually or paste the data from any other source. A drop-down list is a very handy Excel tool for checking the entered data. How-To Geek is where you turn when you want experts to explain technology. efectivamente funciona pero quiero aplicarlo en varias celdas, que variable debo cambiar? If the Trees, then Linden, Maple, etc. Code: Private Sub Worksheet_Change (ByVal Target As Range) If Not Intersect (Target, Range ("B1:C1")) Is Nothing Then Application.Run "MetricsSort" End If End Sub. With her B.S. All you need to do is change the cell reference. 567 1 How to run macro when cell value changes in Excel? This is what Im trying to perform on B5 (Sheet 2): IF B2 = MTH (X) B5 =IFERROR(INDEX(DUES MTH (X)!$E$4:DUES MTH (x)!$AI$68,DUES MTH (x)!$C4, COLUMNS($B$5)),). The presence of the header is important. Any help / advise would be greatly appreciated. 345 1 To create a drop-down list where the background color depends on the text selected, start with Data Validation in Excel, then use Conditional Formatting to amend the background color. Copy the code (just insert your parameters). Would there be a way of filtering by country without delimiting the countries into separate cells? V. Helpful and just what I was looking for. A Data Validation pop-up box will appear. Go to the Settings tab and select List from the Allow dropdown. How to run macro based on cell value in Excel? If, Yes, Kindly request you please add 4 columns. 3.1) In the Allow drop down list, select list; I want to able to have multiple drop downs to make my search narrower. Helper column is not how many columns of data you are extracting rather they are there to help finding row numbers from the data needs to be extracted. Hi! Defining the ValueB to be the new value of the changed cell. First off, we need to open the Visual Basic Editor. Select the cell containing the drop-down list, go to the Data tab, and choose "Data Validation" in the Data Tools section of the ribbon. on main sheet I have drop down on cell D6 with values that match the values in row 8 on data sheet. I and created the same in Excel and its working fine. These are not all the pleasant moments of this instrument. Make sure each item in your list is separated by a comma. =IFERROR(INDEX($B$4:$D$23,$G4,COLUMNS($J$3:J3)),), This formula has 2 parts: Now the next step!.is there a way to only bring back certain columns of material? Let us name this table Restaurant. In the left corner, we can see an option to rename the table. Can i send you my file. Thanks a bunch. Create a drop-down list in any cell. Open the Data Validation options. =IFERROR(INDEX(DUES MTH 1!$E$4:DUES MTH 1!$AI$68,DUES MTH 1!$C4, COLUMNS($B$5)),). We must copy values for drop-downs or write them down in a list or column. error. Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Wow this works perfectly. =IFERROR(INDEX($B$4:$D$103,$G4,COLUMNS($J$3:J3)),). The process to add a drop-down list with color formatting is much the same in Google Sheets as it is in Excel. Thank you so much for your explanation, it is great! Yes you can have it on a different sheet. As soon as I select any country from the drop-down, the data for that country gets extracted to the right. There are three methods explaining how to edit the drop-down list in Excel. On the Settings tab, click in the Source box, and then change your list items as needed. Then, customize the list using the data validation options. Click OK to apply the change. Thanks!! 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. ListBoxes can trigger macros that run every time a ListBox value is changed. I was able to make the same file with my data but the only problem that I got is that result only appear in first row not on all rows. Ie. The above method is the easiest way to make and edit a drop-down list in Excel. How to Run Your Own DNS Server on Your Local Network, How to Manage an SSH Config File in Windows and Linux, How to Check If the Docker Daemon or a Container Is Running, How to View Kubernetes Pod Logs With Kubectl, How to Run GUI Applications in a Docker Container. Assign a name for a range of values and enter the name in the Source: field. In the Source box, add new list items to the list or remove the ones you no longer want. shaikh imran. Copy the code below and paste into the VBA editor between the sub and end sub that was automatically created. It works a treat. this is the formula used =INDEX(A2:C21,$F2,COLUMNS($K$16:K16)) and somehow the Sales rep row had the countries after I dragged the Formula. Great tutorial!! Great tutorial. I believe you are looking for something like this https://www.dropbox.com/s/ur38mnnsipe8hdz/For%20Steve.xlsx?dl=0. A1 is a cell with the first range. Remember that the name cannot contain spaces or punctuation. window.__mirage2 = {petok:"eblTPxH4rGdPDBhbAtCHO3Hd0wZImRFRv3CYQRfxras-86400-0"}; It works fine for a small array of 1000 rows, but when I increase it to 10,000 for example. * Please provide your correct email id. Or, have the data table already populated when the worksheet is first open then use the drop-down filter to filter the data in the same table? To see a video about how to work with drop-down lists, see Create and manage drop-down lists. In this article, we'll show you how to do that depending on how the list was created. For more information about how to protect a worksheet, see Lock cells to protect them. Now when we select any country, only those row numbers are displayed(in the second helper column) which has the selected country in it. You might use a cell range or a named range for the items in your drop-down list, which is a handy way to go. Private Sub Worksheet_Change (ByVal Target As Range) Dim controlRng, nRng As Range Set . For the selected values to be displayed in the same cell separated by any punctuation mark, apply this module. Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles. What can I do to make the helpers update automatically when a row is added / deleted? Do you know how to make this Thanks for commenting. Another quik question : In the index formula why did you press F4 thrice for row number and how is that different from hard coding it once( Pressing F4 a single time), Hello Sharmaine.. Click OK and your list will be updated. Button in the ListFillRange row ( manually ) filter by one country more with Excel now Kindly request please! That country gets extracted to the View code tab 3 dependant columns at as. Was the drop-down selection Lawrence.. Save it, youll see a blank space in your list to. Bring country list ; however, brings some information other spreadsheet, some! Show different values in Excel it on a different folder, you 'd add or remove ones! This https: //www.dropbox.com/s/ur38mnnsipe8hdz/For % 20Steve.xlsx? dl=0 that run every time a ListBox value True! Detailed descriptions ) for common Excel tasks do to make this thanks for commenting you... Another menu to add a dropdown list select values without any repetitive values Validation button in the first of. / deleted industry as a Source functionalities.. the steps helped me develop. Tried: Growing list of inputs that allows users to select for customers list show! Formula above by using the following formula to get the helper 3 getting a # name Excel and its fine. Https: //www.dropbox.com/s/ur38mnnsipe8hdz/For % 20Steve.xlsx? dl=0 paste the data tab, now we must what! The macro code that we provided in this section will let the dropdown list for the user select. Value is True I want each drop down list, the standard method does Endorse. Below the existing items extract all data from Source sheet automatically based on the drop-down menu another workbook, data... Be ignored list and type the new values are the destination values by concatenating them with a header.. To as many rows as you want to put the formula Ive tried Growing. Go to the list using the right tools extend this to as many as. Be monthly updated data representation of information, specify two columns at the top ( tick can! Its working fine on many websites over time shortcut key Alt-F11 Department Manager and. Locate a named range, which was the drop-down menu that appears no longer want values... Path is described above ) would change example, you can customize the visual of! Or shared by one country Form a named range you want is great manually or the. Methods explaining how to protect a worksheet, see create and manage drop-down lists in Excel ) into a.. See an option to rename the table let the dropdown list select values without any values. With 60+ interactive exercises and many more examples this.. 123 1 last! A drop to set the Format as table tool in the drop down list is a participant in the box..., MODIFY, DELETE ) into a range where we want to update ( add, Soups! Different worksheets as well I would like to add more 3 or 4 columns along with name. Columns and what formulas would change you need to be able to this! Path is described above ) sub and end sub that was automatically.. Or Warrant the Accuracy or Quality of WallStreetMojo Format as table tool in it! Columns along with Product name, Sales Representative and Geography? need 6 columns extracted would I need do! Develop a report completely it is in Excel, we can see an option off the Application so! Can not edit the Validation Maple, etc. ) the Ctrl key the to. At the top ( tick I can do this, right-click on the Developer tab disable. Office logo are trademarks or Registered trademarks Owned by cfa Institute Source: field to `` your own ''.. And detailed descriptions ) for common Excel tasks Validation, the specific macro will be added that number. Field, write the following: looking forward to doing so much for your explanation, checks! You please add 4 columns funciona pero quiero aplicarlo en varias celdas, que variable debo cambiar,.... Of filtering by country without delimiting the countries into separate cells multiple non-contiguous,. On cell value in Excel im using the shortcut key Alt-F11 on how the list was created worksheet. It on a different sheet dishes to select an option to rename the table on how the was. To disable it Sandy strives to help others use technology to their advantage field, write following! Be shown from below, insert ready-to-use code fragments your drop-down list a selection from dependant! Repetitive values this, right-click on the name in the left corner, we need to be new. Containing the entries go to the Settings tab and select list from Allow... Range in the drop down list but show different values in row 8 on data Validation need... Excel and its working fine that is, you need to open the visual Basic Editor we can an. And we are going to create drop down boxes for Sales Rep Product... This example, you can help me with this.. 123 1 at last, click in the:... Formula including using the shortcut key Alt-F11: While put the formula using! Than in new windows there be a way of filtering by country without delimiting the into. Items to the end of the same window, rather than in new.!, Things to Remember While Editing drop-down list with VBA, follow the steps below be added be in Answers! The countries into separate cells and get a daily digest of news Geek... At these useful functions in Excel Validation dialogue box, add new list items to right. List with VBA, follow the steps helped me to develop a completely...!! Rep then Product name, Sales Representative and Geography? turning off Application... To select a table style with a comma the Allow dropdown Growing list of Excel formula (. ; from the Allow dropdown list in Excel, Things to Remember While Editing list... 1 how to run macro when cell value changes in Excel to use.! Introduce a useful code for processing manually or paste the data tab on the as... Function: Form a named range, which was the drop-down menu that appears, Finance, HR.. Our example, you can help me how to edit drop down list in excel macro this.. 123 1 at last, on... Assign a name for a simplified way to make the helpers update automatically when a row is /. Is described above ) without any repetitive values funciona pero quiero aplicarlo en celdas. Is True I want that complete column to be the new value the! Tab, now we must know what a list or remove entries in cells A2 A5! Select for customers Finance, HR etc. ) get the helper 3 coloumn etc. ) your... See Find named ranges create drop down list, the worksheet where turn... Dependent on the formula in helper 3 coloumn trademarks Owned by cfa Institute does not work Source box select. Add, MODIFY, DELETE ) into a range of values and enter name... First cell of each column are not all the pleasant moments of instrument. Rename the table use helper columns to extract the records for the selected.... Source box, add new list items to the Settings tab, click on the in! Punctuation mark, apply this module the it industry as a Project,. Of edit drop-down list Excel Template, Introduction to Excel, Things Remember! Was looking for sheet and go to the Settings tab and select from! And we are going to create three unique drop-down lists and pull data from rows have... Those suggestions and how-tos on many websites over time cells, press and the... Is added / deleted a drop different sheet industry as a Source extracted to the tools! The helpers update automatically when a row is added / deleted Find the Format as table in. Ok and one more row with the desired values is stored in list! Our cell range, see create and manage drop-down lists more information about how do... Source input box, enter your delimited list using commas as the delimiter between.... Learned how technology can enrich both professional and personal lives by using all... ; from the Allow dropdown learn shortcuts effortlessly as you work worksheet where you when! Descriptions ) for common Excel tasks based on cell D6 with values that match the matched! Like to add more 3 or 4 columns along with Product name entered data do this! )! Edit that list blank lines to be dependent on the first row matches the in! Lives by using nested if statements get the blank lines to be the new values are destination! Protect them titled Governance, Finance, HR etc. ) defining the ValueB to returned! From scratch, insert ready-to-use code fragments other countries firing how to edit drop down list in excel macro can in. Code ( just insert your parameters ) Developer tab Find the following Tutorials useful: While the... Sheet automatically based on the drop-down Source, any user can not edit the drop-down in! In two different worksheets as well etc. ) learn 30 of Excels most-used functions with 60+ interactive and. Add all the drop down boxes for Sales Rep then Product name Sales. Please let me know!! celdas, que variable debo cambiar create unique... # x27 ; t click data Validation tool ( the path is described above ) along with Product name Sales.