I wish to create a macro that when i click a button i can input what month i wish to print out data for. I have 7 columns (A-G).
Date Day Activity Income
02/01/2012 Monday Work (8) £48.00 02/01/2012
HMOT £5.00 02/01/2012 Peter Taylor 134024855
HMOT £5.00 02/01/2012 Susan Taylor 134023422
HMOT £5.00 02/01/2012 Steve Davy 134027374
04/01/2012 Wednesday Work (8) £48.00 04/01/2012
HMOT £5.00 04/01/2012 Tom Thompson 134027410
HMOT £5.00 04/01/2012 John Ackroyd 134025131
HMOT £5.00 04/01/2012 Aftab Ilahi 134022546
Above is an example of the sheet.
In column A we have the date, B we have the day, C we have the activity, D we have the income, E is a cell with the previous month date in to track data for the month, F is a name and G is a number.
I wish to be able to print all of january for example, rows A-G by clicking a button and entering something like 'january' or '01/12'. This will then select all of the rows with data in based on the date range in column A and print the selection.
Please feel free if that doesn't make sense to ask questions.
Thanks in advance.