Hi Everyone,
I have this following table in a protected excel sheet which consist of formulated and user defined cells.
<colgroup><col span="4"><col span="2"></colgroup><tbody>
Date
Invoice
Party
Amount
Tax
Gross
User defined
User defined
User defined
User defined
formula
formula
</tbody>...
My goal is to insert a dynamic amount of rows to a table. The number of rows I need to insert will be the difference of rows from columnA on sheet1 to the number of rows in columnA on sheet2. I am assuming creating a function within my macro will be the best way to go about this.
I appreciate...
Hi, I'm a dunce in Excel, but actually managed to insert an "average" formula, though would like to add more data above it, to average more cells.
If this is answered in another thread/post here, feel free to send me its link. I was unable to find it.
I saw something on another site talking...
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.