Excel

[overthetop]

I need help with what I think should be a simple query. I have set up a cash book and managed to insert a formula to show a running balance, as at today's date and showing standard outgoings and incomings into the future. The formula in the Balance column is e.g. =SUM(G6+C5-D5-E5-F5). This works perfectly well until I have to insert or delete a row, so I then have to go to the row above the insertion and Autofill again down the Balance column to the end. I've looked through my excellent on-line course, which tells me how to do wonderful things, but I can't find an answer to this. So, in summary, the row numbers automatically update with Autofill, but it gets confused when I insert (or delete) a row. Help please!

[jeffa]

I've seen a way of doing this. IIRC, you need to use the formulae which return the row and/or column number of the current cell.

Something like this: http://dmcritchie.mvps.org/excel/offset.htm

[overthetop]

Thanks Jeffa, that's very helpful. Tomorrow I'll see if I can get to grips with the Insert Row macro - that would seem to do the trick, and it'll be worth it in the long run. I had been hoping for something more simple though (sigh). x

[overthetop]

Hi RugbyGuy. The interview was a long time ago and I can't remember exactly what I was asked to do. But I do remember that I wished I had read the instructions more carefully, because, with hindsight, it was pretty straightforward. So, my advice would be to take time to think about about the question. The best of luck with your interview.

[overthetop]

Neither of them cropped up in mine. I would remember because I could not have tackled either. That's not to say they won't crop up in yours. Depends on the job to be done I suppose. Good luck.