same data on all sheets

C

create_share

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!
 
L

LACA

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.
 
Top