Jump to content
By fans, for fans. By fans, for fans. By fans, for fans.

Yet another Excel Question!


libero

Recommended Posts

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. :bleh:

 

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????

Link to comment
Share on other sites

Excel doesn't have a native event for the insertion of a new row as far as I'm aware, so if you were going to do it using a macro, you'd need a way of instigating that macro.

 

The best way of doing this is using the list/table functionality as Senrab_nhoj says. It's called List in Excel 2003 and older, or table in Excel 2007+. Have a read of the following article and come back if you're not getting it. I always find it helps stuff sink in if I try it myself before someone tells me how to do it.

 

http://blogs.msdn.com/b/excel/archive/2005/10/25/tables-part-1-working-with-tables-of-data.aspx

Edited by philmatthews
Link to comment
Share on other sites

Excel doesn't have a native event for the insertion of a new row as far as I'm aware, so if you were going to do it using a macro, you'd need a way of instigating that macro.

 

The best way of doing this is using the list/table functionality as Senrab_nhoj says. It's called List in Excel 2003 and older, or table in Excel 2007+. Have a read of the following article and come back if you're not getting it. I always find it helps stuff sink in if I try it myself before someone tells me how to do it.

 

http://blogs.msdn.com/b/excel/archive/2005/10/25/tables-part-1-working-with-tables-of-data.aspx

 

I think I may have cracked it, dont know how, not sure why, dont understand it ,but your link certainly set me off on the right road.....I think?????

 

Thanks a lot Phil, the table option was the way to go, I will faff about with it at work tomorrow and try to understand how/ why it works for future reference.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...