formula & macro

  1. M

    VBA Not Interpreting Single Quotes Correctly

    Hello, As part of a larger macro, I'm trying to input a formula into a range of cells. This formula does an indirect lookup of a worksheet name as a tab name, and therefore requires single quotes. However, VBA keeps trying to interpret the first single quote as a comment, and therefore...
  2. M

    Organizing tasks and schedules with forulas

    Hello everyone, I am trying to make a spreadsheet that includes a calendar for task scheduling and the project details in another tab. Columns B and C in the calendar look something like this: <tbody> B C proj.1 task 1 (blank) task 2 (blank) task 3 proj 2 task 1...
  3. E

    How to connect INDEX MATCH formula with FILE open Dialog ?

    I have this formula: =INDEX(Tabelle1!$D:$G;MATCH(1;(Tabelle1!$F:$F=A9)*(Tabelle1!$D:$D=E$1)*(Tabelle1!$B:$B="Motor");0);4) which works perfectly fine. What I want is to create a VBA Code that does the same function as INDEX MATCH just between the worksheet I Need to connected with different...
  4. J

    Nested IF Formula from IFS

    Hello, Might be an easy fix for you Excel experts but I can't seem to get the nested IF formula to return the results I need. The formula would look at number of days and return text as below: Convert the following IFS formula: IFS($AL13<=365,"Within One...
  5. S

    Convert incell formula to VBA code

    So I have a pretty complex formula that I am using in some workbooks. I would like to convert them to VBA, but it is way over the 255 character limit that .Formula allows. I know of and have used the replace option before, where, for example, you have a formula: =If(AAA,bbb,CCC) You replace...
  6. mikecox39

    Macro for getting data from another workbook

    I'm treasurer of my HOA and every year I save my current Budget workbook, and create a new one using Save As and incrementing the integer by 1. For example, MB18 gets Saved As MB19. I then clear the data using a macro to start the new year. One of the problems with that is I don't get last...
  7. N

    Help needed with new formula, or vba function for custom Excel 2010 tool

    Greetings, Thanks, in advance to those who might be able to help. I'll make it as concise as I can while providing context when needed. Scenario: I work for a Distribution Centre with about 10,000 unique location in the warehouse (4 different sizes and storage capacity [full, half, quarter...
  8. K

    How to change a full name in cell to only last name first intial

    I have a full name in a cell and want to convert it to last name first initial only in another column Have: Smith, Mary Want: Smith, M some cells have: Smith, Mary / Jones, Sam Want: Smith, M; Jones, S
  9. S

    Better way to input formulas in tables?

    So I have 8 different tables, some with up to 65 columns, others less. Current I have formulas in the columns for those which need formulas. I kind of want to transition away from having the formulas in-cell, where they can be changed, erased, etc., to having them be coded. However, I am...
  10. D

    VBA not updating formulea

    Hi All I have a VBA project that on button activation opens 2workbooks (Data sheet and PPM tracker). The main workbook (report) has formulaethe links to the Data sheet. When I open the workbooks backwards manually (datasheet then Reports) the formulae updates. The Formulae I am using are...
  11. D

    Need help subtracting daily from a total inventory amount that is replenished every so often

    My workbook is broken into 3 separate sheets, #1 I am entering in a daily amount of different bundles and or products which each have their own cell. This string of data is essentially copied to sheet #2 and deleted from sheet #1 as sheet #1 's only responsibility is the daily input. Sheet 2...
  12. D

    Auto fill

    Hello Everyone I have been assigned a task to create a auto fill function. The task is I need to create a formula to search a particular alpha numeric word in a column and define how many times this word as appeared in that column. For example lets say a alpha numeric word called "MIKE1" in...
  13. U

    VBA: Vlookup & Filling vlookup down

    Hi Guys, I'm trying to work on a macro but I'm just recording it and here's what I got: Sub Macro1() ActiveCell.FormulaR1C1 = "=VLOOKUP(C1,PvA!C2:C17,16,0)" Range("AB5").Select Selection.Copy Application.Goto Reference:="R10000C28" Range(Selection...
  14. Rymare

    VBA Populate column with formula

    I have a dynamic range, it changes all the time, and every time a value looks like so: #####-### (or in my formula I put ?????-???), I need this formula: =IF(COUNTIF(A2, "?????-???")>0,MID(A2,5,1),"") to be placed in the corresponding row in column C, because I need to extract the 5th number in...
  15. S

    Adding another range to VBA to hide rows

    I have written VBA code to hide specific ranges in 4 different tabs in my workbook. I am looking to add another range to the code that would hide rows based on cell value in the same range on each of the 4 different tabs. If the cell in range B9-B13 is blank, then hide that specific row on...
  16. S

    Rename 4 tabs only based on cell value with VBA

    I have a workbook that has 14 total tabs and I am looking to write VBA to rename only 4 of the 14 tabs. The tabs to be renamed will use cell values on a different tab that contain no illegal characters or length restrictions. I have researched how to write the code, but only found the cell...
  17. A

    Rookie needing help with Macros and formula assistance

    Hello I am pretty much a VBA rookie, but learning a lot in the last month so please talk to me like I am six and explain as much as possible :) I had a thought about putting in a couple macros depending on if a cell is blank or has an "X" I want to have a macro ran depending on which option is...
  18. B

    Help adding formula to Macros (with relative reference)...

    I have my Macros working well but need to make it paste a formula in the active cell. I've looked at several posts but have only become more confused. Still a newbie - I've mastered copy/paste and slight tweaks but this is confounding me.:confused: My formula to include is...
  19. T

    Data need to split 1 hour time intervel

    <colgroup><col span="5"></colgroup><tbody> <colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody> I need to split data, i am having 24 hours data. the time interval also included in that columns. for example, input...
  20. Johnny Thunder

    VBA Help - Extract Formulas and Cell Location from a Range

    Hi group, I am working on a spreadsheet that has a row of formulas that are from the range ("BB4:BX4") what I am trying to do is get a list of the cell location and the formula within that cell. Anyone have any code that can do that? I would need the results on "Sheet1" in cell A2. Example...

Some videos you may like

This Week's Hot Topics

Top