Dear Friends,
I have a spreadsheet for entering Employee's details. On that I am entering employees daily attendance status. It is almost 600 employees and entering each and every employee is a herculean task. So What I need is, I can enter on the Absent, Casual Leave, and etc...and the remaining unmarked staffs will be PRESENT. So that If I have a command button for that, when I click that button it should automatically apply "P" on the remaining cells on that particular date's column. More clearly, I have 31 columns for each days in month and on each column's 7th ROW contains that particular day's date. So the macro has to search the empty CELL's between current date's particular column and fill it with "P". The empty cells will be between 8th row to 500th row on each day's column. One more thing the macro has to check. The empty cell on each day has to fill ONLY IF that cells respective "B" cell having any value. More clear I am entering Employees name in the "B" Column from 8 th to 500th row. So, After clicking the command button, macro has to find that particular date containing column and find the empty cells between that column's 8th ROW to 500th ROW and has to fill those empty CELLS with "P" ONLY IF there is any name in the B column.
Kindly Suggest me a macro for this.
Bookmarks