Results 1 to 2 of 2

Thread: [RESOLVED] XL Macro to conditionally copy cells

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2007
    Posts
    2

    Resolved [RESOLVED] XL Macro to conditionally copy cells

    In a previous life, I might have been able to do this on my own, but I'm a little out of practice, so I'm asking for assistance.

    I have need of a macro within Excel that I think will need to be created at the programming level. I get an Excel sheet of raw exported data from another program that I use. I need to format the data such that for each row, if the contents of column B are equal to a certain text string, I need to take the data from columns C and D and copy them to columns E and F, respectively. I know that this will likely take using some creative combination of Do-While, For Each-Next, and If-Then, but, as I'd said, my programming skills are a little rusty, and so, rather than spending 2 weeks of trial and error, I thought that I'd ask you all for assistance. Any help you could give would be greatly appreciated. If anything is unclear, please let me know.

  2. #2

    Thread Starter
    New Member
    Join Date
    Aug 2007
    Posts
    2

    Re: [RESOLVED] XL Macro to conditionally copy cells

    Thanks to those of you that viewed the post...I managed to cobble something together that should work for now...if it needs to be cleaned up, I'll be back!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width