same data on all sheets

I need to copy a row to all pages in a sheet on the same row number but i
don't want to use copy and paste function. Is there a way i can copy same
data on multiple pages or sheets in a workbook.


Thankx!

If you select all the worksheets together (i.e., if you want to copy onto sheets 2 through 5, click your mouse on sheet 2 tab, hold down Shift key, and then click your mouse on sheet 5 tab -- now all sheets should be selected).

You will need to use Copy/Paste, but if the data is to be copied on the same row on all sheets, you only need to do it once and it will paste onto all the sheets simultaneously.

is it possible with some formula or function?????

"LACA" wrote:

>
> If you select all the worksheets together (i.e., if you want to copy
> onto sheets 2 through 5, click your mouse on sheet 2 tab, hold down
> Shift key, and then click your mouse on sheet 5 tab -- now all sheets
> should be selected).
>
> You will need to use Copy/Paste, but if the data is to be copied on the
> same row on all sheets, you only need to do it once and it will paste
> onto all the sheets simultaneously.
>
>
> --
> LACA
> ------------------------------------------------------------------------
> LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381
> View this thread: http://www.excelforum.com/showthread...hreadid=502796
>
>