solved! :)

Hello I have this formula looking at the sheet below it, i would expect a return in D23 of 18.. what am I doing wrong? TIA!!

Hello while this isn't at all important it is driving me insane because it doesn't work. I really only wanted to have a button on the sheet while I'm designing the sheet so I can unprotect it without a password. I know I can do this with 2 buttons, or I can disable the code that's causing it to...

NOTE: Originally posed elsewhere. I do not believe I will get an answer. I hope I can post it here. I have written some code in Sub Workbook_Open. It works fine. However, I am trying to do two more things. 1. I don't know if I should use Workbook_BeforeClose, Workbook_Deactivate, or...

Hello, can I have more than one lookup value in a vlookup to return a value in another cell when a selection is made in a dropdown list? The example I have is: Dropdown list Columns: C17 C18 C19 C20 If the user selects from the dropdown list a region that starts with a L in front of it, I...

I have a workbook (250+named sheets) with an this button on an master sheet. I am attempting to pull the value from B2 if the tab name matches and paste the description into each sheet in C5. The following code works but is only copying the first field value to the individual sheets instead...

Hi All, reasonably new to VBA and need some help with my project. I have a spread sheet that has customer abbreviation in Column "F" and a range of numbers "L:AA" what I need is VBA code to find all occurrences for a each customer in column "F" and add each column individually and place...

I'm trying to take a rather clumsy spreadsheet (sent to me periodically by a customer) and distill the crap into usable parts. So I have a text-input cell with the 'date' in it, which appears like "Oct. 1 - 7, 2000" (see screenshot). Naturally this is for the week of Oct 1st, 2000. Can I...

I have about 30 files to copy to a new folder & rename the files with the date format ddmmyyyy added at the end of the filename before the Ext identifier ie filename.doc? to filename ddmmyyyy.doc? (I also need to modify actual files and want to do this via a macro iteration but one step at a...

Hello. I have an array formula that gives me the intended results, BUT the data is too large to use an array. Could anyone help me change the formula to a non-array function? =INDEX('Order History'!E:E,MATCH(1, IF('Order History'!A:A=C3, IF('Order History'!C:C= "INITIAL ORDER SETUP",1)),0))...

I have some python scripts to run using VBA, At first it worked, then stopped working after a PC change over. ( the old pc rip'd) I thought it may be something in the VBA module Tools/References but not really sure what to look for. Then I tried a test .bat file and still nothing happens. Yet...

Good day to all! It is my first time posting here. I would really appreciate it if you can help me out guys. This is my situation... I have this code in my workbook that Copies the whole workbook and paste it as values or text in a new workbook. And additionally it Save it as a xlExcel8 (xls)...

Hi, I wold like to use the autofilter to filter data based on the criteria that matches a given range in another sheet. Following is my code Sub Macro1() ' ' Macro1 Macro Dim arr() As Variant arr = Array(Sheet1.Range("B2"), Sheet1.Range("B3")) 'Using this the code works fine and the filter and...

I am sure this has been asked before but I do not know how to word it for a search. I have a nice little budget put together and am trying to plan for buying a home. Basically I want a cell to auto-update based on the value of another cell. Simple enough right but here is the catch. If I put in...

Hi all. I have 5 comboboxes that pull the same list of data. I want all of the comboboxes to dynamically change which items are available in the list. If a value is selected in a combobox, I don't want that value to be in the list of any of the other comboboxes. How can I do this? Also, it...

I am attempting to create a vba script for excel to do the following task from a two column list of data (subnets and serial numbers) but am a COMPLETE VBA know-nothing. :confused: • Check the 1st column (subnets) on ‘Sheet1’ for a unique value AND does not contain an “x” in its corresponding...

I am trying to create a link to a sheen when I create a new worksheet in my meeting book, is there anyway to add a link when I create a new sheet? I have found a few codes that allow the cration of an index page, but that is not what I am trying to do and creating a macro didn't work too well...

Hello Excel masters, I am trying to populate (via VBA) a textbox/combo box from one user form to another user form. The first user form has a room number in a text box1. If certain conditions exists, a button is selected to bring up another user form (both forms are modeless). I want to...

Hello all, I have trouble with calculating standard error with multiple criteria. Below is the formula I used: =STDEV(IF($J$2:$J$25="A",IF($K$2:$K$25="B",IF($L$2:$L$25=1,M2:M25))))/SQRT(COUNTIFS($J$2:$J$25,"A",$K$2:$K$25,"B",$L$2:$L$25,1,M2:M25,"<>")) The problem is the blank cells in the...

I am wanting to hide a command button if a condition is met. The below is giving me a type mismatch runtime error. If Worksheets("Final").Range("H6:H97").Value = "" Then WorkSheets("General").Shapes.Range(Array("Button 2")).Hidden WorkSheets("General").Shapes.Range(Array("Button 3")).Hidden...

I am having trouble with this... I have fiddled with the find function a lot and no luck. I need to find a string from workbooks("book1").cell.("E1") in workbooks.("book2").range("A1:AAZ1). Once found Offset.(0,-1).activate. (the cell below what it found) Then copy the active cell and the 8...