LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
Posts: 3
Default Button linking to another cell and sheet

What I'm trying to build here is an automatic drawing simulation instead of giving out tickets and drawing them from a hat or drum.

Setup: I have 2 worksheets where Sheet1 contains a command button and will display results starting on row 15 (A15) while incrementing by 1 (A16) each time the command button is hit. The data which should be shown on these rows (A15, A16, etc) will be derived from Sheet2 which has one column of names (A1 thru 'end of names').

So far, I've been able to "randomize" the names on Sheet2 to receive 1 result (or pick) by using this formula and hitting F9: =INDEX(A:A,RAND()*COUNTA(A:A)+1)

My Questions:
1 - How can make the command button on Sheet1 perform the function of hitting F9 on Sheet2 and receive the result starting on row 15 - Sheet1?

2 - Instead of just receiving data/value from 1 column, is it possible to receive a row of data/values from let say, 4 columns (Sheet2 - A25 thru D25), and have this be populated starting on row15 - Sheet1?

Is this possible?

Please let me know if more details are needed. Many "thanks" in advance for your time and effort on this.
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
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 05:12 PM
linking pivot table data to a cell in other sheet sudip Excel Worksheet Functions 3 September 13th 06 02:34 PM
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Asked previously...can this not be done in excel simonsmith Excel Discussion (Misc queries) 2 May 16th 06 11:50 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM

All times are GMT +1. The time now is 02:34 AM.

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

About Us

"It's about Microsoft Excel"