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
Bookmarks