Macro based on criteria

[ramseyprescott]

Someone has probably asked this before.
BUDGET I have 12 sheets (JAN,FEB, MAR, JUN), etc......
In each of those sheets i have a list,database. Each row has a purchase
DATE: , ITEM:, VENDOR NAME:, AMOUNT PURCHASED:

I am making a input worksheet form to input purchases into each sheet.
I was hoping you could help with a macro that could transfer purchases into each month by what i type into DATE: transfering into one sheet, no problem but i need criteria based on month input. As the macro is clicked, data is transfered and deleted from form.

THANKS A MILLION

[rylo]

Hi

How about

Please Login or Register  to view this content.

HTH

rylo

[teylyn]

From a data management perspective, a better approach would be to enter all data items into a table on a data sheet, then create a report, for example a pivot table, to examine the details for a particular month/quarter/year, by vendor, item, whatever.