title

Good day. What solution can you suggest to have “match” return value at column D if the code in column C matches with one of the codes in column G. The current job title code is referenced with the table of possible jobs for completers of certain skills training. In short, this is a problem...

here is my code. Sub Restore_Setup() Dim Finfo As String Dim FilterIndex As Long Dim Title As String Dim FileName As Variant Finfo = "Text Files (*.txt),*.txt," Title = "Select a SETUP to Import" FileName = Application.GetOpenFilename(Finfo, _ FilterIndex, Title) If...

Hey I have added another dropdown box to a project containing clothing brands I'm working on. This time I'm trying to change the value of a cell, based on the selection in the drop down. So similarly to another post I made where I wanted to changed the title of a chart based on the drop down...

Hello, I don't care if I have to use VBA or a formula, I was just hoping someone might know how to do this... I have a 'form control' drop down list (it is NOT) a data validation drop down list...Its a form control. The form control has a list of Fruit...Everytime someone selects a different...

Hi guys, This vlookup problem has me scratching my head. For the following table I use the vlookup formula below to lookup up book title, author and price in different cells at the same time. It includes a COLUMNS function to paste it across cells to return book title, author and price. Whats...

I have a user form with check boxes and they each have a title. Plant Manager Foreman Supervisor etc. I would like for a user to be able to select everyone that was there. when the user hits the submit button i would like the code to be able to look in column A for the first cell that has...

I have a workbook that I want to extract only certain data from and brought over to a second workbook. The workbook I’m extracting from has 14 columns (these columns never change) but the number of rows can change weekly. This is the part I don’t know how to do, I may be biting off more than I...

What I am hoping to do is it loop through my ComboBox about 200+ Items. For each item in the ComboBox perform the combobox1_Change function to recalculate sheet with the code I have in there and then run this code to print to PDF, and attach as an email for each item(each Item has its own email...

Hi, i want to display query as dynamic table using VBA from database (postgresql). I want to create new dynamic table with specific query within it, next go below this table and add next dynamic table with another query. Tables should be added with title. Do you have maybe some code how to...

I'm trying to get Excel to switch over to a completely different software that has a title that is difficult to capture....and as you may know AppActivate needs the exact title to do that. I need a method that captures the full title name and passes the string to AppActivate.... This part...

I am sorry in advance for the title i am not sure how to word the title or really how to form this question. Back in the day i would drag a cell from the bottom corner and "fill formatting" or "fill series". for some reason this is gone now and replaced with a new menu that i don't understand.I...

Hi, I'm trying to make a table comparing how many clients write books with those who host podcasts. One column has book titles, and each title is different (those who don't write books have a 0 entered). I'm planning to use a new column to convert each book title name to a value of 1 (I'd like...

https://www.mrexcel.com/forum/excel-questions/1046359-windows-dpi-settings-affecting-print.html needs a title fix

I am looking for a formula/UDF for computing the Variance of Folded-Normal distribution which incorporates the ERF function. The formula for the same can be referenced at https://en.wikipedia.org/wiki/Folded...l_distribution (PS - also posted with a different title...

Hello guys I need help to 1) search for "xx" in the table 2) if "xx" is in the cell then insert column title. Something like this: To something like this: TIA Mignon PS: I am new to Excel, working on Mac and cannot find out of programming yet, unless you can help me with step-by-step...

Good day, I'm trying to match the value of 2 cells from one sheet to 2 column in another sheet. I can get to work with only one data but not both. The main point is to be able to look up previously entered information and avoid duplicate. here is the code i'm using to find duplicate. Set...

My company has been using templates created in Excel that were set to Read-Only status many years ago. The title bar of these workbooks looks like this: "Price Change Template - 1500 (v1.5).xls [Read-Only] [Compatibility Mode] - Microsoft Excel" Our IT department made some changes to this...

Hi everyone, first of all sorry for my english. I am here because i have a problem that need to be solved because is for work and i dont´t know how to make it happen. I am developing a worksheet that have several sheets that contain a table. All the 4th sheets have the same table, with the same...

hello all i have the following formula already set i just the formula to reference if the employee has worked more then then 1-2 years and 2-5 years: B4 = Start date which for this example is - 4/27/12 D4 = Title which is "Cook" E4 = Anniversary date which is...

Hi All, I'm trying to import a file based on one criteria. The importing file title has to match the first 12 characters of the file name that is performing the import. For example, File A performing the import, has to match File B's title for its first 12 characters for it to perform the...