Results 1 to 5 of 5

Data Verification

Threaded View

  1. #1
    Registered User
    Join Date
    08-03-2008
    Location
    London
    Posts
    21

    Data Verification

    Hi.

    I have two worksheets. The first is a bit messy due to user error when inputting. It looks something like this

    Line             Description
    001              Bananas
    001              Bananass
    001              Baaannaaas
    002              Cheese
    003              Green things.
    I need to correct these descriptions with the second worksheet data which has the accurate description for all lines, for example:

    Line             Description
    001             Bananas
    002             Blue Cheese
    003             Lettuce
    To manually correct all of the first sheet would be a tedious task as there are a good 18-19 thousand rows of data.

    I should mention the first sheet is a 97-03 spread sheet and the second is a 07 excel spread sheet (as the second as over 100 thousand rows of data)

    How can I do this?
    Last edited by VBA Noob; 09-14-2008 at 08:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data and number manipulation
    By Mwhite in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2015, 06:41 AM
  2. automatically move left one cell after data input by scanner.
    By dgbillings in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2010, 10:58 PM
  3. Replies: 2
    Last Post: 02-14-2008, 05:02 PM
  4. importing data:What i would like to do is be able to import
    By censura in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2007, 08:32 AM
  5. Macro to create new sheets from master data sheet
    By adsigel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2006, 09:21 AM

Tags for this Thread

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