Hi,
I have a requirement and require your guidance on how to achieve the same.
I have a workbook and this has two sheets.
Sheet1 has the following information
Employee Name
Task
Fromdate
Todate
Lets assume
Uday ,"Complete Excel Macro" , 10/6/13, 10/10/13
Rose , "Need to finish preparing for tutorials",11/10/13,11/15/13
Uday, "Need to prepare a new datasheet,1/1/14,1/10/14
The Sheet 2 has the complete calender along with the employee names
which started from 10/1/13 and continues until 10/1/14
Like
Uday , calender From 10/1/13 and continues until 10/1/14
Rose , calender From 10/1/13 and continues until 10/1/14
Now the task that needs to be performed is explained below.
When i run the macro, my VBA code should look the data on the first sheet row by row.
First row , if it finds Uday, it should pick up the from date and to date
and the same dates must be highlighted with a specific background color.
So when processing second row , rose related calender gets updated.
Again as the third record is Uday , it will go back to uday and update the relavent dates.
Could you please help me in knowing on how to read and process the data row by row.
With Regards
Uday
Bookmarks