+ Reply to Thread
Results 1 to 3 of 3

Validating info before pasting

  1. #1
    Registered User
    Join Date
    02-27-2009
    Location
    ma
    MS-Off Ver
    Excel 2003
    Posts
    35

    Validating info before pasting

    i have a spread sheet set up with a macro in it.

    the macro will copy an entire row from one sheet and paste it into a sheet setup to be a compilation of everything.


    i want the macro to validate the info to make sure its not already in there.

    for instance, if you look in my book, the first two columns are location and #... if a location and number is already being used, i dont want it to paste.

    i can have muplitple part numbers, but only one location and number can be used.



    thanks

    nick
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-27-2009
    Location
    ma
    MS-Off Ver
    Excel 2003
    Posts
    35

    Re: Validating info before pasting

    ive done some C++ programing in school. however, i have no idea how conidtional stuff like if/then or loops work in visual basic

  3. #3
    Registered User
    Join Date
    02-27-2009
    Location
    ma
    MS-Off Ver
    Excel 2003
    Posts
    35

    Re: Validating info before pasting

    anyone?

    i ordered a book to help in general for this and in the future.

    but who knows when it will actually show up

+ 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