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

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

 

[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

 

[Ron de Bruin]

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]

Thanks for update Ron.

Gord