M
markythesk8erboi
HI ALL!!!
J25...1...K25...(randbetween(1,1000000))...
J26...2...K26...(randbetween(1,1000000))...
J27...3...K27...(randbetween(1,1000000))...
Now, on sheet3 I would like to create the same table only automatically
sorted by column K
Oh, and it would be nice if after ever change on Sheet1 (which causes the
randbetween function to act; changing the number) Sheet3's table will KEEP
the original value assigned to the cell.
ex. and desired outcome:
J25...1...K25...842643... (please note that once a cell has been changed
J26...2...K26...520924... all numbers in column K will change as well)
J27...3...K27...683921...
Sheet3's table would be:
J25...2...K25...520924...
J26...3...K26...683921...
J27...1...K27...842643...
ANY IDEAS???
J25...1...K25...(randbetween(1,1000000))...
J26...2...K26...(randbetween(1,1000000))...
J27...3...K27...(randbetween(1,1000000))...
Now, on sheet3 I would like to create the same table only automatically
sorted by column K
Oh, and it would be nice if after ever change on Sheet1 (which causes the
randbetween function to act; changing the number) Sheet3's table will KEEP
the original value assigned to the cell.
ex. and desired outcome:
J25...1...K25...842643... (please note that once a cell has been changed
J26...2...K26...520924... all numbers in column K will change as well)
J27...3...K27...683921...
Sheet3's table would be:
J25...2...K25...520924...
J26...3...K26...683921...
J27...1...K27...842643...
ANY IDEAS???