# Inserting a row that will make formulas follow

1. ## Inserting a row that will make formulas follow

Hi,

I have an Excel Worksheet of which I made a simple demo of it here. ExcelForum.xlsx.

I'll use the Excel Worksheet I attached as a demo to guide you through my problem.

There is three rows. 1,2,3. In the first cell of the row, we have the row number.
The second cell contains a value (which is normally determined by multiple if statements).
The third cell contains another value like the cell to his left (again, determined by if statements in the real Worksheet).
The fourth cell is to be checked if the row is assign to the column a.
The fifth cell is to be checked if the the row is assign to the column b.
The seventh cell is to get the total of each rows.
The eigth cell is to determine if the row is assigned to a (if the column a is checked).
The ninth cell is to determine if the row is assigned to b (if the column b is checked).
In the row "total", we have the total of the column a and b (Sums) which comes from the same row but from the seventh and the eigth column. There is also an if statement to get the total of all the values in the seventh cell ( the total of each rows) crosschecked by the total of the columns a and b.

Question : How do I instert a row to this table and that this row as the same formulas every rows has ? In other words, how do I insert a row that does not affect the already in place formulas but also get's the same formulas for it's own row number ?

Thanks,
OUO  Register To Reply

2. ## Re: Inserting a row that will make formulas follow

you mean like this, see the green cells.

just copy the data to the cells below.  Register To Reply

3. ## Re: Inserting a row that will make formulas follow

Try converting the table to Table first (Insert tab> Table). Then insert a row. The formulas should stay? If not, which formulas are not. Tell us what the formula was before you entered the row and what it was after you entered the row.  Register To Reply

4. ## Re: Inserting a row that will make formulas follow

It looks like that is what I am looking for indeed oeldere. That being said, it is not for me to use, it is for someone else therefore I would like to try to get it the simpler for them so they just it insert and it works. Something can do that?  Register To Reply

5. ## Re: Inserting a row that will make formulas follow

I just inserted a row.

After that I copied the formula in N9, O9 en P9 down to the last row.  Register To Reply

6. ## Re: Inserting a row that will make formulas follow

Alright, since that works, I'll get the person to do that instead. Thanks oeldere.

Thanks to you too ChemistB, I tried your solution but the formulas weren't following. (Can see it here :ExcelForum2.xlsx)  Register To Reply

7. ## Re: Inserting a row that will make formulas follow

You're welcome. We appreciate the feedback!

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.  Register To Reply

8. ## Re: Inserting a row that will make formulas follow

Within the table, the same formula needs to be on each row.
So, in your example, first I converted back to range.
Made sure that the formulas are consistent in each row,
Then selected A30:P36 (included 1 header row, didn't include grand totals). Insert > Table> Table has headers.
Then right clicked in D35, Insert Rows above
This row has formulas. See attachment.  Register To Reply

9. ## Re: Inserting a row that will make formulas follow

Your solution works too ChemistB with a simple click with the mouse. Thanks.

Both solutions works.

1-Oeldere : Insert a line. Copy the upper line, Paste it into the new line and change the data.
2-ChemistB : Convert your data into a table. Right-click the cell you want, Insert -> Row. Formulas followed.

Thanks to both of you, future readers will be able to choose the one that fits their needs best.  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 