Need to build a HTML checklist

Pratap 1987

Board Regular
Joined
Feb 28, 2011
Messages
95
Hi,

Could you please help me out in building a HTML code to create a checklist - as shown in the below table:

ListDeadlineSign OffTime StampUser IDUser Name
Task 19:00 AMButton 19:02 AM1234567Analyst 1
Task 210:00 AMButton 210:00 AM1234567Analyst 1
Task 311:00 AMButton 39:00 AM7654321Analyst 2

<tbody>
</tbody>

Please note that-This checklist will be used for daily signoffs and have to perform the below function during signoff:
  • As I click ‘Sign Off’ button – It should capture the current system time in the corresponding ‘Time Stamp’ cell (And if the Time Stamp is less than or equal to the time in corresponding ‘Deadline’ Cell – The cell should be highlighted in GREEN – Else, the cell should be highlighted in RED), then
  • It should also capture the Windows User Name (a 7 digit ID) in corresponding ‘User ID’ cell, then
  • Finally based on the User ID - It should also pull the User Name from a predefined table in HTML code

All the above 3 functions should be performed as I click on the ‘Sign Off’ button.

Your help is much needed!
I’ll be loyal to you rest of my life if you could get me a HTML code for the above checklist and action points.

Thanks,
Pratap.D
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,215,828
Messages
6,127,126
Members
449,361
Latest member
VBquery757

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top