vba .formula

Hello, I am trying to create a VBA to delete a worksheet based on a cell. I know the VBA to delete an active worksheet, but in this case I am working with a template that contains 34 worksheets and based on contracts I may not need them all "every time". So I would like to create a VBA that...

create a vba function with two tables where table1(three columns(with 20 rows)), table2 has (1 row and 1 column), match entries in table1 column1(with 20 rows) with table2 row1(20columns) and match table1 column 2 with table 2 column 1 and enter value in corresponding row and column found from...

Hello, I am looking to populate a calendar grid with select piece of information. My Calendar Grid sheet is named "Calendar". The sheet with the data is named "Input". The macro successfully completes one cycle but I get an error in the 2nd cycle once I arrive at the Cindex line of code...

Hi Everyone, I am not sure what is the best way of solving this problem whether its some advanced function, or VBA/Macro route. What I am trying to accomplish is to merge and sum multiple rows for the same invoice number. So, if for INV1 there's multiple product line with same product line...

I'm fairly new to VBA in excel and have been going through several beginning books to try and accomplish getting values from closed workbooks on a network drive and populating them into my main Dashboard workbook. The only problem is they are for a running 13 months, so the files will change...

I am trying to VLOOKUP some value in 2 sheets and if the value is found then i am putting a hyperlink on the Sheet 1 cell to point it to the Sheet 2 cell. I have written an Excel formula for the same and it is working fine. But i am unable to convert it into a VBA formula. I tried many...

Hello, I'm trying to find a way to get a macro to organize my data. I have the following data that was generated: Large C US Large C US Large G US Medium C US Medium G US Small V US Small C US DM C International DM V International EM G International EM C...

I wish to create a UDF that calculates a formula used in Mass Appraisal of Real Estate I use MS Excel 2007, and Windows 7 This is a sample what my Data looks like: <tbody> AssessedValue SalePrice Ratio = AV/SP 90 88 1.02 90 93 0.97 90 87 1.03 90 94 0.96 90 85 1.06 90 96 0.94...

Hi, I have coded a macro that effectively copies a dynamic named range to a sheet called Sales chart. The working named range, called ItemsSold, is a single column consisting of uniquely filtered data. My problem is the second named range; I want it to look up the source data, called Sales...

Hello, I've been searching the web for hours and it seems I just can not locate exactly what I need. I'm hoping someone can assist. I've created a userform that has a listbox which users can add items. I have set the RowSource to the named range in the Excel spreadsheet that will also hold...

Hi Guys, I need to make an excel sheet, when that excel sheet will open, it will ask you for the calender, and once we select the calender it will automatically pops up the date and day on the top like this: Start of Excel: Select Calender: 3/2/2015 - 3/8/2015 In columns: <tbody> 3/2/2015...

<tbody> Hi, I've been working on the problem of automating the plotting of line diagrams. But I did not yet manage to solve it yet. I would need multiple charts one for each column (from E to R) using the same column (B) for the X axis. The ultimate...

Hello, I would like to do something like this: Range("=CELL(""address"",INDEX(INDIRECT(R2C12),3,2))").Select ActiveCell.FormulaR1C1 = "=CELL(""address"",INDEX(INDIRECT(R2C12),3,2))" will put the formula into the currently active cell, but I can't get the VBA to select a range based off the...

Gday All, Trying to achieve: I have a list of formulae that I need to enter into a particular "Sheet" via VBA. The range is H2:X5000. I have searched far and wide across the internet only to find solutions that do not yeild any results, literally for some reason. Examples of some of the...

Good day, I have a userform that has a start and end date in it and then three checkBoxes (1st, 2nd and repeat) I have managed to get the first and second section working fine, however part three has me at the end. In 1st and 2nd it just has to get the info from two columns (the first time and...

I am trying to get the multiple results form a Range and cannot use vlookup so using INDEX Function. My formula "=INDEX(Sheet1!$A:$I,SMALL(IF(Sheet1!$A:$A=$A$2,ROW(Sheet1!$A:$A)),ROW(2:2)),7)" worked perfectly but not working in VBA code. I am getting "Compile error: Expected : list separator...

Hi, in Excel I'm using formula: A2 = REPLACE(A1,1,FIND(":",A1),""). Now in VBA I did like: ws.Range("A2").Value = "REPLACE(A1,1,FIND("":"",A1),"""")" and it's ok. How can I directly assign value from formula to my variable??? I had something like below but is wrong :/ Dim new_value as...

Hello everyone! I am trying to insert the following formula into my current code: =IF(B2="","",B2+30) This formula is pulling the date entered into cell C2:C and responding in D2:D by adding 30 days to that date. I am not sure how to do this. Can anyone help?! What I am wanting is for the...

Hi, Can Someone help me with the VBA? I have code but i dont know how to change to insert Text and then Total. Sub Test() Dim Rng As Range Dim x As Long Set Rng = Range("F1:F" & Range("F65536").End(xlUp).Row) For x = Rng.Rows.Count To 2 Step -1 If...

Hello all, I am looking for a pure VBA solution to a small issue I am having when trying to preserve a hyperlink when using VLOOKUP. I have two worksheets within the same workbook. Worksheet 1 contains a lot of information for internal use(many of the cells in all of the columns contain...