MartMartnz
New member
- Joined
- Nov 27, 2018
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hello,
I have a table with dates of certain purchase orders (PO) and their values (amount)
I found a formula that help me to find the previous date and amount of each purchase order.
In the amount of some purchase order, I have the text "Out", in this situation, the formula skip those records and give us the amount of the previous date.
When I adapt this formula to my worksheet that have at least 50000 records, my spreadsheet gets super slow.
Is there possible to create a VBA code to calculate this formula?
I am not an expert and I need some help to find a solution. Any suggestions would be greatly appreciated!
Thank you in advanced.
I have a table with dates of certain purchase orders (PO) and their values (amount)
I found a formula that help me to find the previous date and amount of each purchase order.
In the amount of some purchase order, I have the text "Out", in this situation, the formula skip those records and give us the amount of the previous date.
When I adapt this formula to my worksheet that have at least 50000 records, my spreadsheet gets super slow.
Is there possible to create a VBA code to calculate this formula?
I am not an expert and I need some help to find a solution. Any suggestions would be greatly appreciated!
Thank you in advanced.