vba code for copy specific data to another sheet

Originally Posted by HaHoBe

Hi, John,

using SaveAs and assuming that a user who indicates 2007/2010 as used Excelversion uses *.xls as Standard File is a bit off the target for me and maybe one reason for an error (maybe refer to Ron de Bruin on SaveAs from 2007 on).

Besides: building an array with unique names and applying the Autofilter while looping through the array could prove to be a far more elegant way.

Ciao,
Holger.

Good points Holger. I definitely will refer Ron de Bruins SaveAs.