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

Barun-Student — Mon, 16 Jan 2023 18:13:58 +0000

Jan 16 '23 Comments: 7 Answers: 0

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

…

Open Full Question

Can anyone help me to find the problem in my angular project's ``` mat- spinnar ``` is not loading properly?

Barun-Student — Sat, 07 Aug 2021 13:12:44 +0000

My is not showing the loading process. Here is my code:

<div class="container" 
            fxLayout="row"
            fxLayout.sm="column"
            fxLayout.xs="column"
            fxLayoutAlign.gt-md="space-around center"
            fxLayoutGap="10px"
            >
            <mat-card *ngIf="dish" fxFlex>
                <mat-card-header>
                    <div mat-grid-avatar></div>
                    <mat-card-title>
                        <h3>{{dish.name|uppercase}}</h3>
                    </mat-card-title>
                </mat-card-header>
                <img mat-card-image src={{dish.image}}  alt={{dish.name}}/>
                <mat-card-content>
                    <p>{{dish.description|lowercase}}</p>
                </mat-card-content>
            </mat-card>
            <div fxFlex [hidden]="dish">
                <mat-spinner><h4>Loading ... Please Wait </h4></mat-spinner>
            </div>

            <mat-card *ngIf="promotion" fxFlex>
                <mat-card-header>
                    <div mat-grid-avatar></div>
                    <mat-card-title>
                        <h3>{{promotion.name|uppercase}}</h3>
                    </mat-card-title>
                </mat-card-header>
                <img mat-card-image src={{promotion.image}}  alt={{promotion.name}}/>
                <mat-card-content>
                    <p>{{promotion.description|lowercase}}</p>
                </mat-card-content>
            </mat-card>
            <div fxFlex [hidden]="promotion">
                <mat-spinner></mat-spinner><h4>Loading ... Please Wait </h4>
            </div>

            <mat-card *ngIf="leader" fxFlex>
                <mat-card-header>
                    <div mat-card-avatar></div>
                    <mat-card-title>
                        <h3>{{leader.name|uppercase}}</h3>
                    </mat-card-title>

                </mat-card-header>
                <img mat-card-image src={{leader.image}}  alt={{leader.name}}/>

            </mat-card>
            <div fxFlex [hidden]="leader">
                <mat-spinner></mat-spinner><h4>Loading ... Please Wait </h4>
            </div>

</div>

I need guide to get job in software development industry...

Barun-Student — Tue, 13 Apr 2021 18:08:31 +0000

DEV Community: Barun-Student

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

Can anyone help me to find the problem in my angular project's ``` mat- spinnar ``` is not loading properly?

I need guide to get job in software development industry...