Copy a dated list from one worksheet to another within a given date range

[bholland]

I have a worksheet that has an inventory of items (some sold some unsold) and I'd like to have another worksheet that can create an invoice for sold items within a given date range.

The "Inventory" looks something like this below: (and a few more columns not listed here)
Description / Item Number / Sold For / Sold Date / Mall Com. / Consign Com. / Amount to Consignee
Actual Columns above are: B / C / H / I / J / O / P

I have an "Invoice" worksheet that I would like to have find and copy a list of items and associated values that are within a given date range... For example if I inputed a date range from March 1st through March 15th, the "Invoice" could find the items that were sold between those dates and populate a list that includes those sold items.

Any help?

[benishiryo]

hi bholland, welcome to the forum. could u upload a sample?