+ Reply to Thread
Results 1 to 4 of 4

select random cells from multiple sheets and copy

  1. 05-10-2014, 03:16 PM #1
    cfinch100
    cfinch100 is offline
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    select random cells from multiple sheets and copy

    hi
    im having problems I would like to select say 2 id from sheet1 and 2 names from sheet 2 randomly and copy to sheet3 ,to cells a and b,have seen various codes but none seem to fit the bill,any suggestions please
    cheers colin
    Attached Files Attached Files
    Last edited by cfinch100; 05-10-2014 at 05:44 PM.
    Reply With QuoteRegister To Reply
  2. 05-10-2014, 05:08 PM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: select random cells from multiple sheets and copy

    Hi C,

    Try this:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  3. 05-10-2014, 05:43 PM #3
    cfinch100
    cfinch100 is offline
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: select random cells from multiple sheets and copy

    hi
    that worked a treat thanks,ill try and mod for all other sheets I need ,many thanks
    colin
    Reply With QuoteRegister To Reply
  4. 05-10-2014, 06:24 PM #4
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: select random cells from multiple sheets and copy

    You're welcome and thanks for the rep!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] HELP: Select Multiple Cells From Different Sheets in Name Manager for Use in Charts
    By d247 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2014, 12:57 PM
  2. Select random rows from 2 or 3 sheets and display them in new Sheet
    By bhunkri in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2013, 03:46 PM
  3. [SOLVED] How do you protect multiple sheets while only allowing users to select unlocked cells?
    By mrssteelerhall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2013, 02:05 PM
  4. Random Row Select and Copy
    By xtiankmasajo in forum Excel General
    Replies: 4
    Last Post: 02-20-2013, 11:21 PM
  5. Copy formulas to adjacent columns - multiple cells and multiple sheets
    By swanseaexcel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-12-2011, 06:21 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1