My spreadsheet has about 8 columns. Each column is totaled on line 8 under the heading. I add new entries to individual columns by inserting new lines on line 10, which moves everything down and keep...Show More
I want to make that every week my spreadsheet adds £300 automatically but if I want to adjust it I can always just insert a one-off amount. How do I do this?
I need VBA to input a formula =If(B9="E", SUM(ActiveCell.Offset(-B8,-2):ActiveCell.Offset(-1,-1)), "") in Cells (F2:F5000) I am getting an error when I try just putting that formula directly above into a cell in Excel. ___A_B_C_D_E_F 5___E___2_3 6___1__...
Join Date 02-04-2015 Location Dallas,Texas MS-Off Ver excel 2013 Posts 191 Automating Pivot Table after inputting data I am trying to automate the pivot tables in the spreadsheet so when I input new data in the 'data 3.31.17" tab the pivot tables can refresh and I wont have to ke...
Begin by setting up a basic income statement spreadsheet such as the one inexhibit 1. Of course, you can invent any numbers—just as long as you add the appropriate formulas to produce the totals for lines 6, 15, 22, 28 and 37. ...
{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:1446839"},"conversation":{"__ref":"Conversation:conversation:1446328"},"subject":"Re: Putting totals at top of column - inconsistent formulas","moderationData":{"__ref":"ModerationData:moderation...
My spreadsheet has about 8 columns. Each column is totaled on line 8 under the heading. I add new entries to individual columns by inserting new lines on line 10, which moves everything down and keep... Ken1122Not sure I can visualise exactly what you are describing, but you...
{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:1446839"},"conversation":{"__ref":"Conversation:conversation:1446328"},"subject":"Re: Putting totals at top of column - inconsistent formulas","moderationData":{"__ref":"ModerationDat...
the formula becomes SUM(E15:1005). This causes inconsistent formula errors and having to redo the formula every time I make an entry. Is there a way to lock the formulas so they don't change when new lines are inserted? What is the solution?
I am hoping someone can help. I am running out of time and well out of skill.The attached spreadsheet is a subset of a much larger one. ...