[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.
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!