Repeat tasks automatically to others sheets

Hello!
Is there some way to do a task in one sheet and automatically excell repeats in the others
sheets.
Example: I copy down one formula in sheet1 and the same formula is copyed down automatically in the others
existing sheets (sheet2, sheet3, sheet4)
With differents outputs because the inputs are different to.
Thanks

Yes that is not too bad to do but your description is kinda thin. Essentially
what you want is for your procedures to be written fairly generically and for
thos preocedures to take a sheet object as an argument, kinda like this...

Sub Test
call addtosheet(sheet1)
call addtosheet(sheet2)
end sub

Sub AddToSheet(byVal wks as Worksheet)
wks.range("A1").value = "Tada"
end sub

This is obviously oversimplified but it gives you a place to start.
--
HTH...

Jim Thomlinson


"pmarques" wrote:

>
> Hello!
> Is there some way to do a task in one sheet and automatically excell
> repeats in the others
> sheets.
> Example: I copy down one formula in sheet1 and the same formula is
> copyed down automatically in the others
> existing sheets (sheet2, sheet3, sheet4)
> With differents outputs because the inputs are different to.
> Thanks
>
>
>
>
> --
> pmarques
> ------------------------------------------------------------------------
> pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110
> View this thread: http://www.excelforum.com/showthread...hreadid=515877
>
>

Another solution, more simple (for me that are very green in vba)
is EXAMPLE:


In sheet 1
enter A1 and B1 some numbers for e.g. 6 and 5
now keeping down control key click the other sheets one by one (all the sheets are selected)
now in sheet 1 cell C1 type
=B1+A1
...


Thanks for the help

Another solution, more simple (for me that are very green in vba)
is EXAMPLE:


In sheet 1
enter A1 and B1 some numbers for e.g. 6 and 5
now keeping down control key click the other sheets one by one (all the sheets are selected)
now in sheet 1 cell C1 type
=B1+A1
...


Thanks for the help