Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to populate many worksheets in a workbook
how to populate many worksheets in a workbook.
I have a 15 workbooks with 30 sheets each and i want the same formula in the same cell in all 450 sheets. eg =counta(d9:d5000,"*") in cell aa2 in each work sheet. I don't mind putting it in 15 times but hopefully not 450 times :) Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to populate many worksheets in a workbook
You will have to do this in each file. Select the first sheet - scroll to
the last sheet. With the SHIFT key pressed, select the last sheet. Now all sheets will be grouped. Add you formula to the active sheet and it will be added to all selected sheets. Right click on a sheet tab and ungroup. -- Damon Longworth 2008 US East Coast Excel / Access User Conference Atlantic City, New Jersey - Sept 24-26, 2008 www.ExcelUserConference.com/ "chrisk" wrote in message ... how to populate many worksheets in a workbook. I have a 15 workbooks with 30 sheets each and i want the same formula in the same cell in all 450 sheets. eg =counta(d9:d5000,"*") in cell aa2 in each work sheet. I don't mind putting it in 15 times but hopefully not 450 times :) Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to populate many worksheets in a workbook
To select multiple sheets, click on the tab for the first one, then
Shift_click on the tab for the last one, then you can do what you want in a cell on one and it will do it on all the sheets you've selected. Remember to click on the tab for one sheet afterwards to ungroup them for further edits. If the sheets are not contiguous, use Control-click, not Shift-click. That will deal with the 30 seeets in one book, but I don't know of a way of doing it on multiple books. -- David Biddulph "chrisk" wrote in message ... how to populate many worksheets in a workbook. I have a 15 workbooks with 30 sheets each and i want the same formula in the same cell in all 450 sheets. eg =counta(d9:d5000,"*") in cell aa2 in each work sheet. I don't mind putting it in 15 times but hopefully not 450 times :) Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to populate many worksheets in a workbook
A simple way to do it is open eachright click on a sheet tabselect all
sheetsenter your formulaselect one sheetsave and close. Of course, you can use a macro to open eachthen a for each loop for each worksheet. -- Don Guillett Microsoft MVP Excel SalesAid Software "chrisk" wrote in message ... how to populate many worksheets in a workbook. I have a 15 workbooks with 30 sheets each and i want the same formula in the same cell in all 450 sheets. eg =counta(d9:d5000,"*") in cell aa2 in each work sheet. I don't mind putting it in 15 times but hopefully not 450 times :) Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to populate many worksheets in a workbook
Thanks
That has saved me a lot of time :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto populate one worksheet from other worksheets | Excel Worksheet Functions | |||
populate multiple worksheets in one workbook | Excel Discussion (Misc queries) | |||
2 Workbooks and 6 Worksheets - Need to Populate 1 Workbook | Excel Worksheet Functions | |||
how to auto populate full worksheets | New Users to Excel | |||
How do you populate one spreadsheet from multiple worksheets in a. | Excel Worksheet Functions |