Thanks for the script!

What if I simultaneously pull the sheet name into ColumnX for each record so
I can retain categorization?

"Ron de Bruin" wrote:

With a macro it is easy (I think)

Start here
http://www.rondebruin.nl/copy2.htm

If it is for a few cells check out
http://www.rondebruin.nl/summary.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"msnyc07" wrote in message ...
I have a large worksheet with about 200 sheets all with the same field layout.

I want to combine into one worksheet and pull the sheet name into columnX so
I keep the organization. Can this be done easily?
.