I would not say "cannot be done" about anything in Excel. It is amazing
what some perople can achieve. My perception of your reqirements are
currently very scant in detail - you want to copy data fifty rows at a time
to other sheets; copy paste does not do what you wish. If you describe in
more detail what you need and your general aim in doing this, perhaps your
problem may be relatively easy to resolve? Perhaps a simple macro will
automate a task for you? Perhaps there is an alternative solution?


--Lil




?B?b2NlYW4=?= wrote in
:

Thank you. I get the feeling that what I want to do is not possible.
It looks like my only option is to copy and paste, but I wanted to
tell excel to put a certain range of data on each tab. For example,
ask excel to put my 100 rows of data I have already entered onto one
tab and so on. Thank you for your help.