Hi,
I wonder if this could be solve by VBA, would be very much appreciate if anyone could help to write a VBA for me if the request is even posssible.
First I have a Sheet 1 as following:
I would like the VBA to detect if there the value on Additional column is more than 0, it will generate a report on Sheet 2 as following:
Really hope something can help to resolve this cause i am dealing with 2000 lines or more on Sheet 1.
Thanks!
I wonder if this could be solve by VBA, would be very much appreciate if anyone could help to write a VBA for me if the request is even posssible.
First I have a Sheet 1 as following:
Number | Additional | Dividend |
A0001 | 0 | 500 |
B0002 | 100 | 600 |
I would like the VBA to detect if there the value on Additional column is more than 0, it will generate a report on Sheet 2 as following:
Number | Particular | Amount |
A0001 | Dividend | 500 |
B0002 | Dividend | 600 |
B0002 | Additional | 100 |
Really hope something can help to resolve this cause i am dealing with 2000 lines or more on Sheet 1.
Thanks!