DonnaYoung.org   rss feed   Members    Newsletter   Subscribe to YoungMinds   What's New

Chore Chart Maker - Cal-Chore Fix

Donna Young @ 28 October 2010
Filed in Categories:    

http://donnayoung.org
The Chore Chart Maker is an XLS file that has two different printable chore charts. One is calendar based and one is list based. The system works for up to eight people.

chore chart

The calendar base list, Cal-Chore sheet, fetches chores based on dates and the person's name. Recently, Jessica kindly told me that the calendar based chore chart did not pick up chores from the calendar for persons 5-8. I looked for my error in the Chore Chart Maker file and found it to be an easy fix.

This article describes how to fix the Cal-Chore sheet on the Chore Chart Maker.
NOTE: As of the evening of Oct. 27, 2010, the Chore Chart Maker that is online has already been fixed.

Open Chore Chart Maker
Go to the Cal-Chore sheet
1. Unprotect the sheet.
[Tools > Protect > Unprotect sheet]

2. Open the Find and Replace window.
[Edit > Replace]

3. Do the following in the Find and Replace window

In the find box enter:
Calendar!$A$3:$E$3,0),0)

In the replace box enter:
Calendar!$A$3:$I$3,0),0)

find and replace in excel

Choose Replace all
--There should be 14 replacements.

4. Check to see if it worked.
If it did, protect the sheet [ Tools > Protect > Protect sheet (no password needed)]
Copyright © 2010 by Donna Young

,

Share This Page

Click Here to Leave a Comment
 
 

  |  

Share This Page
Donna Young

Donna Young
When you are in the thick of it, it is hard to see the finish line, but it is there.

Donna Young

Link to DonnaYoung.org

Free HomeSchool Resources at donnayoung.org

Copy the link code that is below for your blog or website

See other buttons at Link to DY
First Color Wheel