Yet another Excel Question!

[libero]

I have opened a can off worms getting involved with spreadsheets at work and am in way above my head with regard to excel, wanting it to do so much on the one sheet and not having the brains or knowhow to do it..... thats where you lot come in.

 

Its a sheet to track welds that are complete/not complete etc and will form the basis of a pro forma to be generated for every drawing that is done.

 

I have all the formulas the way I want them and its adding up how I want it.

 

Sorted.

 

The only problem is that when its finished it goes to so many different people to use and not just me. Information would be input from 3 different departments, hence I need it to be all singing all dancing as regards to generating the info I need so I dont have to go back over each and every derivitive of the sheet.

 

If anyone should insert a row (one dept would need to) the formulas have to be manually dragged down so is there anyway it can be done automatically for the selected columns when a new row is inserted, instead of asking them to do it and no doubt feckin up the sheet????

[Senrab_nhoj]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[PhilM]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited October 6, 2010 by philmatthews

[libero]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here