my first sheet is called database. column a is the serial number, column B is the activity name and column C to the end is what items are needed for a certain activity.
my second sheet is called schedule. column a is the serial number, column B and c is the dates (beginning and end) column D is the name of the activity.
sheet 3 is called packing list. where column a is all the dates of the month, column B onwards is the stuff needed to be brought.
I'm wondering if there's a macro I can use such that sheet 3 will show what to bring on what dates.
my second sheet is called schedule. column a is the serial number, column B and c is the dates (beginning and end) column D is the name of the activity.
sheet 3 is called packing list. where column a is all the dates of the month, column B onwards is the stuff needed to be brought.
I'm wondering if there's a macro I can use such that sheet 3 will show what to bring on what dates.
