Copy and Paste Problem

[Guest]

Regarding the error I am having on excel. The spreadsheet contains many
worksheets. If I ctrl and f with all the worksheets highlighted I seem not
to be able to copy and paste into another sheet. If I go directly into the
worksheet and search then it copy and pastes fine.

 

[Guest]

ctrl-f is find/replace. Are you trying to find something, or copy it?

I think I know what you are asking though. Here's my guess.

Say you want all values "ABCD" in worksheets 1-10 to be "EFGH"
What I would do, is:
Select worksheets 1-10
ctrl-a (select all) on the visible worksheet
ctrl-h (find/replace) "ABCD" to "EFGH"
select the visible worksheet only.

All values on those sheets should now be correct.
You can also do this by row, column, or selected cels once you've selected
the desired worksheets. You can't do DIFFERENT cells on each worksheet
though, unless you select all.
Hope that helps.