pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
Hi,
Could someone please help me with the code.
In sheet1, i have formula = now() which will show todays time.
And also I have the code that if name <> "Sue Tracey" and "Jim Smart" then
command button1 disable.
otherwise do this (....i need a code here)
that will;
Find todays date mentioned in rang("a1") match withthe ones in row A3,B3,C3,D3,E3.....ETC If found then find the the row where name is corresponding to date. I just want to have code separately for everyone...where i'll have command button for everyone so we can define a row and then find the date col and mark "X" in it.
I hope you understand.
Thank alot for helping in advance.
Pedie
Sample table
<TABLE style="WIDTH: 260pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=347><COLGROUP><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1243" width=34><COL style="WIDTH: 134pt; mso-width-source: userset; mso-width-alt: 6509" width=178><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 987" span=5 width=27><TBODY><TR style="HEIGHT: 53.25pt; mso-height-source: userset" height=71><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 26pt; HEIGHT: 53.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=71 width=34></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 134pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70 width=178>NAME</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; WIDTH: 20pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl71 width=27>7/1/2010</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #f2f2f2; WIDTH: 20pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl71 width=27>7/2/2010</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #f2f2f2; WIDTH: 20pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl71 width=27>7/3/2010</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #f2f2f2; WIDTH: 20pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl71 width=27>7/4/2010</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #f2f2f2; WIDTH: 20pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl71 width=27>7/5/2010</TD></TR><TR style="HEIGHT: 15.95pt; mso-height-source: userset" height=21><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.95pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 height=21>1</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65>Tom Dalaney</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> X</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> X</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD></TR><TR style="HEIGHT: 15.95pt; mso-height-source: userset" height=21><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.95pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 height=21>2</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65>Jim Smart</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> X</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD></TR><TR style="HEIGHT: 15.95pt; mso-height-source: userset" height=21><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.95pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 height=21>3</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65>Sue Tracey</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> X</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD></TR></TBODY></TABLE>
Could someone please help me with the code.
In sheet1, i have formula = now() which will show todays time.
And also I have the code that if name <> "Sue Tracey" and "Jim Smart" then
command button1 disable.
otherwise do this (....i need a code here)
that will;
Find todays date mentioned in rang("a1") match withthe ones in row A3,B3,C3,D3,E3.....ETC If found then find the the row where name is corresponding to date. I just want to have code separately for everyone...where i'll have command button for everyone so we can define a row and then find the date col and mark "X" in it.
I hope you understand.
Thank alot for helping in advance.
Pedie
Sample table
<TABLE style="WIDTH: 260pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=347><COLGROUP><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1243" width=34><COL style="WIDTH: 134pt; mso-width-source: userset; mso-width-alt: 6509" width=178><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 987" span=5 width=27><TBODY><TR style="HEIGHT: 53.25pt; mso-height-source: userset" height=71><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 26pt; HEIGHT: 53.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=71 width=34></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 134pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70 width=178>NAME</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; WIDTH: 20pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl71 width=27>7/1/2010</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #f2f2f2; WIDTH: 20pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl71 width=27>7/2/2010</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #f2f2f2; WIDTH: 20pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl71 width=27>7/3/2010</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #f2f2f2; WIDTH: 20pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl71 width=27>7/4/2010</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #f2f2f2; WIDTH: 20pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl71 width=27>7/5/2010</TD></TR><TR style="HEIGHT: 15.95pt; mso-height-source: userset" height=21><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.95pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 height=21>1</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65>Tom Dalaney</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> X</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> X</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD></TR><TR style="HEIGHT: 15.95pt; mso-height-source: userset" height=21><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.95pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 height=21>2</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65>Jim Smart</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> X</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD></TR><TR style="HEIGHT: 15.95pt; mso-height-source: userset" height=21><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.95pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 height=21>3</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65>Sue Tracey</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> X</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: transparent; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl69> </TD></TR></TBODY></TABLE>