Macro to eliminate zeroes if numbers in column match and both sets of columns have zeroes

I'm not sure if this is possible. I have a file that has as the unique identifier the JournalKey column. I need a macro that if the journal key is the same for both rows then verify if there are zeroes in each of these rows in columns E and F and H and I. Both sets of columns need to have zeroes, so both E and F have zeroes, and/or both H and I have zeroes. And if there are zeroes it should delete the value in the cell and leave it blank.

For example in the image below the following would be done:

- For rows 2 and 3 that are the same #, since both columns H and I have zeroes it would delete the zeroes and leave blank
- For rows 4 and 5 nothing would be done
- For rows 6 and 7, it would delete the zeroes in rows E and F.
- For rows 8 and 9, it would delete the zeroes in rows E and F and in rows H and I
- For rows 10 and 11, it would not delete anything because there is a value in column F and also a value in column I

template.JPG

I'm attaching this file also.

Thanks in advance.

Thank you Karmapala. I double-checked the data and it sometimes has entries with 3 or 4 rows with the same Journal Key so neither assumption is accurate.. Sorry for not mentioning this before.

Is there a way to do it if that's the case?

I attached an example with the different cases.

This worked great! Thank you so much karmapala!!