Creating a Summary Page of Selected Data Lines from multiple worksheets in same workbook

David, it's not exactly clear what you are trying to do. Could you attach an example of the "after" version of your code/formulas. That is, be specific about what you want to summarize where.

Greg

So, I'm envisioning a user entering the quantities of each product/service on each of the sheets, then, when complete, maybe clicking a "summarize" button on the Summary sheet, and the code will look at each sheet to determine where a quantity was entered, then pull the info for that row back to the summary sheet?

Maybe something like this? Note, I did not spend a lot of time on formatting, just recorded a macro to do the cell borders. It's pretty clear where I inserted the recorded stuff, so you should be able to record any formatting you want and paste it in.

Greg

Ok, I seem to have messed up the attachment, as when I download it I cannot get the macro to run eventhough it is in the workbook. Anyone have any ideas? Thanks.

Greg

Well, I did not do anything about that because that is a question you must decide. My thought would be to have a "Save" button, then export the summary, then clear it out. If you don't want to save it, you could simply delete the data rows. Either way, it's a simple matter to delete rows. You could record a macro deleting the rows, put it in a sub called 'Clear', then the first line of sub 'Summary' could be 'Call Clear'. Anyhow, let us know if you need more help.

Greg

Try this one...

*EDIT* One more thing: There is a line in there 'Debug.Print ItemCt'. You can either comment it out, or delete it. It does not really hurt anything, but it's only for displaying the value of the variable in the immediate window for testing. Also, I'm glad you figured out the clear part yourself. If you wanted to, you could put it in the same module as the other, just to make editing a bit more friendly.

No problem, I'm glad it works for you. When it comes to formatting, I don't much have a need to commit it to memory, so I always just record and alter. Try this: start recording a macro, then highlight a range, and format the borders using the border button, then stop recording. The macro will be stored in a new module probably, but when you look at it, you will notice it bears a striking resemblance to the formatting code in the summary sub. The only thing you have to change is to make the range variables. Anyhow, good luck to you.

Greg