Hi there,
I'm trying to add a formula into each blank row of my data set in column C. (see cell C5 on image, as an example of where the formula has populated, and cell C11 where it hasn't)
The formula in column C is a weighted sum product formula i.e. =($B3*C3)+($B4*C4)+($B5*C5), so this...
Hi Everyone
Probably about a month or 2 ago I was able to copy a few rows and insert them on my desired location multiple times. Does anyone know if this was just an update or a tick under some or another setting?
The rows copies has formulas in them thus the clipboard would not work for this...
Hi guys!
I have a problem! I have a cell with a number and I need to insert in a table that number of rows. If I have 5, I want to tell excel to introduce 5 rows, if I have 2 I want to tell excel to introduce 2. How can I do that with VBA and Excel? For example:
<tbody>
A
B
C
D
E
F
G...
I want to insert a new row with the existing formulas that I have in the current row. I want this row to be below the current row and I want it to insert when data in column A is changed from empty to a selection from a dropdown list. Can anyone help with this?
Please be patient with me as this is my first post.
I am looking for a macro that will do the following...
In tab B when I insert a specific 3 digit number (which resides in tab A, column B with full detail) into column A; I want it to pull the description associated with the number into tab b...
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.