Hello everyone,
I have an Excel Spreadsheet with a column that contain a value of either 1 or 0 and I would like to create a Macro to delete the rows that contain a 0 value on a particular column. For example, if cell D5 has a value of 0 I'd like the Macro to delete the entire row 5 and move the undeleted data up a row. I know I can sort the spreadsheet and manually delete rows that contain 0 but would like to build a Macro for the end user to click the button to automatically delete the unecessary rows. I've never created a Macro before and would really appreciate your help in guiding me to create the Macro.
Thank you so much!!!
TC
I have an Excel Spreadsheet with a column that contain a value of either 1 or 0 and I would like to create a Macro to delete the rows that contain a 0 value on a particular column. For example, if cell D5 has a value of 0 I'd like the Macro to delete the entire row 5 and move the undeleted data up a row. I know I can sort the spreadsheet and manually delete rows that contain 0 but would like to build a Macro for the end user to click the button to automatically delete the unecessary rows. I've never created a Macro before and would really appreciate your help in guiding me to create the Macro.
Thank you so much!!!
TC