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?

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?

I update the page yesterday/today Gord
I create seperate pages and add a file with the code so you can test it

--

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




"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
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?

Thanks for update Ron.

Gord

On Tue, 7 Apr 2009 22:18:45 +0200, "Ron de Bruin"
wrote:

I update the page yesterday/today Gord
I create seperate pages and add a file with the code so you can test it