Global cut and paste

[John Abernathy]

I have 5 cells in one worksheet that I want to copy to
all other cells that are in the identical position on 30
other worskheets within the same workbook. How can I do
that globally all at once? The 5 cells all reference
another worksheet like this: =Daily1!L92

 

[Dana DeLouis]

Hi John. To do this manually, select 1 area on your active worksheet at a
time. Hold the Ctrl key down and select the other sheets. Now, do <Edit>
<Fill> < Accross Worksheets...>
Basically, keep the main sheet out in front, and select the other sheets by
holding the Ctrl key. Select what you want copied across the worksheets.
To do this with a macro, just loop on each "area" that is selected. In a
macro, you are looking for "FillAcrossSheets"

HTH. :>)