Darren

Have you given any thought to "linking" cells in Sheet2 to Sheet1?

On Sheet2 in a cell enter =Sheet1!A1

Now, whenever you change A1 on Sheet1, Sheet2 cell will update.

Gord Dibben Excel MVP

On Tue, 20 Jul 2004 14:05:38 -0500, "Fernando Ortiz"
wrote:

Hi Darren

Try this:

Select a few sheets holding ctrl + click in the sheets labels, after this,
you can insert data in tha both sheets. just only entry data in the
activesheet.

Regards,

Fernando Ortiz

"Darren" escribió en el mensaje
. com...
Has anyone got any Idea how I can insert data into a range that spans
two worksheets with one command. At the moment I need to select each
worksheet and insert the data rather than have the data inserted
without selecting the worksheet.

I hope this makes sense.
Darren