+ Reply to Thread
Results 1 to 2 of 2

Lookup column and copy/paste as values

  1. #1
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2013
    Posts
    177

    Lookup column and copy/paste as values

    Hello all,
    I have a list box in sheet 'Menu' cell D7 used to select a class code, I want to paste the list of student names from the sheet 'Classlists' to the sheet 'Feedback' starting in cell B2.

    The list box looks up the class codes in the first row in sheet 'Classlists'.

    I ideally need it to paste as values so not to affect formatting.

    File attached. Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2013
    Posts
    177

    Re: Lookup column and copy/paste as values

    Can anyone help with this ?

+ 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