+ Reply to Thread
Results 1 to 5 of 5

Find Values, Delete and Move Left

  1. 08-01-2008, 04:37 AM #1
    rkeane7
    rkeane7 is offline
    Registered User
    Join Date
    07-30-2008
    Location
    MANCHESTER
    Posts
    30

    Find Values, Delete and Move Left

    I am looking to find a way where i can write some code that will find all values found in column J. If any values are found i would like to move all values from columns D to J for that particular row. Could somebody please help.

    Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 08-01-2008, 04:48 AM #2
    mudraker
    mudraker is offline
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Do you mean if any cell in column J as an entry then replace the entry in Column J by moving the value that is in Column D of the same row

    Or do you mean find all instances in Column J of a specific entry/value and replace that entry with whatever entry is in column D of the same row
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.
    Reply With QuoteRegister To Reply
  3. 08-01-2008, 05:17 AM #3
    rkeane7
    rkeane7 is offline
    Registered User
    Join Date
    07-30-2008
    Location
    MANCHESTER
    Posts
    30

    Find, Cut and Paste

    Thanks for your reply Mudraker. Currently i have 5000 rows of data come off from a database. For some reason the database seems to have added extra data that is not required in Column C (this data varies).

    So the data that should be in column C now appears in D, and D in E etc. Hence the reason I have extra data in column J.

    I would like for all entries found in J to cut that particular row from column D to J and paste it into column C to I, which would get rid of any values in J and realign everything together.

    Hope that makes sense. Thanks once again.
    Reply With QuoteRegister To Reply
  4. 08-01-2008, 08:09 AM #4
    mudraker
    mudraker is offline
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    It sounds a little more complicated than I was picturing.
    To be 100% sure can you paste an workbook with samples of before & after examples.

    As I have been having problems opening xls files from this site can you also zip the workbook before posting
    Reply With QuoteRegister To Reply
  5. 08-01-2008, 09:34 AM #5
    rkeane7
    rkeane7 is offline
    Registered User
    Join Date
    07-30-2008
    Location
    MANCHESTER
    Posts
    30

    Find Values, Cut and Paste

    Mudraker,

    Thanks for your response. I have managed to solve this issue by writing the following:

    Please Login or Register  to view this content.
    Thanks for all your help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1