nagarajkp
11-03-2012, 06:52 AM
I am New to VBA, and need help for the following:
I have a Employees worksheet which has three columns ID, Name and Status. Those employees whose status is "Active" should be filtered by code and should be made visible.
There is Attendance worksheet which should update only visible rows(ID and Name) from employees worksheet. if a new name is added in Employees worksheet, it should create a new row in Attendance Worksheet or if any name is made non visible(by changing status)in Employees worksheet, it should delete that entire row of that name based on ID in Attendance worksheet because there are other columns associated with that name in Attendance Worksheet.
There is another Section worksheet which should copy few columns ((ID,name and Section) after custom sort from attendance worksheet. If a new name is added in the Employees worksheet, it will create a new row in Attendance worksheet, in turn it will create a new row in Section worksheet. If a section is changed for some employees in the attendance worksheet, the corresponding changes should happen in section worksheet based on ID. If some names are removed from attendance worksheet by changing Status in Employees worksheet, the entire row of that name should be removed from section worksheet based on ID because there are other columns associated with that name in Section Worksheet.Now I am doing all these manually by using Excel formulas. Now I am trying VBA code to perform as above in all three worksheets. Hope will get suitable vba code
regards
I have a Employees worksheet which has three columns ID, Name and Status. Those employees whose status is "Active" should be filtered by code and should be made visible.
There is Attendance worksheet which should update only visible rows(ID and Name) from employees worksheet. if a new name is added in Employees worksheet, it should create a new row in Attendance Worksheet or if any name is made non visible(by changing status)in Employees worksheet, it should delete that entire row of that name based on ID in Attendance worksheet because there are other columns associated with that name in Attendance Worksheet.
There is another Section worksheet which should copy few columns ((ID,name and Section) after custom sort from attendance worksheet. If a new name is added in the Employees worksheet, it will create a new row in Attendance worksheet, in turn it will create a new row in Section worksheet. If a section is changed for some employees in the attendance worksheet, the corresponding changes should happen in section worksheet based on ID. If some names are removed from attendance worksheet by changing Status in Employees worksheet, the entire row of that name should be removed from section worksheet based on ID because there are other columns associated with that name in Section Worksheet.Now I am doing all these manually by using Excel formulas. Now I am trying VBA code to perform as above in all three worksheets. Hope will get suitable vba code
regards