Summary Sheet

[Guest]

Hi,
I've been trying to make a macro to create a summary sheet for a workbook I
have. I need it to run on definable sheets within the workbook, and also just
to pick out specific information along with headers. I need it also to
highlight when text is duplicated in a column range!

Does anyone have a starting point for me?

Cheers

 

[Guest]

Question: how much experience with VBA do you have? If you have much, you
can probably record a macro that does the basics of what you want done and
then modify it to work in a more robust fashion (like picking up information
from a varying number of rows instead of just he hard-coded rows that the
recorded macro code would contain).

Ron de Bruin has some information at his site that may give you a starting
point. A starting point for that would be here:
http://www.rondebruin.nl/summary.htm