Ask Excel for invoicing report making

You can make macros, and they must be fast.

For example, you can write the formula as:

i3"= There is no formula in the table, but the calculation is very fast.

But the cells should be referenced in the way of VBA.

It is recommended to add a helper column to the previous table and then use the sumif function to greatly improve the operation speed.

Help: Excel invoicing report making.

Reward points: 100 - There are 14 days and 23 hours left before the end of the problem, I used excel to make a purchase, sale and inventory**, and generate inventory according to the **table of each day, including: date, item number, color**, model**, and inbound and outbound quantity.

with =sumproduct((**table!) $b$3: $b$20000=b1670)*(**Table!)

C$3: $c$20000=C1670)*(**Table!) $d$3:

d$20000=d1670)*(**Table!) $e$3:$e$20000)) Formula.

But the speed of calculation is too slow, and there is no way to improve the speed of calculation!

VBA or with database, simple excel functions or formulas are slow modeling.

I make it for me. For more information, please hi

It's still genuine software, we've been using it for a few years, and now there's no problem at all.

Easy Shunjia software is available in traditional and simplified Chinese network stand-alone versions.

First make three side pickpockets**: a purchase table, a sales table, and the last balance shipping Wang Chang table.

2. Make the header of the purchase table;

3. Make the header of the sales table;

4. Make the header of the balance table;

5. Open the balance table, put the mouse in cell B2, and then click FX on the bulletin bar;

6. After confirming, the page will pop up the "function parameters", click the up arrow at the end of the first row with the mouse, after clicking, the parameter function will become a separate line, and then click on the purchase table;

7. After clicking on the purchase table, the page will jump to the interface of the purchase table, and select the whole column where the "product name" is located; After selection, click the up arrow behind "Parameter Function";

8. Click the blank space of the second row, the page will jump to the balance table, select the B2 cell, and then click OK;

9. Click the up arrow in the third row, and then click the purchase table, the page will jump to the purchase table, select the whole column where the quantity is located (that is, column C), and click OK after selection;

10. After confirming, the page will jump to the balance table, select the B2 cell, put the mouse in the lower right corner of the cell, when the cell appears "+" sign, press and hold to pull down, this is to fill the formula of the second cell to the other cells in column B;

That's a specialized invoicing software.

It's hard to make it yourself.