Onibaku_Rave
05-27-2016, 11:05 AM
Hi All,
My goal is to create a macro that deletes entire rows that contain no data, save for the first column which is the task name. Depending on which month I need to pull the data from, the number of days in the month will change and the number of tasks will also change, so those will have to be dynamic. I also want the macro to ignore the last two rows, which contains a spacer row and a set of numbers irrelevant to the data. The code that I have would delete rows, but it is for a static data set and won't work if I need to pull a different month.
16279
My goal is to create a macro that deletes entire rows that contain no data, save for the first column which is the task name. Depending on which month I need to pull the data from, the number of days in the month will change and the number of tasks will also change, so those will have to be dynamic. I also want the macro to ignore the last two rows, which contains a spacer row and a set of numbers irrelevant to the data. The code that I have would delete rows, but it is for a static data set and won't work if I need to pull a different month.
16279