auto expand table foumula

  1. L

    Allow Copy and Paste into the table with protected formulas in auto expand tables

    Hi, I have A:E columns. Column C and Column E are the ones who does have formulas and should be the protected columns. I would like to allow the user to copy and paste (aside from manually typing the inputs) any data into new rows and tables should still auto expand including the formulas. In...
    • laedays
    • Thread
    • auto expand table foumula excel macro table tables vba
    • Replies: 0
    • Forum: Excel Questions
  2. N

    Power Query Table - Countif formula not auto expanding with the size of table

    HI, I have a excel file in which I pull data from SQL into a Table by name of PURCHASEDATA.. This data keeps changing and I do a refresh every day.. From this PURCHASEDATA using power query, I generate four more tables containing specific smaller subsets of data. One of the resultant table...

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