Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy same formula to all worksheets in a workbook
Hello guys!
I have a table with some formulas saved in workbook "A". Once a month, I receive workbook "B" and it has several worksheets in it (sometimes almost a thousand). I need to copy the table with formulas from workbook "A" and paste it into every-single-worksheet in workbook "B". In the same cell address (C25 for example). As of today, I copy the table and then I go to each worksheet to paste it but I am pretty sure there is a way to do it with a macro or a instruction and save me all that pasting over and over and over again... :S as always, any and all help will be highly appreciatted! JB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy same formula to all worksheets in a workbook
Copy the formula. from workbook A
In workbook B right-click on first sheet tab and "Select all sheets".. Paste the formula to C25 on active sheet and will be done to all sheets. You can copy/paste the entire table range at one go if you want. DO NOT FORGET to ungroup the sheets when done. If you screw up, close the workbook without saving. Better yet............practice on a copy of the workbook. Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 15:32:01 -0800, JABAgdl wrote: Hello guys! I have a table with some formulas saved in workbook "A". Once a month, I receive workbook "B" and it has several worksheets in it (sometimes almost a thousand). I need to copy the table with formulas from workbook "A" and paste it into every-single-worksheet in workbook "B". In the same cell address (C25 for example). As of today, I copy the table and then I go to each worksheet to paste it but I am pretty sure there is a way to do it with a macro or a instruction and save me all that pasting over and over and over again... :S as always, any and all help will be highly appreciatted! JB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheets within a workbook | Excel Discussion (Misc queries) | |||
macro for copy data from all worksheets of a workbook to single sh | Excel Discussion (Misc queries) | |||
how to copy only values and formats of worksheets to new workbook | Excel Worksheet Functions | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
How do I copy multiple worksheets into a new workbook? | Excel Worksheet Functions |