to show a summary page for unaccounted items and tally

[michael35]

Hi All,

Could use some help on a summary page I am working on. A brief background on how the file works and what i am trying to create.

On the scan tab, badge number is input in cell A2, a date time stamp is input in the monthly tabs with a search on the date that is shown in cell B2 which has the "Today" formula. The VBA finds the badge number with the date in column and inputs the time stamp. If there is no time stamp it means the badge number was not input in cell A2.

There is a tab called Main which i have created.
1. I need some help to show the details of S/N and number of the different types namely (visitor, Temp and perm) in these columns which did not have a date input based on the date that is shown in the "Today" formula.
2. i need the vba to only start calculating once the last badge number which is number 160 on list is input. This is a proxy number that i have created to initiated to start calculations as i do not want the "main" tab to fill up after i start inputting the first badge number
3. when the badge s/n and number turns up in the columns, i will manually input the name of the person that is holding on to it in columns E, I and M. This info which i key in needs to be ported over to the respective cell on the monthly tab which is blank to account for it.
4. I have an email option in cell C5, G5 and K5 for each types on the main tab. Once i key in the badge number in these cells and press the email button, a message to be generated. I can input the custom message for each types. need some help to automatically input the name of the person that is input into the "To" option that was indicated for that badge number.

I have created a sample for expected results in the attached file.

[michael35]

Hi

Re-posting if I could get some help on this.