W
wmureports
I am importing data from a lot of .xls files(over 100). The data
imports and goes to the apprioriate location. The problem I am
encountering is that I get blank rows. My spreadsheet will look
similar to this
ID Name Phone
1 Joe 555-5555
2 Joe 555-5555
3 Joe 555-5555
4 Joe 555-5555
5 Joe 555-5555
6 Joe 555-5555
7 Joe 555-5555
8 Joe 555-5555
9 Joe 555-5555
Like that with random empty rows. What would i add to my macro to
ignore rows that are blank???
imports and goes to the apprioriate location. The problem I am
encountering is that I get blank rows. My spreadsheet will look
similar to this
ID Name Phone
1 Joe 555-5555
2 Joe 555-5555
3 Joe 555-5555
4 Joe 555-5555
5 Joe 555-5555
6 Joe 555-5555
7 Joe 555-5555
8 Joe 555-5555
9 Joe 555-5555
Like that with random empty rows. What would i add to my macro to
ignore rows that are blank???