Results 1 to 4 of 4

Loop Macro - Find "CR"s And Move Data From 1 Row To Another

Threaded View

  1. #1
    Registered User
    Join Date
    09-14-2012
    Location
    Earth
    MS-Off Ver
    Excel 2010
    Posts
    24

    Loop Macro - Find "CR"s And Move Data From 1 Row To Another

    Hello All,

    I was wondering if someone would be kind enough to help me with a Loop Macro (which I will incorporate into a Bigger Macro). I spent some time looking through these Forums and I just could not find exactly what I needed and I don’t know enough about Loop Macros to modify ones that people have used in other Posts. So, I am hoping that someone will take pity on me and help me out. Generally, if I can get an example, I can learn from that and modify it in other Macros I use. I normally include the Code I need help with, however, I don't have Loop Macro because I wasn’t sure where to start.

    Here is what I am looking for:

    I need to find all of the “CR”s in Column "F" in a Spreadsheet and when a “CR” is found, I need it to take the Dollar Amount that is 6 Columns to the Left and 1 Row up, Cut it, and move it down one Cell. I know how to get a Macro to move over the 6 Columns and 1 Row up and do the Cut and Paste. However, I do not know how to code that into a Loop. So, I only need this to happen to the “CR”s in the Spreadsheet. Also, there is a possibility that the Spreadsheet may not have any “CR”s at all, so the Loop would need to account for that.

    I am attaching a Example Spreadsheet (with both a Before and After look) of the Data I will be working with.

    Thank you very much, in advance, for all of your time and help. I really do appreciate it.

    P.S. See, I found this “SOLVED” Post, but I could not figure out how, exactly, to modify it to what I needed:
    http://www.excelforum.com/excel-prog...bombs-out.html
    Last edited by Macro Fool; 04-01-2013 at 06:38 PM. Reason: Added that I need to find all of the "CR"s only in Column "F".

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