VBA Do Loop

Copper Contributor

iklak885_0-1657780968669.png

I need help with the VBA code. I'm trying to add a worksheet that can go through the transaction worksheet and then have a total balance per customer on the new worksheet with their name and Id included. How can I do that, please? 

 

1 Reply

@iklak885 Why VBA? You can use a pivot table for such a summary report. Example attached.