Results 1 to 7 of 7

If word entered not in defined name range, copy & paste it to bottom of defined name range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    If word entered not in defined name range, copy & paste it to bottom of defined name range

    Is it possible to have a macro that will analyze words entered in an area and if they do not match the any of the words in a defined name range, to copy and paste it to the defined name range? And if it does match, do nothing.

    edit: I think it would be best if the text was ran through the trim function prior to looking for a match.
    Last edited by Butcher1; 11-05-2014 at 01:32 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy, paste, replace- user defined range in all the defined sheets
    By aganesan99 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2014, 12:28 PM
  2. [SOLVED] Copy range and paste to next empty row in a defined row or area
    By JimmyG. in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-13-2013, 03:11 PM
  3. EXCEL 2003 copy paste a defined range in a cell
    By EXCELNOOB123 in forum Excel General
    Replies: 1
    Last Post: 03-07-2011, 10:01 PM
  4. Finding a defined range of cells then Copy & Paste
    By bernborough in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-11-2010, 06:45 PM
  5. Replies: 0
    Last Post: 02-24-2005, 04:06 PM

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