macro formula

  1. X

    Update formula Col reference Macro

    Is there a way to use a macro to update a column a sum if or vlookup formula is pulling data from. Ex for a vlookup I have 12 mos of budget data in columns. In Feb I am pulling data from the 8th Col in the table. I'd like to run a macro that would update that number by 1 to pull Col 9 next month...
  2. W

    Please help me out with a Excel formula

    I'm developing a testing platform. I'm struggling to come up with a formula in Excel for the following tasks Add Pass/Fail/Advisory dropdown list. When Fail/Advisory selected from the dropdown list. The user will have to write a few lines about the outcome results. Then all the results then...
  3. F

    correctly formula in vba

    Hi, I have formula: ws_22.Range("N73:N" & row_to_del).Formula = "=SUM(I73:M73)" How to add "row_to_del" to function SUM? ws_22.Range("I100:M100").Formula = "=SUM(I73:I & row_to_del)" 'its wrong I tried also "=SUM(I73:I """& row_to_del""")" but also is wrong.
  4. H

    Excel Formulas in VBA Editor

    Hello, I'm trying to automatize a report. I have several huge formulas that I would like to embed into the VBA editor. Can anyone help? This is the formula I want the Macro to enter: <tbody> IFERROR(IF(IF(ISNA(VLOOKUP(A:A,'Q1186 Warehouse Order Roundup'!A:S,MATCH("SHIP_STATUS",'Q1186...
  5. D

    basic macro help

    hi all i created a macro to run off of some filtered data, and copied a formula down, but when the data gets updated the now filtered rows do not match where i had copied the formula, so the formula is on rows that i do not want and is returning n/a's. is it possible to write a code that will...
  6. S

    Macro help required for getting data from multiple excel files.

    Dear All, I have 1000s of same structure excel files in a folder. I want to extract some common details to one single excel file. Ex. in excel file book1.xls, page a1 relates to name of customer 1, a2 relates to his address, a3 relates his contact number. etc.. As well as in book 2.xls, page...
  7. S

    Help Programming a Macro

    I have a macro that is no longer working. The odd thing is, everything about the report (except the raw data) and the macro has not changed since its original creation. I'm assuming that an update either in excel or our database system is causing the macro to not perform properly...
  8. M

    Formula writing in macro

    Can anyone tell me how I can get a macro to perform the following calculation please? I have absolutely no VBA knowledge, so don't know what on earth to type in!!! F14=(1+(F11*F12/12))*F9/F12 Also, how do I get it to check that all of the other cells are present and correct? Presume if one's...
  9. E

    open multiple files as defined on sheet?

    hi guys. kindly need your generous assistance for creating macro to open multiple files on particular folder. Whereas the file names should be opened are defined first on a worksheet. Then, i want to combine/merge the content of each file (all in sheet1) on different single sheet as summary. Is...
  10. S

    How to create a simple alternate line skipping macro in excel

    I've done a handful of macros in excel before, but it's been awhile and I'm kind of blanking. I'm essentially looking to have a macro that will insert a blank row between each other row (a list of names with information, and I want there to be spaces between). Then I want it to stop when it...
  11. S

    Need a macro

    I have two lists, both on separate sheets. They both contain ID numbers, but with different data in them. I want to know if there is a way to create a macro that will look up the id number in sheet 1, see if there is a matching one in sheet 2, if there is leave it alone. If there isn't I want it...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top