select random cells from multiple sheets and copy

**cfinch100** · 05-10-2014, 03:16 PM

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

**xladept** · 05-10-2014, 05:08 PM

Hi C,

Try this:

Please Login or Register  to view this content.

**cfinch100** · 05-10-2014, 05:43 PM

hi
that worked a treat thanks,ill try and mod for all other sheets I need ,many thanks
colin

**xladept** · 05-10-2014, 06:24 PM

You're welcome and thanks for the rep!

select random cells from multiple sheets and copy

LinkBack

Thread Tools

Rate This Thread

Display

select random cells from multiple sheets and copy

Re: select random cells from multiple sheets and copy

Re: select random cells from multiple sheets and copy

Re: select random cells from multiple sheets and copy

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] HELP: Select Multiple Cells From Different Sheets in Name Manager for Use in Charts

Select random rows from 2 or 3 sheets and display them in new Sheet

[SOLVED] How do you protect multiple sheets while only allowing users to select unlocked cells?

Random Row Select and Copy

Copy formulas to adjacent columns - multiple cells and multiple sheets

Bookmarks

Bookmarks

Posting Permissions