LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lee Harris
 
Posts: n/a
Default Appending Random Results?

If I have quite a complex sheet set up that uses random numbers to lookup
into a series of tables and produce a series of results, with a
button/associated onclick event set up

what is the best (if any?) way to append various cell results to a new row
on a separate sheet, so that you have a running record of whichever cells
you've decided to record each time


so if I click the button and get random numbers 5, 11, 23, plus codes B, G,
plus text items "Bobs", "your" "uncle"

I'd want that storing in one row on a sheet, if I then clicked the button
again with new results, I'd want the new values on the next row down etc,

so "logging" the result of certain cells with each calculation

tks in advance


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
abdualmohsn almedrahe abdualmohsn ahmad Excel Discussion (Misc queries) 1 November 19th 05 06:32 PM
Random Sampling Andrea Excel Discussion (Misc queries) 2 November 11th 05 09:52 AM
VBA "Rnd" Function: Truly Random? TheRobsterUK Excel Discussion (Misc queries) 2 September 27th 05 04:50 AM
random number results mcmil Excel Worksheet Functions 5 June 6th 05 03:34 AM


All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"