Hi, I am trying to create a macro in excel to clean up data that I export from another program. What I did is I recorded a macro, and the macro works beautifully for the set of data that day. However, the next day when I export, the number of rows is different, so the recorded macro I have that has excel cells and rows doesn't work.
What I am trying to accomplish is two things:
1) Delete all rows that have data but don't have a value in column B. The way I did it was sort by column B then deleted all rows that had a blank column B. The first day there were 20 rows, then next day there were 43 rows, so you can see the issue of the recorded macro where it only deleted 20 rows.
2) I want to do an autofill for all the remaining rows with a new column of data. Once again, the recorded macro had a different number of rows then the next day's data. So I would love to only autofill down on a row that has data somewhere else in the row.
Any advice on how to do this would be greatly appreciated!
What I am trying to accomplish is two things:
1) Delete all rows that have data but don't have a value in column B. The way I did it was sort by column B then deleted all rows that had a blank column B. The first day there were 20 rows, then next day there were 43 rows, so you can see the issue of the recorded macro where it only deleted 20 rows.
2) I want to do an autofill for all the remaining rows with a new column of data. Once again, the recorded macro had a different number of rows then the next day's data. So I would love to only autofill down on a row that has data somewhere else in the row.
Any advice on how to do this would be greatly appreciated!