options

Hello, I have a file that I work on a weekly basis to upload item options, and these item options require abbreviations. These are limited to 15 Chars. So Items options are Alphanumeric, have symbols "/" "-" etc and I've been saving the abbreviations also alphanumeric. For example, some of...

Ok, here's a screenshot of what I want to accomplish https://imgur.com/a/nihST When I choose multiple options, the immediate window lists all of those options from column 1 in the drop down menu, separated by a comma. What I need is a separate box to list the column 2 items the same way. How...

Hello all, I have an issue where my pivot tables/charts are not refreshing, but the source data is. I'm run an ODBC query, which feeds into a table, that feeds my pivot table. I've seen VB options on running the query, then refreshing tables, but I'm not super savvy with that. Perhaps someone...

Hello, I am no expert with excel so please forgive me if what I'm about to ask is silly. I am creating a canned response tool for my department which allows users to pick which options were used. Currently I have it formatted as a list which works but it's not how I'd like it. I would like to...

Morning folks, Hands up, I'm abit of an excel amateur. Hoping for abit of guidance and assistance. -I've got a drop down list with 20 options. -Each time the list of dropped down and 1 of the 20 options are selected I want the cells below to paste a selected cells layout I have created on...

I am learning excel (properly maybe) by doing a course to learn all the things I have stepped over over time! I am at a lesson for sharing workbook. My option for this is greyed out. I can see options on the review tab for 1. Protect Sheet 2. Protect workbook 3. Allow edit ranges 4. (In Grey...

Hi, I have a graph of data, and when I put this into a chart there is the option to fit the data to a curve. The options are Linear Exponential Polynomial These are OK, but the problem is that I have a curve that is most closely resembling a "Beta" distribution. Is there any way to fit the...

Hi all, I would like to ask what're the best MACRO options out there to automate data into SAP system. The primary focus is to copy a bunch of data (from excel) into SAP Vendor Master Data (XK01) automatically. Based on my limited knowledge, these are the only options I'm aware of: SAP LSMW...

Hi, Good Afternoon! I was able to include the Indirect Function by the help of Spreadsheet but now I need to get a function the will then choose 2 options on each sheet. Scenario: Sheet 1 - Export Sheet ** 2 options Document Rates or Non-Document Rates Noted: Rates are on different cell...

So, I am looking for a something simple. I need to call a macro that displays a window with some options that I will pre-define, for me to select. The selection needs to be stored in a variable which I can then use later in the macro for other purposes. The issue I am having is that I can't...

Hi, In Column N, I have a drop down with 7 options: Later Next 1 Next 2 Next 33 Future 3 Future 4 Future 43 In column M, I want to categorise them in 3 options = Later, Next and Future but I’m getting value error. This is what I tried...

Hi and thanks in advance! I have a TABLE, not a Pivot Table This table is huge, so I have say 2 Slicers The First Slicers named "QAZ" shows 3 options: AA BB CC The 2nd Slicers named "Country" shows 5 options: Spain Italy UK Ireland (blank) When the Table is Clear with non filtered data...

I am having a problem with dependent validated options using INDIRECT. Please see illustration. https://www.dropbox.com/s/fnlyewqsux7rh0k/Indirect_validation.xlsm.png The goal is to make the valid options offered in column I dependent on the selection made in column H, using =INDIRECT(A2) to...

I am in excel trying to pull a list of options for each product I have. For example - Column A/Column B Pants/Red Pants/Blue Pants/Green Shorts/Orange Shorts/Yellow Shirt/Striped Shirt/Polkadots Shirt/Chevron Shirt/Floral What I would like is to be able to use my list of product names in...

Hi, Not sure about the best way to go about this like at all.. I have a table of data that comes in once a week that looks like the table below (but bigger). Now I've made another table listing all the tiers down one column, and the criteria names across. The data needs to be the sum of the...

Hello, I'm hoping you could help me out with an urgent query. I'm about to launch a new range of 8 products which in turn have 6 possible options - how can I calculate the total amounts of combinations for every product? Thanks in advance for your help. Jan

I have a grid of data that shows all the products I can order in the columns across the top and all the options I can order with those products in the rows down the side. In the middle shows the price of the options (£x), whether it is already a standard fit (Std) or if that option isn't...

Hi All, So honestly not sure how to start something for like this... I'd like to create a Part Number Generator for hardware, we have number system but what I would like to do is depending what I choose, my options become limited to certain things, then once I have chosen everything, it...

Hello everyone, I have a list made of many columns and rows, and I need to control it. For example; I need to check the cell A100 by looking at K100 cell. I think it is better for me to darken all the cells in the row 100 to make the vision clear. Are there any options in excel to do that...