Assuming "12 pages" means 12 worksheets and you want to copy specific data
from sheet1 to each of the other 11 sheets

See Ron de Bruin's site for code to copy data using autofilter.

http://www.rondebruin.nl/copy5.htm


Gord Dibben MS Excel MVP

On Tue, 7 Apr 2009 08:38:02 -0700, j a houghton <j a
wrote:

If I have a 12 page book and want to tranfer or copy figures to the other 11
sheets how do I do this without doing them one at a time?