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.


--
LACA
------------------------------------------------------------------------
LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381
View this thread: http://www.excelforum.com/showthread...hreadid=502796

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