Create report of low inventory items

**kenking50** · 12-16-2014, 04:13 PM

I am a long time user of Excel who has never had to work with VBA macros.

I have an Inventory database, with 2000 records.

When items get below a certain level I want to copy the record for that item into a new worksheet and email that worksheet.

Also, ultimately, I would like to automate this process so that once a day I get a report of my low inventory.

I'm sure this can't be too difficult in VBA but I haven't a clue where to start.

Any help would be appriciated.

**Arkadi** · 12-16-2014, 04:54 PM

When you say database, do you mean a spreadsheet with data, or an actual database (access, sql, etc?) For automation, you'll want to put the macro in an auto_open macro and schedule a task, unless you want to keep the excel file with the macro open all the time.
If your data is in a workbook, ideally you would upload it so we can get an idea of what we are looking at.
Also, define "low" inventory, unless your database will have a field indicating what is considered low for the given item.

**kenking50** · 12-16-2014, 05:49 PM

Yes, I meant an Excel spreadsheet.

Attached is my Excel file.

Column G is my minimum amount needed. Column F is the amount on hand.

IF(F<G) create report.