help with Linking excel

[amanda]

hi,

i have spreadsheets for work which could have anywhere between 5 and 100
worksheets within. i am creating a worksheet at the end of the workbook which
takes information from all worksheet and puts it into the last one. is there
anyway to have this info from seperate worksheets automatically going in the
the Last worksheet with out having to put in all the coding? and secondly, is
there a way to set it up so that if a new worksheet is added then the last
spreadsheet will add a line and put in the new info.

i am hoping so.
Thanks in advance if anyone can help

 

[JLatham]

Short answer: this can be done, but it would take one or more macros (VBA
code) to do it. Excel sheets can't just up and add new formulas to
themselves, nor can they even detect that a new sheet has been added to the
workbook.

I'd be willing to try to help with this, but the logic for the code could
get a bit complex, depending on what needs to be done when new data is added
to existing worksheets, and what would need to be done when a new sheet is
added. If you're interested, get in touch with me via email to (remove
spaces)
HelpFrom @ jlatham site. com

Be sure and reference your post here, give a link to it if you can, and if
you can't, then be sure and tell me your username here (amanda) and quote the
content of the post again in the email.