You need to be more specific about what you're trying to accomplish... For
what little you've disclosed regular copy/paste will work, but storing
duplicate copies of the same data on multiple sheets [or in multiple
workbooks] is redundant & inefficient. I'm sure you're clear in your own
mind what you're trying to do, but these one-liners do not effectively
convey what you're thinking
Also, it's fine to post multiple questions & use separate messages for each,
but it's best if they all be posted as separate NEW messages with unique
SUBJECT content. Otherwise they get clustered into the same thread which
becomes confusing for those trying to reply or follow the conversation.
Regards |:>)
Bob Jones
[MVP] Office:Mac