Adding cell and preserving formulas

Question

so I am using excel and have cells going top to bottom and left moving to the right every week. What I am trying to do is the next week when I add a column to preserve the cell formulas and settings with out having to change it every week. The biggest issue is some of the cell have formulas to pull totals to a second spread sheet and need to save these in a manner betting the copy and pasting them before i add them.

Answer 1

If you refer a cell A1 from other cell C1, you can insert rows formula will adjust. But if you use cell Address A1:C10, say for SUM and then insert a column within A:C, excel will adjust cells to A1:D10 but if you insert after A:C, excel will not adjust.

Say you have used column B1:Z25 and total in AA then it will not work. Best is keep one column blank. In This case put formula As B1:AA25 in AB column. The Column AA will remain blank. Now when you want inserting column, do that by selecting AA column. The formula will adjust

Answer 2

Were you able to resolve this issue?

Kevin

Answer 3

https://docs.google.com/spreadsheets/d/12obVBS7g6p640xr8lK9qlt96\_QrFN4u0jogCqB8rpIU/pub?output=pdf

Answer 4

https://docs.google.com/spreadsheets/d/12obVBS7g6p640xr8lK9qlt96\_QrFN4u0jogCqB8rpIU/pub?output=pdf

if you look at the sheets at the bottom. I have the stores I order and each week i have to insert 2 new cells for new inventory and and new order. In the order column i have the formula to push it to that store order sheet and place it where it needs to go and in the b column I have it set to put it in fractions # ??/?? and when i add cells that goes away also. Any help would be great thank you.

Answer 5

You can do what you want. Many Excel worksheet functions ignore blank cells so you can include columns not yet used and the functions will still work. You can also use OFFSET to move a reference left/right and/or up/down any number of rows. Can you post the workbook or provide more details?

Kevin