Hello All!!! I’m using a work sheet to track the progression of a system from the beginning of engineering to the final transfer of custody and care of the constructed system. The reason being is there are several business units that need to know when it is there turn to work on their portion of the process. The work sheet has the system name in the “A” column and there are two other columns that show the dates two other groups need to make staff available. In the office we use a tile chart for scheduling. The column headers represent the end of the work week, if the system needs to be walked down within the 7 days prior to this date the system needs to be shown in the column. So I need to look for systems within my work sheet that need to be walked down within the 7 day time period. I have to recreate the tile chart weekly and it takes me hours to transfer the information. Can someone please help with the formula needed to extract the dates from the work sheet relative to the system (Column A) and return it under the associated tile chart column!!!! Need help! Thank you so much!!!!
Example of Tile chart column Example Of Work sheet column
02-Jun-12 - Header System - Header WD - date column
90-106-800-8204 - System # name 90-106-800-8204 System # name 02-June-12
Group Transfer - System name
Example of Tile chart column Example Of Work sheet column
02-Jun-12 - Header System - Header WD - date column
90-106-800-8204 - System # name 90-106-800-8204 System # name 02-June-12
Group Transfer - System name