Excel 2007. Workbook has multiple sheets, one for each month and another sheet labeled Action Items. Within each month is a column that action can be entered into, along with other information (action item is not a requirement, so can be blank and don't want blank copied). Would like the action items sheet to self populate without having to create a line for each possibility (like a simple ='December 2012'!L2 etc would require).
I don't want the entire row, just the cell Action Item in the individual months so that dates and persons assigned can be recorded.
Sorry if I broke any rules so far.
Bookmarks