joeny0706
03-04-2019, 07:44 AM
Hi all
I am trying to make a macro that is probably simple to alotof you but being a pain for me. I have a list of macros to run but need onemore. I need to add one more to a xlsm file. Just need it to remove a row if thereis 0 in column E.
All the ones I have created are only deleting the celland not the row. Then just errors out.
I have a document that will convert data from handhelddevices for the delivers of the day. The data I am receiving has a line for quantity.
So, column E has the quantity. These devices record theitem even if zero are delivered. So when I upload this info to my accountingsoftware the invoices are showing items that were not delivered.
So I need each row that has a 0 in column E to be removed.If anyone want to help out it would be greatly appreciated.
Thanks all.
I am trying to make a macro that is probably simple to alotof you but being a pain for me. I have a list of macros to run but need onemore. I need to add one more to a xlsm file. Just need it to remove a row if thereis 0 in column E.
All the ones I have created are only deleting the celland not the row. Then just errors out.
I have a document that will convert data from handhelddevices for the delivers of the day. The data I am receiving has a line for quantity.
So, column E has the quantity. These devices record theitem even if zero are delivered. So when I upload this info to my accountingsoftware the invoices are showing items that were not delivered.
So I need each row that has a 0 in column E to be removed.If anyone want to help out it would be greatly appreciated.
Thanks all.