# Database? problem

#### redfour

##### New Member
I am the secretary of a local gardening club. Each year the members of the club (over 200) order their seed from a catalogue containing approximately 1250 different seeds. It is a mammoth task that last year took me over 2 weeks to complete.

Since last year I have created a database in Excel which contains the records of the seeds, including reference number, description and cost of each packet of seed. I then use a template to enter each member’s individual order, using VLOOKUP. This has already saved me a great deal of time.

However, I still have to manually go through each order and count how many packets of each seed has been ordered.

Is there any way that Excel can use the data entered for each member’s order to automatically collate all the orders together to produce the bulk order?

If anyone can point me in the right direction I would be extremely grateful.

The only task left then is the sorting of the 4,000+ packets of seed delivered into each member’s order. :x

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Hi - welcome to the board!

Something can probably be done here, but you'll need to give us more info - sheet names, data structures, a detailed, worked example etc. As it stands, the problem description is too general.

Consider posting up a relevant snapshot of your sheet (see html maker faq thread at the top of the board for how)

redfour said:
I am the secretary of a local gardening club. Each year the members of the club (over 200) order their seed from a catalogue containing approximately 1250 different seeds. It is a mammoth task that last year took me over 2 weeks to complete.

Since last year I have created a database in Excel which contains the records of the seeds, including reference number, description and cost of each packet of seed. I then use a template to enter each member’s individual order, using VLOOKUP. This has already saved me a great deal of time.

However, I still have to manually go through each order and count how many packets of each seed has been ordered.

Is there any way that Excel can use the data entered for each member’s order to automatically collate all the orders together to produce the bulk order?

If anyone can point me in the right direction I would be extremely grateful.

The only task left then is the sorting of the 4,000+ packets of seed delivered into each member’s order. :x
Hi redfour:

Welcome to MrExcel Board!

If you have set it up as a DataBase, then

1) you can use DCount/DCounta and/or DSum functions to count or sum the packages by recipient to suit your needs

2) for collating, how about sorting the data on the number of related fields

3) you may also create list of recipient names along with number of packages, for each box of seeds so that when the boxes are received, you know the names of the people and the number of packages the named recipient gets.

Depending on how your data is set up and your needs, you may also be able to use a PivotTable or DataTable for this task.

Let us know how it goes!

Welcome to MrExcel Board!

It sounds like using Data, Subtotals would help, but I agree with Erik and PaddyD: a picture is worth two thousand bytes.

Replies
0
Views
293
Replies
3
Views
379
Replies
1
Views
786
Replies
6
Views
526
Replies
5
Views
1K

1,203,435
Messages
6,055,353
Members
444,781
Latest member
rishivar

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back