selector

Hi, I chanced upon this product selector. Values will depend on the choice selected, may I know how to do it? Thanks, https://www.dropbox.com/s/5jd8kus6f3p21hh/Product-Selector.xlsx?dl=0

Can anyone help me with the answer to this question? when using the Microsoft query wizard what feature is used to designate the rows to include in a query? source selector data filer data validator row selector limited query I had a feeling it was row selector or source selector but I've...

Using this, I can choose a file to open: Dim Selector As FileDialog Set Selector = Application.FileDialog(msoFileialogOpen) Selector.Show Dim Selected As Boolean If Selected Then Selector.Execute Dim wb As Workbook Set wb = ActiveWorkbook Dim MyVal MyVal =...

I am trying to create a random password selector with the following parameters. I want to put a lot of passwords (around 5-10 columns with 100 passwords in each column) onto a worksheet and hide it I want the formula to say "when there is a value in B2, put one of the random passwords from the...

Hi I want to create a data log sheet for when I update various parts of my businesses intranet and am looking to incorporate a cell with a date selector (calendar style). However, due to limitations of the business network, I am unable to use the built-in calendar (developer tool?) with Excel...

Dear all, First of all I'm glad to be joining the Forum. Said that, I'll expose my issue... I've currently an excel file, in which I've all the document links from a modular catalogue, in different columns (depending on each one's language). I need to create a macro that (once having...

Hello, I am stuck in a jam, being an Excel novice! I have a form (in excel format) complete with drop downs. I need to be able to add a drop down, that lets users select between different languages. The entire spreadsheet (including the values within the drop downs) needs to change to reflect...

Hello, I would like to know if it is possible to create a date selector that is associated with a particular cell instead of manually typing in a date? I currently use Microsoft Excel 2013 but the spreadsheet that I am creating with will most likely be used on Excel 2010 (saying that in case...

Hi All, I have a few thousand rows of data like table A with different names and T counts but the same $ amount and same date ranges. I would like to format the date to look like date B, so if the name,date ranges, and $ amount are the same then grab the highest T count and put it into a new...