| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
result on a new sheet
In a micro ... I have given sample in the sheet 1. I generate random numbers on a ne sheet say sheet 2. Then I insert a new sheet(sheet3) and calculate mea from the data on sheet 2. When I run the macro next time , random numbers are generated on th sheet 4 , and on the sheet 5 it calculates the mean from the rando numbers on sheet 2. How is it possible that everytime I run a macro , it calculates th mean from the random nubers on the previous sheet ? TIA rsank -- rsank ----------------------------------------------------------------------- rsankh's Profile: http://www.msusenet.com/member.php?userid=187 View this thread: http://www.msusenet.com/t-187051260 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show formula result in another sheet | Excel Worksheet Functions | |||
| Result Sheet in a School | Charts and Charting in Excel | |||
| Can I annotate a formula result in Sheet 1 in Sheet 2 by Cell Addr | Excel Worksheet Functions | |||
| find result from two sheet | Excel Worksheet Functions | |||
| Naming a sheet from formula result | Excel Programming | |||
![rsankh[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
