+ Reply to Thread
Results 1 to 2 of 2

Data cleanup in MS Excel

  1. #1
    Registered User
    Join Date
    02-04-2016
    Location
    sydney
    MS-Off Ver
    2016
    Posts
    1

    Data cleanup in MS Excel

    hi there,

    Just wanting some assistance with writing a script in MS Excel which can do the following:
    - match current value to value to change to
    - do find and replace for old value to new value

    Can someone please have a look at my workbook? I am trying to do this via vlookup - and then using a script for Find / Replace.

    regards
    Chale
    Attached Files Attached Files

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Data cleanup in MS Excel

    Its not clear what you are trying to accomplish.
    Can you elaborate with an example showing what is to be done exactly?
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

+ 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. Data Cleanup
    By harshalcr9 in forum Excel General
    Replies: 3
    Last Post: 12-17-2015, 07:47 AM
  2. Cleanup telephone numbers that have some text data
    By djarcadian in forum Excel General
    Replies: 4
    Last Post: 08-19-2014, 08:03 AM
  3. external data - cleanup existing connections
    By edstevens in forum Excel General
    Replies: 1
    Last Post: 04-26-2013, 12:03 PM
  4. File Cleanup & Insert Data
    By ryannjohnsonn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2012, 10:15 AM
  5. Inefficient/slow data cleanup code
    By teitoku in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-01-2010, 06:59 PM
  6. 'data cleanup' problem
    By zobufeja in forum Excel General
    Replies: 3
    Last Post: 01-29-2010, 09:28 AM
  7. Macro to cleanup data
    By Castlewood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2008, 06:31 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