formula vba

  1. X

    Insert a formula in a Table via VBA

    Hey, So i have just posted a thread about how to insert a formula via VBA in the desired column of my Table. The answer i got worked perfectly fine. But as soon as i wanted to replace the original formula with my formula it stopped working and i guess i know why. the code which originally...
    • Xalova
    • Thread
    • formula table formula vba help help vba vba vba formula in table
    • Replies: 1
    • Forum: Excel Questions
  2. R

    VBA UPDATE FORMULA EXACT WITH INPUT TYPE AND POP UP SEARCH BASED CRITERIA

    Dear All Master, 1. I want the exact formula in the vba code in column B in the sheet "INPUT BOJ" & "INPUT M18" because using an array formula makes it slow because the data to be input is about ten thousand rows. You can see an example of an array formula that I created in column B. So I want...
    • roykana
    • Thread
    • code vba event vba exact formula vba formula vba
    • Replies: 28
    • Forum: Excel Questions
  3. C

    How to automatically copy data in multiple spreadsheet

    In multiple spreadsheets, in ALL cells in "F2" in "workbook 1". How can I copy ALL cells in "F2" values and paste it VERTICALLY or downward column into a new "workbook 2", "worksheet1" in cell "B2" See example below The above worksheets is in "workbook1". All worksheets have data in...
  4. K

    Automation Using Macro

    I am looking for a Macro that will make the process in the document as simple as possible. Its currently a lot of manual work and I would like to automate the process. The document involves a two tables in a Matrix form input Volumes and Budget and an out Actuals. In the same document we have...
    • Kusini
    • Thread
    • automation formula vba macro and formula new threads
    • Replies: 4
    • Forum: Excel Questions

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