So i have a worksheet and columns G-R contain formulas that auto-fill the spreadsheet based on the data entered in columns A-F. It used to be static worksheet with no formulas and I would cut/past to add new rows where I want them and remove rows when I'm done with them. But now that I have added the formulas when I cut/paste the cells in A-F, or remove a row, it changes the formulas in the cells to the right. I can just go in and drag the formulas own to fix it, and copy/paste doesn't mess with them. But I would like to make the right side easily adjustable so anyone can get in and add information. Should I make a table on the rows I want adjusted? or is there a way I can get around that so that its a little easier to adjust the information in A-F?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to make rows removable without messing with formulas?
- Thread starter greyland
- Start date
RasGhul
Well-known Member
- Joined
- Jul 15, 2016
- Messages
- 797
- Office Version
- 365
- Platform
- Windows
If you convert your data set to an excel table and use convert your formulas to table referencing, you can add and remove rows from the data set and the calculated columns will dynamically calculate.
Lookup excelisfun table feature.
I would test this on a sample copy of your workbook;
Lookup excelisfun table feature.
I would test this on a sample copy of your workbook;
Upvote
0
