|
Posted to microsoft.public.excel.misc
|
|
|
Pasting a formula in many different workbooks
"Ardus Petus" wrote in message
...
"David Biddulph" a écrit dans le message de news:
...
"Playa" wrote in message
...
I have a workbook with a formula in it and I want to place the same
formula
in 27 other workbooks. The formula will be pasted in the same cell for
each
workbook. Is there a quick way to do this or do I have to copy and
paste the
formula one at a time in every workbook?
Thanks in advance.
Select all the workbooks, then put your formula in the relevant cell of
the workbook that's visible, and it should appear in the others.
How do you select several Workbooks at a time?
Sorry, I was thinking worksheets, not workbooks.
--
David Biddulph
|