+ Reply to Thread
Results 1 to 4 of 4

Problem with lists

  1. #1
    Registered User
    Join Date
    10-31-2012
    Location
    Sheffield
    MS-Off Ver
    Excel 2007, 2010
    Posts
    8

    Exclamation Problem with lists

    Hi,

    I have a spread sheet with a number of lists, if a cell was copied and then I immediately access a list, the copied data is populated in the list - is there a way to stop this?

    Thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Problem with lists

    Hi,

    Impossible to understand what you're getting at unless we can see the workbook in question. Upload it and tell us precisely what you are doing step by step, what happens and what you expect to happen, with references to specific cells and/or sheets.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-31-2012
    Location
    Sheffield
    MS-Off Ver
    Excel 2007, 2010
    Posts
    8

    Re: Problem with lists

    Please see attached,

    if you copy an entry from A5 and then try and select an item from a list (I5 as an example), the clipboard data is saved, not the dropdown item.

    Gary
    Attached Files Attached Files

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Problem with lists

    Indeed it is.

    Seems like it's the 'Enter' action which overrides any validation selection, and the default first entry for the Enter is the clipboard item.

    Just as a matter of interest why do you need to copy a cell and then choose from an unrelated validation list without first cancelling the clipboard copy cell.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. drop down lists problem
    By moshmoshon in forum Excel General
    Replies: 2
    Last Post: 07-14-2007, 05:39 PM
  2. Problem with Lists
    By all4excel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2007, 10:04 PM
  3. Lists Problem
    By Tom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2006, 08:40 PM
  4. Problem with lists
    By TooBaaaadd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-28-2005, 04:00 PM
  5. Autofilter Lists Problem
    By Medows in forum Excel General
    Replies: 2
    Last Post: 08-15-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1