hello
I am new to macro and I need your help to create a macro that copy only the data with value > 0 to a new workbook. As you can see from the table, some data have no value so I am trying to avoid copying them by using if condition. Any one can help?
Refer image below
Note: ignore the zeros in Country
▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate VBA forum !
I am new to macro and I need your help to create a macro that copy only the data with value > 0 to a new workbook. As you can see from the table, some data have no value so I am trying to avoid copying them by using if condition. Any one can help?
Refer image below
Note: ignore the zeros in Country
▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate VBA forum !
Last edited by a moderator: