+ Reply to Thread
Results 1 to 2 of 2

Formula to link other worksheets in Randomizing formula ...INDIRECT RANDBETWEEN

  1. #1
    Registered User
    Join Date
    02-08-2012
    Location
    Australia
    MS-Off Ver
    Excel 2012
    Posts
    2

    Formula to link other worksheets in Randomizing formula ...INDIRECT RANDBETWEEN

    Hey newbie here.

    I am working on random phrase generator at the moment and i need a little help.

    At the moment i have been using the formula ' =INDIRECT("A"&RANDBETWEEN(1,10))&" "&INDIRECT("B"&RANDBETWEEN(1,10))&" "INDIRECT("C"&RANDBETWEEN(1,10))&""

    so in A1-A10 i would have names like Jack, John, Joe, etc
    in B1-B10 i would have words like runs,walks,crawls,jogs
    in C1-C10 i would have words like quickly, slowly, fast etc

    At the moment they are all in the same spread sheet and takes up a lot of room and creates clutter

    I wanted to create new sheets so 1 sheet is specifically for the words in A, one for the words in B and so on so forth

    Can anyone help me in being able to have the formula on the first sheet by itself and all the other data in seperate sheets?

    Ive been searching on how to do it but its all like a foreign language to me. So far i figured it would be like =sheet2! INDIRECT("A"&RANDBETWEEN(1,10))&" "sheet3! INDIRECT("A"&RANDBETWEEN(1,10))&" etc

    so at later time i could add more words to each one

    Thanks

  2. #2
    Registered User
    Join Date
    02-08-2012
    Location
    Australia
    MS-Off Ver
    Excel 2012
    Posts
    2

    Re: Formula to link other worksheets in Randomizing formula ...INDIRECT RANDBETWEEN

    solved it. i was putting Sheet2! before INDIRECT instead of after

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1