May 03 2021 01:06 PM
I'm starting a new workbook with 8 worksheets. Sheet 1 will be an information entry screen with many labels ranging from A1 to maybe A30. I will enter information into B1 to maybe B30. I want many of the other worksheets to auto populate in random cell locations from the info I enter into the Sheet 1, B1......locations. I believe in the random cells of the various Sheets an instruction is needed. I need to know that instruction format.
thank you
May 03 2021 01:47 PM
This all sounds so--oh, what's the word?--random. That's it! Random.
What you are trying to do is no doubt clear in your own mind, but hard to discern from what you've written. Maybe if you could give a bigger picture description here of what the setting is--i.e., what purpose is being served? for what kind of user or user community?--
And maybe even put together a sample workbook showing what you mean (without the formulas of course, since that's what you are seeking from us)...but what would sheet one look like actually (what's in column A, column B) and how random are the entries on the subsequent sheets? Does an entry from sheet 1 appear on only one of the subsequent sheets, on all of them, on all of them in no discernable (and therefore "random") pattern?
If this is for a game, or a test (to see how quickly subjects can find specific words)...whatever, it actually would help us help you if you provided more info. My questions are meant to elicit that more complete description; you should feel free to go beyond the questions I've asked.
May 03 2021 02:27 PM
SolutionMay 03 2021 07:42 PM
May 03 2021 02:27 PM
Solution