DEV Community

Barun-Student
Barun-Student

Posted on

How can I filter data and sum by name of one excel table from other excel table using VBA and R1C1 reference

I got stuck at a problem with Excel VBA. I want to sum the total sales of each person of the second table in excel. I am using VBA R1C1 reference Here is my data:

Cookie Sales
Month February
Year 2022
Seller Buyer Cookie Quantity Cost Sales Monthly Sales
Charlie

Top comments (0)