perform the same calculation in several spreadsheets
Hello;
i have several sheets in a work book. the sheets names that i am intersted in using are 20, 25,30,40,45, 55..... . there are other sheets with names like 20S, 20R..... the ones that i want to apply the calculations in are the ones that have numbers only. i would like to be able to perform certain calculations in sheet 20, then perform the same calculation in sheet 25 and so on. how could i write the code for it? Thanks very much! |
perform the same calculation in several spreadsheets
If the sheets are formatted identically, you could select the sheets
and enter the formula. This enters the formula in all sheets selected. If that's no good, please describe your need with more detail. Dan |
perform the same calculation in several spreadsheets
On Jan 17, 11:32*am, dan dungan wrote:
If the sheets are formatted identically, you could select the sheets and enter the formula. This enters the formula in all sheets selected. If that's no good, please describe your need with more detail. Dan hello Dan, i wrote a code that will perform some calculations . i have several sheets in this book, and the names could be 20, 20s , 20R, 30,30s, 30R..... and so on. i want to execute the code i wrote inside all sheets that have have a name like 20,30,40,45,...... . i dont want to execute this code in sheets that has a name that include letters like 20s, or 20R, or 40s..... |
perform the same calculation in several spreadsheets
sub EveryCertainSheet()
dim ws as worksheet for each ws in worksheets if isnumeric(ws.name) then call YourMacro next ws end sub " wrote: On Jan 17, 11:32 am, dan dungan wrote: If the sheets are formatted identically, you could select the sheets and enter the formula. This enters the formula in all sheets selected. If that's no good, please describe your need with more detail. Dan hello Dan, i wrote a code that will perform some calculations . i have several sheets in this book, and the names could be 20, 20s , 20R, 30,30s, 30R..... and so on. i want to execute the code i wrote inside all sheets that have have a name like 20,30,40,45,...... . i dont want to execute this code in sheets that has a name that include letters like 20s, or 20R, or 40s..... |
All times are GMT +1. The time now is 04:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com