I have a timesheet which has days(Sat to Fri) on starting from cell B2 and Title "Tasks" in cell A1.
Number of Tasks are list on column A and its shows "Task 1-Task XX" starting on cell A2.
The descriptions are showing below the task numbers chart for the cells hours that are not empty.
Tasks_Sat_Sun_Mon_Tue_Wen_Thu_Fri
Task1_'empty'_1_2_empty_empty_5_empty.
Task2_3_1_'empty'_empty_empty_5_empty.
.
.
Task10
Descriptions (column A)
Task1, Sun - I worked on abc report(1hour) (column A)
Task1, Mon - abc homework(2hour) (column A)
Task1, Thu - abc homework(5hour) (column A)
Task2, Sat - I worked on xyz report(3hour) (column A)
Task2, Sun - I worked on xyz homework(1hour) (column A)
Task2, Thu - I worked on xyz homework(5hour) (column A)
----------------------------------------------------------------------------
I am trying to insert columns right next to each days, and I copy and paste the description that matches the Task and days (Task1, Sun and Task1, Mon...etc) right next to the time.
Tasks_Sat__Sun__Mon_Tue_Wen_Thu_Fri
Task1_'empty'__1'I worked on abc report(1hour)'2abc homework(2hour)_empty_empty_5abc homework(5hour)_empty.
Can anyone understand and help me?
Number of Tasks are list on column A and its shows "Task 1-Task XX" starting on cell A2.
The descriptions are showing below the task numbers chart for the cells hours that are not empty.
Tasks_Sat_Sun_Mon_Tue_Wen_Thu_Fri
Task1_'empty'_1_2_empty_empty_5_empty.
Task2_3_1_'empty'_empty_empty_5_empty.
.
.
Task10
Descriptions (column A)
Task1, Sun - I worked on abc report(1hour) (column A)
Task1, Mon - abc homework(2hour) (column A)
Task1, Thu - abc homework(5hour) (column A)
Task2, Sat - I worked on xyz report(3hour) (column A)
Task2, Sun - I worked on xyz homework(1hour) (column A)
Task2, Thu - I worked on xyz homework(5hour) (column A)
----------------------------------------------------------------------------
I am trying to insert columns right next to each days, and I copy and paste the description that matches the Task and days (Task1, Sun and Task1, Mon...etc) right next to the time.
Tasks_Sat__Sun__Mon_Tue_Wen_Thu_Fri
Task1_'empty'__1'I worked on abc report(1hour)'2abc homework(2hour)_empty_empty_5abc homework(5hour)_empty.
Can anyone understand and help me?