VBA归档数组和创建列

I need to write a sub that captures the existing lists in two arrays and then create two new arrays of customer names and amounts spent for customers who spent at least 0. After these new arrays have been filled, I have to write them in columns D and E.I need to write a sub that captures the existin