Add Calendar As Dropdown Box For Multiple Cells? Oct 7, 2013 I need to add a calendar in multiple cells.
MS Excel 2011 for Mac: Create a superscript value in a cell This Excel tutorial explains how to create a superscript value in a cell in Excel 2011 for Mac (with screenshots and step-by-step instructions). Excel: How to add drop-down menus and practical use of the vlookup function in a simple table - Duration: 11:35. Drlindadavis 21,925 views.
I have followed the following steps: Developer, Insert, More Controls, Microsoft Date and Time Picker Control 6.0 (SP4) and dragged the box wherever in the sheet. However I need this selection to be reapeated for an entire row.
Ie I need the user to be able to select a date from a calendar for all the cells with the same column (Cloumn A). Similar Messages:. ADVERTISEMENT Jul 4, 2014 I'm trying to write a code to say, pop a calendar if clicked on anyone of the following cells: Sheet: 'Friday' Cell Range: D3 to D999, F3 to F999, H3 to H999 I'm hoping this function will not affect me from using the Sort (by date) later on. Jul 15, 2013 I have designed a live calendar and am trying to highlight selected dates from a column in the calendar. I am able to select single cell in the column and highlight the date in the calendar, But am unable to select multiple dates in the column and highlight multiple dates in the calendar using conditional formatting. Eg: calender dates are from B5:H9 and multiple dates are in column J10:J13 J column - J10 7/10/2013 J11 7/20/2013 j14 7/29/2013 Jul 6, 2012 Using excel 2010, how do you insert a drop down calendar? Will this be able to display the date and then can I add a nuber to it and the result be a date Dec 5, 2013 How to insert a Calendar Dropdown for Mac Excel 2011?
Also, do I have to readjust this (for lack-of-a-better-word) 'add-in' everytime the calendar year changes? This will be used for a payroll template.
Apr 16, 2013 I select the date from drop down calendar in excel and linked with one cell. When i use the date in vlookup formula it does not work due to linked cell date format. Apr 13, 2013 I want a drop down calender to choose date from and found that i can use More Controls 'microsoft Date and Time Picker 6.0 (SP4)' for excel 2007 but it doesn't work with other excel and shows a 'x' not recognised in some other machines. May 2, 2014 I am currently using a pop up calendar in Excel 2010 that with CTL+SHIFT+B that a calendar pops up, you select your date, and then the calendar closes.
What I now need is to write a code or formula or something that when I click in any cell in column F lets say that the calendar opens automatically in that cell and then still close automatically after the date selection is made. Apr 1, 2014 I've made a drop down list and when I select multiple cells and choose from the drop down list, it only fills one. Here's pictures: So in that first picture, I've selected multiple cells. But when I drop down the menu and click my selection, this happens: Why is it that all the cells I've selected does not fill with the option that I chose from the drop down.
I highly doubt that I have to manually click all the ones I want to fill with what I choose from the drop down list. Sep 20, 2013 I am currently trying to make a digital time card for my place of employment. I has an odd set up and odd date ranges. The pay period starts on the 21st of each month and ends on the 20th of the next month. The time cards have 5 columns for each week starting on Mondays going to Sunday (also weird its not Saturday to Sunday) What I was hoping to accomplish was being able to select the starting month of your choice for pay period and have multiple cells update the week date range. Date Date Date Date Date.Here would be the drop down month select. Sept 21 - Sept 22 Sept 23 - Sept 29 Sept 30 - Oct 6 Oct 7 - Oct 13 Oct 14 -Oct 20 Jul 8, 2014 We have a workbook that was used to book desks on the floor we had in our office.
The work book has a calendar that was used to book desks in advance. Recently we acquired two other floors and have several more desks available, so we are looking at adding two more userforns to the workbook to book desks on the other two floors. The code used within the calendar to select the userform to book the desks is the following: Code. How could/would this code be adapted now that there are two other userforms for 'firstfloor' and 'secondfloor' using the above code the calendar only works with the groundfloor userform. If possible can the code be adapted so teh calendar works with all 3 userforms for the groundfllor, firstfloor and secondfloor? Jan 8, 2010 I have a program where I can update the calibration due date of an item.
I have attached a cut down version of my program showing the relevant areas. There is usually password protection on the worksheet so it can only be edited via the form (the vba coding removes the password protection before editing, then re-enables the password protection after editing). The 'Update Calibration' button is usually on a 'Menu' sheet. Once the form is opened a serial number is typed in the textbox.
The calendar button is then clicked, which brings up another form with the calendar on. The due date is selected on the calendar. When 'OK' is clicked, the date label caption is then changed to the selected calendar date.
When 'Submit' is clicked, the spreadsheet will search for the Serial Number, once found, the label caption (being the date selected) will be entered into the cell to the right of the serial. If the day selected on the calendar is greater than 12 the date is entered correctly onto the sheet. Example: calendar date selected =. Shown on sheet as. However, if the day selected on the calendar is 12 or less, the date is for some reason entered incorrectly onto the sheet.
Example: calendar date selected =. Shown on sheet as???? What is going on here? How come the day and month are swapped around if the day is less than 12????
Dec 24, 2009 Using Excel 2007 Calendar Control: I want to select a date of choice from a calendar in a field within an Excel spreadsheet. I do not know how to do userforms and so that is why I wonder if I can add this in just a spreadsheet.
This is how far I have gotten so far: After doing the following, I have a static calendar setting in my spreadsheet like a text box showing the current date. Developer Insert More Controls Calendar Control 12.0 May 22, 2014 Basically, I run a DJ Management company, arranging bookings for 6 artists.
What I'm trying to do, is have data be auto populated from the Master sheet, into separate sheets. The aim, is to create 1 master with ALL the dates for the month in, and the each of the separate sheets to only populate data relating to that artist. Artist Event Location Fee Date Tony Tomorrowland Boom, Belgium 5,000 01/05 code.
Now, I need to send the artists their individual schedules for the month, but I do not want to copy and paste individual rows to their new sheets as this is a pain. I know i can sort by artist and copy it easier, but really i just want to put in the info once and not multiple times. So the master is sheet 1, on sheets 2,3,4,5,6,7 (each one assigned to a particular artist) i need the artists gigs for that month. May 2, 2006 how to multiple dates can be selected using the calendar control object? I haven't actually explored this for very long Jun 11, 2007 Have a slick way to have multiple textboxes on a userform updatable by a single calendar control located on it's own userform.
Basically, i have a userform with multiple textboxes. A double click brings up another userform with a calendar control. How do you idenitfy which textbox called up the calendar? Jul 4, 2014 Attached is what I use as a Calendar Macro and it works great for single active cell use.
I have a column for 'Notes' and I can only use 1 cell per item so every time I have an update about a specific item I go the to notes section and put a date and leave few spaces then type in whatever the notes are. Currently I'm doing it manually and I tried to use my macro on the Notes column and what it does is to remove everything in the cell and replace it with whatever date I choose in the calendar. Find a way to use my current Calendar Macro to add a date in the cell instead replacing everything in the cell with a date.
Aug 13, 2014 I have a worksheet that has about 20 columns and 60 rows, but only need the data from 5 of the columns to link with outlook calendar. I want to be able to enter the date of completion of a task in the excel spreadsheet and have an reminder entered into outlook calendar a year later. I would like the Subject of the appointment to be the EMPLOYEE NAME and the Location of the appointment to be the TASK (what the employee has to renew) these would be the column headers.
The duration can be ALL DAY for all appointments. A reminder would be fantastic! The only other fear I have is each time I run the macro/VBA it will recreate duplicate appointments. And I don't know if this is possible but one of the tasks (column) for renewal, ie: drug test, calls for an employee to be randomly selected every quarter. This will cause the employee to have a new annual renewal date in outlook but will outlook still retain the original annual renewal appointment date? I am sure we can live with this, but just a thought if there is a possibility of removing the original appointment it would be amazing.
I have attached example of worksheet. The yellow highlighted column headers contain the information I need renewal appointments created for. Apr 29, 2009 I would like to have 4 calendar controls in a worksheet, but even with only two controls I am receiving a Compile Error - Ambiguous name detected: WorksheetBeforeDoubleClick Mar 7, 2009 I am using a great pop up calendar without ActiveX made by a guy called Phil Johnson. When you click a specified cell the calendar appears. The only problem is that the calendar doesn't default to today's date when it opens.
I have the original file Calendar source code if anyone needs it. Jan 10, 2006 I have a spreadsheet in which there is a calendar. On this calendar are cells for the days. In these cells for the days we use colors for Vacation (Purple), Holiday (Pink), Unpaid Absences(Green) and Late days(Yellow). At the top of the page I want a cell that tells me the number of Purples are in a range (B10:X66) and how many pinks, greens and yellows there are. Is there a way to use the 'Count' to count colors in a range?
Oct 8, 2006 Is it possible to use one (1) calendar control to add different dates to different cells? Aug 4, 2006 User selects a date from a pop up calendar. The date and user ID is entered into the active cell of the active sheet.
I would like at the same time to have it enter the value of just the date (without the user ID) to cell A1 on the sheet labeled final. Also, while I'm on the topic, I have another workbook where I would like to do the exact same thing with the exception that the user will only be allowed to select a date equal to today or up to 60 days from today? Mar 4, 2009 I have VBA code below. Currently the code allows me in column 'N' to choose more than one item in a dropdown menu. I am trying to find a way to make column K and M do the same thing. I have tried a number of ways but to no avail. May 1, 2007 writing the correct command to auto popup a calendar when a user doubleclicks in any cell in a range of cells.
I have the code for individual cells but would like to apply to a very large range of cells and do not know what the correct command is. Private Sub WorksheetBeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Select Case Target.Address Case '$C$160', '$C$161', '$C$162', '$C$163' Cancel = True Call OpenCalendar End Select End Sub Mar 9, 2013 I have a 'diet diary' that I have built in excel that has many of the common meals I eat and details calories, carbohydrates, fats, etc and I use it to keep track of what I have eaten in the day. However, one of the features is that on the front sheet I have lots of drop down menus that I select the different things (example, milk, banana, spaghetti bolognese) which in that puts in the nutritional info. However, each day I have different numbers of items to put in so I have to change the slots that no longer have an item in back to the default value so that it doesn't add calories.
What would be ideal is if I could highlight a bunch of boxes at once and then make them all select the 'no-item' option in the drop down box simultaneously rather than selecting them all individually. May 28, 2013 I am trying to make a single drop-down list which contains values from two columns.
I should give you the example immediately: NAME SURNAME (these are two columns) Jon Alfa Karl Beta Lilly Wolf And the drop-down list should look like this: DROP-DOWN Jon Alfa Karl Beta Lilly Wolf I have already tried to solve my problem with data validation but with no success. Sep 17, 2013 I am trying to create an excel spreadsheet that calculates nutrition based on a dropdown menu. The values would change depending on the formula selected.
How to I pull the data from sheet 1 and bring it in sheet 2 in order to calculate protein, carbohydrates and fat content. I have attached a copy of the excel spread sheet. Dec 19, 2013 I am trying to create a simple order entry worksheet. In cell M1 I need a dropdown box that lets the user select which options go on the product. You can have multiple options. The list of options is contained in column A of the Options worksheet. Depending on which options are selected, I want to put a 1 in column B of the Options worksheet.
How to do this or have a sample workbook that I can look at. Apr 16, 2009 Below is an IF CASE VB code i was using yesterday. I am coming to a dilemma. There can be multiple columns on this one particular spreadsheet that will have different selections from the dropdown that was created. For example in column B 'VIRTUAL' could be selected which will hide the rows specified in the code below, but in column C 'PHYSICAL' might be selected which requires other rows to be displayed but the rows for the selection in column B need to stay displayed.
I am thinking the best way to do this might be to color code cels within each column based upon selections but how can a cel be color coded based upon a specific selection from the dropdown?
One of my colleagues asked me if it is possible to make multiple selections in a. When you create a drop-down list, you can only make one selection. If you select another item, the first one is replaced with the new selection.
He wanted to make multiple selections from the same drop down in such a way that the selections get added to the already present value in the cell. Something as shown below in the pic: There is no way you can do this with Excel in-built features. The only way is to use a VBA code, which runs whenever you make a selection and adds the selected value to the existing value. This has been one of the most popular Excel tutorials on this site. Since I get a lot similar questions, I have decided to create an FAQ section at the end of this tutorial. How to make Multiple Selections in a Drop Down List In this tutorial, I will show you how to make multiple selections in an Excel drop down list (with repetition and without repetition).
There are two parts to creating a drop-down list that allows multiple selections:. Creating the drop-down list. Adding the VBA code to the back-end. Creating the Drop Down List in Excel 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). Go to Data – Data Tools – Data Validation. In the Data Validation dialogue box, within the settings tab, select ‘List’ as Validation Criteria. In Source field, select the cells which have the items that you want in the drop down. Now, cell C2 has a drop-down list which shows the items names in A2:A6. As of now, we have a drop-down list where you can select one item at a time (as shown below).
To enable this drop-down to allow us to make multiple selections, we need to add the VBA code in the back end. The next two sections of this tutorial will give you the VBA code to allow multiple selections in the drop-down list (with and without repetition). Thx Hyperion135: had to make a few changes to your code.
Here is what your final code looks like inserted in the original “without repetition code” provided by Sumit Bansal. Works like a charm! Thanks for the tutorial but I think I must have missed something. I put information for drop down list in Sheet 2.
Sheet 1 – created drop down list and targetted information in Sheet 2. Pressed Alt-F11 and got the Visual Basic for Applications (VBA) screen, selected Sheet 1, pasted the code and closed VBA.
Tried to select more than one item from drop down list and only got one item showing at a time. Reopened VBA, deleted code from Sheet 1 and copied the code to Sheet 2 then closed VBA. Tried to select more than one item from drop down list and only got one item showing at a time. Not sure if need to have a particular cell or sheet selected before Alt F11? Using Microsoft Office 365 ProPlus. I have just made my excel worksheet Marco enabled and added the code to the code window saved and closed. If I have to use the code for two columns specifically, say column D and column I which have different sets of values in the respective drop down lists, how will the code change?
This is a little bit late, but I just came across this and have a couple questions. Is there a way to limit the amount of selections one can make in a drop down list to say, 5? Currently there’s roughly 200 items in the list and I only want them to be able to select a maximum of 5 of those at a time. Also, say I have the same list in all of column 7 and 8, would I be able to have a command that tells the user that once something is selected in column 7 they can no longer select it in column 8 or vice versa? Hi Sumit – Thank you for this great information! I have an additional question We have a worksheet with many picklists, and I am using this code for all multi-select picklists.
We do allow the user to enter a new value if needed. Then we use “circle invalid data” to find the new values that have been added.
However, when using “circle invalid data” on the multi-select picklists, it ALWAYS circles the cell if there is more than one value entered, even if they are valid choices. Is there a way to get “circle invalid data” to work properly with the multi-select columns? If not, is there something we could add to the code, to “highlight” those values that the user added (that are not valid)? Thanks so much for your help! I’m curious on how one can create dynamic multiple items list. For example let us say we have the following: Column 1 Drop Down Colors: Blue, Yellow Column 2 Drop Down Blue: Light Blue, Medium Blue, Dark Blue Yellow: Light Yellow, Medium Yellow, Dark Yellow Column 2 is dependent to Column 1.
Thus, if I pick “Blue” in column 1 then in column 2 I have the choice to pick Light Blue and/or Medium Blue and/or Dark Blue If I picked “Blue” and “Yellow” in column 1 then in column 2 my options to pick are: Light Blue and/or Medium Blue and/or Dark Blue and/or Light Yellow and/or Medium Yellow and/or Dark Yellow Thank you. Hi, Im using the multiple selection dropdown list. I don’t know how to describe but hopefully with my example below will make you to understand:- In my dropdown list have a several option where each option have their own values.
Grape – 4 apple – 3 banana – 2 orange – 1 when i choose in the dropdown for Grape,Banana,Apple the excel will look for the lowest value among the option i had choose. In this case, the excel will find that Banana have the lowest value among the option i had choose hence the value showed up is 2. How can do that? Dear sir, Can you help me up how to loop range till 2 to 5000 for below code Option Explicit Private Sub WorksheetChange(ByVal Target As Range) If Target.Count 1 Then Exit Sub Application.EnableEvents = False If Target.Address = “$C$2” Or Target.Address = “$D$2” Then If Target.Address = “$C$2” Then Range(“E2”) = Range(“E2”) + Target ElseIf Target.Address = “$D$2” Then Range(“E2”) = Range(“E2”) – Target End If Target = “” End If Application.EnableEvents = True End Sub Sub Evenement Application.EnableEvents = True End Sub. I’m having a difficult time implementing this solution for my particular use case. In my spreadsheet, I am applying data validation on the fly first — in other words, every time I click on a cell in a given range on my sheet “User Lists” it checks the header of that column, looks for that value in the header row on “User Picklists” and then if it finds it it uses the list from that page as the list for data validation on User Lists.
Some of the columns need to be Multi-Select though, so once that code block runs, I have used yours immediately below it. However, it’s not working the way I expect it to even though I left the code almost identical to how you are using it above. The difference is in your sheet, the code fires when I select a value from the list.
In my sheet, it fires as soon as I click the cell and doesn’t re-fire when I select the value. I believe this has to do with the other code block above it, but I’m not sure how to make your block re-fire when I select the value. Do you have any tips? Hello, Both of the codes worked great! However I am trying to combine both of the codes in the same file (workbook). One column I need to select multiple item with repetition and the other I need to select multiple items without repetition.
How do I combine these? I tried to use your code and I am getting my list from sheet 2 and I can get the drop down to allow me to pick one name but I am unable to to pick more than one. I assume it has to do with the way I am tying is into the sheet 2.
Should I be using the Target.Address = “$F$6” or Sheet2!A1:A12 where my list is. Hello, using a VBA code similar to yours, I am selecting multiple items in a drop down list that are separated by comma. The code I am using is to edit and add multiple items in a drop down in the same cell. I am trying to create a pivot table with independent filters instead of all the line items in each cell. For example, in my drop down list, in one cell, I selected apple orange and banana, and in another cell, I have kiwi orange and banana, however, I just want to focus on the banana independently that occurred each time. Is this possible at all?
Or will I have to resort to traditional excel and create a cell for every single item. (Really what I am doing is monitoring donor/patient reactions, so I am selecting for example, nausea, loss of consciousness, etc, and where the conditions were mild, moderate, and severe and how many times in a mild reaction did a donor have nausea symptoms or something). Hope there’s something to do this! I just like that the drop down feature makes one column instead of a million different columns but I really need it to analyze my data. I used the code above to allow for multiple selections, and then I used the modification from Sumit Bansal to modify it work for all of the drop downs in my worksheet.
This worked great! Now my problem is that in the header row of my table I can’t make any changes. Any time I try to make changes the text keeps multiplying instead of deleting. I am thinking that this might have to do with the fact that I had converted this spreadsheet to a table before I add the dropdowns and code.
So the header row had it’s own built in sorting/filtering dropdowns that the code may be messing with?? Regardless it is huge table and now I am not sure what to do with it, and would appreciate any suggestions. My header row is mess and everything I try to do to fix it is making it worse. I used your code for being able to do multiple selections from a drop down menu, and then I modified it to apply to all the drop downs in my worksheet as described below. This worked great.
Now I am having this weird problem where if I try to delete and edit something in a cell that does NOT have a drop down it won’t allow me to delete. So every time I try to delete and add, I just end up with more and more copies of almost the same thing. The only thing I can think of is that it is somehow related to the code allowing for multiple selections.
Have you ever seen this? Do you know what it might be? Hi, thanks for the great code. I have it working on 4 separate columns in a file I have, but there is a strange issue I’m seeing. If I enter data in a cell directly in front of one of the columns I have the VBA code running against and then either tab into or right arrow into the coded column, the cell highlight will jump back to the cell I came from. It then also runs the VBA code against that cell now too.
Example: column B has the VBA code applied to it, column A does not. If I enter any data into column A, press TAB to go to the next cell in the row which is in column B. The cell highlight moves to column B, briefly, then jumps back to column A. If I had for example entered “1” in the cell in column A prior to pressing TAB, if I then enter “2” in that same cell, the VBA code will make the data in the column A cell be: “1, 2”.
Any clue on what I can change in the code to keep this from happening? Here’s my version of the code posted here, which is based on the code posted for keeping duplication of choices from happening. It looks for column headers by title to determine which columns to run the script on. Hello, this is super helpful, thanks!
Only thing is I can only get this to work when I use it alone without any other VBA code, but as soon as I use additional code to have my sheet perform other functions, my drop-down list reverts to only accepting one option at a time. Below is the code – any ideas how I can get it all to work? My other two commands are for time stamps in two different places on the same sheet.
The other two commands still work when I combine all the code, but the ability to choose more than one option from the drop-down menu stops working. This was helpful, but is there a way to have this AND have code so that the duplication in the cells stopped? I was using Spyrule’s code he posted above, which is: If Oldvalue = “” Then Target.Value = Newvalue ElseIf Target.Value = Oldvalue Then ‘. Hi Sumit, Great code here. The problem is (keep in mind it may be on my end), the code is not working. I even downloaded your code, and tried running it on my machine, and I still am only able to select one of the drop list items. Is it possible there is a security setting I missed?
I have enabled macro’s, and allowed trust access to VBA project object model, but again, the code doesn’t work. Also, is it possible, to have the code work on several different cells (copy and paste drop down) and have the VBA code changed to accommodate? I am trying to make a drop down selection list down over 260 line selections. I essentially need to copy the drop down to that many, and allow for selection as I go through the line items. Thanks again. Hi Sumit, thanks for the codes. The multi-select list worked great but I have issue with the existing single-select list.
Before I added your code, validation for the single-select list worked. I only could select the value from the list. But after I added your codes, the validation for single-select list didn’t work. I was able to enter any values to the single-select list and I didn’t get an error message. If I only select the value from the list then it’s fine. But I still could enter any value and the cell will accept it.
Do you know how to fix this? Thanks so much for your help! I think I’m having the problem of duplicating values.
If I make multiple selections from a drop down list for a cell and then try to put in something that is not from the drop down list, I end up with several repetitions of what I had selected in the same cell. Then when I try to delete some of the repeated values, it will repeat itself again in the same cell. So it becomes an endless cycle of repetitions until I just delete the entire cell.
But I can’t figure out how to fix this. I tried to put in the code that spyrule shared but I may not be doing it right. I’m new to Vbasic so I don’t really understand the code This is what I ended up with: Oldvalue = Target.Value If Oldvalue = “” Then Target.Value = Newvalue Else If Target.Value = Oldvalue Then GoTo Exitsub Else Target.Value = Oldvalue & “;” & Newvalue End If End If End If Application.EnableEvents = True Thank you for posting. This was really helpful. This is great! Thank you so much for this. I have one question though.
I’ve read the comments and can’t find the same question being asked – apologize if I missed it. I am able to select multiple options from a dropdown box successfully, however I can’t find a way to them remove one of the options unless I clear the entire cell.
For example, I select options such that my cell looks like: Apple, Orange, Banana. I no longer want Orange selected. If i try to delete the Orange text, it doesn’t work.
The only way I’ve found to do this is to delete all contents of the cell, then go back and select Apple and Banana from the dropdown. Hi there – I tried to use this code but it is not allowing me to add multiple values in 3 of my columns. Hi Sumit, This worked great thanks, this question leads on from what I have now achieved with this code. Now that I have selected multiple entries in some cell (I have applied this code to an entire column) but not all, I would like to filter down to entries within that column, ie find all entries that contain orange or blue. So I have applied the usual filter to my heading row but when I click on this I would like the options to filter to appear the same way it would if there were only one entry in each cell, but it has the lists/multiple entries as options. Basically I want filter function to comma separate my lists I guess? Does that make sense?
Any suggestions? I can just type in the colour in the search option under filter but that doesn’t work if I want multiple colors at once. This is really great, I’ve been looking for this option. My question is, I’ve followed your instructions from above to modify the code and get it working on just one column, in this case column 7.
However, I’d like to get it working on column 6 too but instead of having the comma seperate each value I want to use a hyphen instead. So currently on column 7 the output is “1, 2, 3, 4”. On column 6 I want the output to be “1-2-3-4”. I’ve played around with the code a bit but I can’t seem to get it rightany suggestions? Hi Sumit, I have run into a snag. I started with your code at the top of the thread and started making changes based on your recommendations.
Allow for multiple selections. (First code given on page) -Works. Changed the code from Target.address = “$C$2 Then to If Target.Column = 10 And Target.Row 3 And Target.Row. Below is the code you can use. If there is already a value in the cell and you select it again, it will not append it to the existing value. Never mindfigured it out!
Thanks for the post/information though! ‘ I just swapped out Target.Address for Target.Column. Tested and working.
Sumit – I was wonder if you could assist me. I have a column titled ‘Services’ and have created dropdown list in each cell.
The worksheet has about 186 rows (and growing). I used this code to be able to select multiple and have them show up in each cell.
I took out ‘IF Target.Address = “$C$2” Then and one END IF and not it works for all cells that has the dropdown list. HOWEVER, whenever I type anything in any other cell, it doubles/replicates what I already had in there plus what I was typing. I’m guessing that is because of the code I put in for the dropdowns. Could you help?