Pasting a formula in many different workbooks
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. |
Pasting a formula in many different workbooks
"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 |
Pasting a formula in many different workbooks
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 |
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 |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com