Excel Experts Arise!

[SavageHoutkop]

Errr, ok, what is your spreadsheet doing then?

 

[longers]

I haven't got it here but it seems to be missing the formula in some of the cells.

I've deleted, moved and inserted rows but not columns over the last few months and it doesn't add some of the cells to the running total in the right hand column. I can sit and manually add them in but it just takes a wee bit longer than it should.

It's no biggie but would help my tired monday am brain out a bit.

 

[SavageHoutkop]

sounds like you should just edit the formula in the cell that has the 'running total'.
(if it's a formula, that is).

 

[Madcyclist]

Might be an idea to change the formula to a sumif value>o, deleting and inserting rows won't affect it then.

 

[weevil]

I really am underknowledged about Excel...

But highly skilled in word fabrication

 

[longers]

But highly skilled in word fabrication

I'm afraid I can't take credit for that. I think a paramedic used it on here some time ago.

I'll have a go at editing the running total column, I've only ever used it for making plain tables.

 

[Shrimp_Stu]

sent me a PM for my email address - i've been revisiting some old vba code this week so its still fresh in my mind - i'm going out in a mo for tenpin bowling but should be able to take a look tonight for you.

 

[Norm]

Did anyone find out what Dave5n's problem was?

 

[longers]

The specific one or just in general?









Sorry Dave

Many thanks for the kind offer Stu but I'll have a go myself, it's going to be quite basic and means I can legitimately sit down for an hour and clock it on my new improved timesheet as "paperwork".

 

[fossyant]

Longers, any trouble, give me a shout.

Just check cells and ranges. - I'd also advise using another formula to double check....

Spreadsheets are terrible, unless you make sure you double check, you can make massive errors, especially when they get very complicated.. Bit of a guru here, but we once had a QS on a big £200 million job make a huge cock up on his spreadsheet - talking millions under claimed................. fortunately, it was early in the job, so could correct the error before the final claim.

 

[Norm]

That's a QS for you.

 

[vernon]

I have a spreadsheet that won't behave and I need help.

Please.

Does it respond to discipline?

 

[fossyant]

That's a QS for you.

Well exactly..... double or triple check calculations folk...........