Since you were honest about homework
just hold down the ctrl keyselect the desired sheetsenter someting on the
1st and it will be on all.
for all sheetsright click sheet taball sheets

--
Don Guillett
SalesAid Software

"David Smithz" wrote in message
. uk...
Hi there,

I have to have a crash course in setting up an Excel spreadsheet, so that
when data is entered on one worksheet it is duplicated across many other
worksheets in the same spreadsheet.

Under pressure I was asked how quickly I could do this, and have been told
to give an example very quickly.

I therefore wanted to ask, for someone with vb6 programming experience
(but no office macro experience) is this something easily achievable.
Therefore entering data into one worksheet, which will after entering
populate the data in many other work sheets.

Thank you for any input on this matter (any guidance to make it easy
welcome).

Dave.