Link the checkbox to a cell on Sheet1 (right-click the checkbox, format
control, control tab), and then in that linked cell add the formula

='July 2006'!B49="Yes"

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"edwardpestian"
wrote in message
news:edwardpestian.2bg4y3_1153738805.7474@excelfor um-nospam.com...

I have a range of dates B49:AF49 for July 2006. Below each date is data
pertaining to that date. For example: revenue, cars parked etc. One of
the fields is a simple yes or no. What I need is if the user enters
yes in the cell (Row 63), a checkbox on a separate sheet ('Sheet 1'!)
is checked. And if no the checkbox is unchecked.

Thanks in advance.

-ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=564235