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.

"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.
--
David Biddulph

How do you select several Workbooks at a time?

--
AP

"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.
--
David Biddulph

"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