Hi all,
Vers office 365 (with xlookup)
I am already going to implement the formula from this thread Drop Down lists but I am struggling on some mechanics of my drop-down list as I have many conditions.
I want the drop-down list journey to be: Internal/External? -> Provider name -> Target...
Hello Everybody,
First of all, thank you so much for using your time in assisting me with this matter and reading this inquiry. It is greatly appreciated!
I am currently making an order form in Excel, where I am pulling my product data (material description) from a sheet I have named...
I have a spreadsheet I'm working on where I need to track daily sales, that connects with a commission structure. The current table I have shows all days of the month (29 days this month), I have created a Data Validation drop-down list with other months of this year.
Is there a way, that when...
Hey guys, has the website had an upgrade? Looks great!
I'm trying to make a waste cost dashboard. Basically, all I want to do is select the supplier code from the drop-down list and once I enter the number of workshops run, it will automatically update the number of seats the event had space...
Hi everyone,
I am working for a project for my company and would need some help on an issue I have.
Ultimately, I want to create a model that is as flexible as a PivotTable without using a PivotTable. The reason for this that I won't be able to change any fields.
I am working with...
Dear Experts,
I have a datasheet and i want result in second sheet based on week numbers.
Main columns are as i mentioned below,
Customers
Styles
Qty
Rate
Values
shipment dates
week numbers (Weeknum)
status (In-process, ready to ship, shipped)
in second sheet using same columns and i want...
I have a table with 6 columns. The first column is a drop-down list with 5 options indicating whether a row is Stock IN or Stock OUT. I need the rest of the corresponding row to change text color depending on the value in the drop-down list. For example:-
IF Cell A1 is equal to "Own Haulier In"...
Hi, I havecreated a template for my staff to use. I've written code that generates aunique sequence number and saves the file but I am having trouble when it comesto removing any information that may have been pre-existing on the form. I amcurrently using the ClearContents command but I've found...
I recently created a private module that when "alcohol" is selected in cell Q3, then the text string "No nutritional value" is automatically entered into cell U3, and the text string "Over21/single" is entered into cell AA3. If "alcohol" is NOT selected in Q3, then U3 and AA3 have a drop-down...
If I select a certain item in a drop-down list, is there a way to populate a certain item in another cell that has a drop-down list?For instance, let's say I have a drop down list in A1 which lists RED, GREEN, BLUE. If I select RED in A1, if B1 has a drop-down list which lists 1,2,3, can I have...
If "red" from a drop-down list in A1, then "certain text" in B1, else a drop-down list in B1. How can I do this with VBA?
I want to create a drop-down list in, say A1, which returns RED, GREEN, or BLUE.
If a user selects, say RED in the drop-down list in A1, then I want another text string to...
Hi all,
I am working on a form that includes product selection through drop-down menus. It starts off with a product category, a chosen category predefines a choice of product names. After choosing a product name, the user needs to select two parameters which both depend on the product name. My...
Hi,
I am looking to combine a drop-down list with a range of editable data that can then be saved and later loaded (if possible). What I mean exactly by this is to first have a single drop down list containing all of the calendar months of the year. A range of data (dates, vendors, costs, and...
I created a drop-down list with different fruit names and I want the user to be able to type in the first couple letters of the fruit name and have it auto-populate. For example, if the user types in "ap", the word apple would automatically appear. Is there a setting within the data validation...
I have a drop-down list in both cells A1 and A2 each with different values. I am trying to let a vlookup override the drop-down list in A2. For example when you select 'Leave' in A1, A2 must automatically choose a specific value from the drop-down list in A2 that cannot be changed.
I tried a...
Hello guys,
I am trying to create a dependent drop-down list in a table range that is dependent on what the user chooses in the first column. The data for the drop down lists are stored in another table on another sheet.
Imagine that the table below is formatted as a table range (Formatted as...
I'm just learning to improve my VBA skills. Made lots of progress yesterday but now I find myself faced with a momentary wall...
My dilema:
I have two sets of data in Sheet2: one set in array AT1:BU2000 and the second in array AB1:AR2000.
There is a drop-down menu in Sheet 1 containing a list...
Hello!
I have an online satisfaction survey that I give out to customers. Each month I export the responses from the software as an excel file. However, I also have a separate excel file that is used for tracking purposes. I have been manually inputting the data into the tracking spreadsheet...
Hello,
I am trying to create a drop-down list based on a (rather complicated) formula, and since the validation rule won't accept a formula, I'm not sure how to proceed. Essentially, I am trying to create a spreadsheet for scheduling staff in various locations, based on their qualifications and...
Hi, I'm very new to VBA programming and I'm not yet able to put together a macro I need :eeek:. I'm not quite sure even where to get started. I'd like to create VBA Macro that allows a blank cell to be set a value via its drop-down list then take each subsequent value selected via the same...