Formulas rather than Hiding columns

[dannyjok1990]

Hi Everyone!

Im Just wondering if anybody could come up with a better method for what I'm trying to achieve,

I have two columns in a table calculating 'Sub-total' and 'VAT' the table columns are in columns that are hidden.

when create a new row in the table everything is fine, but if i decide i want to delete a row i can't because of the adjacent columns that are hidden. i have attached my spreadsheet if anybody would like to have a look, theres probably a better way of doing it but i just don't know

in the attached document i have unhidden the columns so its easy to see what I'm trying to do.

Any help would be much appreciated

[Olly]

Why do you have those two columns at all, if you want them hidden? There are no 'visible' cells which depend on them...

[dannyjok1990]

Hi,

the columns are calculating the 'VAT' and 'Amount' without vat (Sub-total) for the bottom of the purchase order in fields 'sub-total' & 'VAT'

thanks!

[Olly]

Of course - apologies, I missed that.

I'm not quite seeing the problem, though - even with columns F and G hidden, I can delete table rows?

[dannyjok1990]

Sorry, iv just tried it with a right click and delete table rows and yes it works,
the problem i was having was if i used the corner of the table to resize the table down then delete the data left behind manually i was getting an error. i didn't think to right click and delete rows..

me just being stupid i guess haha!

The next problem i have is keeping the section at the bottom as one complete section, so if i insert more rows than there is space on the table, everything keeps moving down one row at a time in the spreadsheet, and vice versa, if i fill the space with rows then delete them it moves the bottom section up. id rather the section moves completely on to a new page or stay where it is.. is there a way to do this?

I'm pretty new to excel and everything I'm doing is found on the net but its hard because theres so many ways to do the same thing!

Thanks Again!