Hi All,
Hopefully one of you will be able to help me. I've just written a Macro to export information from a source sheet into two other sheets: one to have a simple mail merge run on in, and the other to prepare a spreadsheet for copying to a CSV sheet manually.
The code now works perfectly, albeit incredibly slowly. I'm pretty sure that this is largely due to the fact that my code is continually jumping between sheets, but because of the functionality I require (or at least in the way that I have gone about achieving it) I couldn't find a way around it.
I'm fairly new to Macros, this being only my 2nd, so it basically just replicates what I would do it I was doing it manually. It is based primarily around 2 loops. The first loop checks each cell in a column one by one for the word "YES", at which point it exports selected data to another sheet. The loop repeats until the end of the column (using if Blank) and then moves on to the next column, at which point the loop is triggered again and run on that column, a process which runs until the macro encounters a blank column.
I'd just like to know if anyone can see anything in my code that could be achieved in a more efficient way? It took about 20 minutes to complete a test run with only 3 columns to be checked; the full version will have up to 20 colums!
Thanks in advance, Joe
Bookmarks