How do I set an auto send button in Excel?〈

J

j a houghton

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?
 
G

Gord Dibben

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
 
Top