Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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..... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I perform calculation within IF statement? | Excel Worksheet Functions | |||
Perform a calculation on same cell across many worksheets | Excel Worksheet Functions | |||
How to perform matrix calculation in excel? | Excel Discussion (Misc queries) | |||
comparing two columns & then perform a calculation | Excel Worksheet Functions | |||
perform calculation only if current time is after 10 am | Excel Worksheet Functions |