Looks a lot like what I have. I took some coding from another workbook and
modified it, so maybe your site is where it originated (I think I have a book
at home with an author by your name. Is that you?). After this though the
worksheet is manipulated to gather the information into a coherent form, and
some calculations are done with it. I'd like this process to be kicked off by
changing a percentage in a specified cell (all that begins in the next set of
instructions), and to make that work I need to gather this information
without deleting the sheet, I guess, by having a change event in the coding
of the worksheet. My thought was just to clear the information existing in
the worksheet and then gathering what I needed from the other worksheets. I
was trying not to make my original post too long.

Ron de Bruin wrote:
Is this not working for you then ?
http://www.rondebruin.nl/copy2.htm

Sorry, I'm sometimes not very good at explaining. things. I'd like to copy
the data from cells L11:V93 from every other worksheet in the workbook into
[quoted text clipped - 10 lines]

Application.EnableEvents = True

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200905/1