Good with Excel, can't be too much different. But if Griz has actually used it, then he would be the better resource.
Maybe I can tag along on this thread? Got a problem with my worksheet not putting my formulas in when I enter data in a new row. I have set up other worksheets similar to this and haven't ran into this. The SB Paid and the VAR columns have formulas that are working right. But when I insert a new row above my Totals to enter new data the formulas don't work in the new row, and then also my SUM doesn't add my new total. I think I can post a screen shot Thanks Gary
For the totals, what is the formula in the cell? It should be =sum(O8:O9) if it's just =O8+O9, it won't automatically include the new line. For the VAR & SB, you'll probably have to drag down the formula. If you click on the cell above it, hover the pointer on the bottom right corner, a + should show up, click and drag down. Sent from my SM-G930V using Tapatalk
Had the right formula for the totals. Basically what I want to do is to click on row 10 hit insert and be able to insert my data with the last 2 columns being calculated along with the totals without having to drag or copy the formulas. I have an A/R sheet that I set up that does it. I am sure I am just doing something stupid on this. Gary
Instead of adding the row at the very end, try adding it between the two established rows. I always leave a few rows at the end, until the final draft, so adding rows is easier. Sent from my SM-G930V using Tapatalk
No, if its calculating the right way, should be good. Instead of dragging it down, you could double-click on the "+" and it will fill down to the end of the column. All my experience is with excel, but I'd imagine they're the same. Sent from my SM-G930V using Tapatalk
I think I had tried that early today, I will try it again tomorrow at work.Just on laptop now and just don't feel comfortable on it! Thanks Gary
Sorry fellas I forgot I started this thread...... So much else going on here. I found my office 07 discs finally. I have lost my office touch so to speak. Grizz helped me with what I needed done. Keep this one alive I bet a lot of people will end up chiming in here on open office and libre office for help.
