formulas macros

  1. B

    VBA - reference a cell for sheet name for a macro

    Hi all - I'm trying to get a macro to copy sheets from other workbooks based on inputs in a "setup" tab. The sheet names are the same for each workbook, and I would like the VBA formula to reference a single cell input by the user. For example, my current formula is...
  2. C

    Making a table Macro More efficient

    Hey everyone I'm using this code to make a table for a graph to update by selection of data but I'm using a very inefficient method to do it. it works but I am wondering if there is a better way. Range("B22").Select ActiveCell.FormulaR1C1 = _ "=(COUNTIFS('Hidden graph...
    • cimajc17
    • Thread
    • formulas in a cell formulas in charts formulas macros ranges areas copy table
    • Replies: 0
    • Forum: Excel Questions
  3. oldeirish

    Dynamic Range in VBA and Auto Deleting Unwanted Imported Data By Name

    Hi, I have created a Macros to input data (from external source) through recording a macro. Since it is a weekly update, the data varies in size. How do I change the area in which the data can still be totalled and also delete lines that begin with "Total" instead of "Company" name? Sub...
    • oldeirish
    • Thread
    • dynamic range formulas macros macros auto delete vba - help
    • Replies: 0
    • Forum: Excel Questions
  4. J

    Reverse Vlookup

    could there to reverse vlookup like instead of getting a number out of the list it will take the number in the list the number that i want in the list is in J3 and the list in B4:D23 could there be a way to take the number in J3 and scroll down the list looking for a certain name then when find...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top