Excel-want to make house chore list alternating 2 people?

Question

Hello,
Want to make a chore list for me and my husband where my husband and my names will alternate for each task:
will I list each chore on the left...then can it automatically alternate our names?.....if you have a better idea or any help, I'd appreciate it.....infact, you might be saving my marraige, thanks.
If there is anyway to do the minor choes daily, then larger chores only on weekends, like mow lawn and mop floor, that would be great.
Daily would be dishes, make bed, etc....

I was hoping I could put in the info, then have it alternate automatically, no?

Answer 1

Here is one way to create your chore-chart.
Type in the following titles across row 1:(Use your names for husb & wife)

Husband - Wife - Minor Chores - Major Chores - Husb. only Chores - Wife only Chores This goes from col A1 to F1.

List minor chores down col C, list major chores down col D, List chores only the husb. can do , list only the chores the wife can do (the last 2 must be things the other pers. CAN'T DO).

Now skip a few rows from the bottom of above entries. (let's say it is row 20)

type in the following formulas:
in B20 thru G20--- Mon, Tues, Wed, Thur, Fri, Sat/Sun
in A21--- =$A$1
across B21 --- =$c$2, =$c$3, =$c$4, =$c$5, =$c$6, =$d$2
across B22 ---(if there are more for husb, add them on this row)

Now the wife list. Put 2 blank rows below husb list and type (starting in col A thenMon thru sat/sun col):
$B$1, =$c$7, =$c$8, =$c$9, =$c$10, =$c$11, =$f$2
If there are more for Wife, go down 1 row and add them.

The last thing to do is create a 2nd week just the opposite of 1st week by copying the data from A20 thru G20 and down these cols to whatever was your last row.

Now paste this block wherever you want (below, alongside, or new sheet). Now on this block reverse the formula between the husb & wife ($A$1, $B$1cells so that the tasks will switch.

This is only an example so make it any way that works.

You now can switch every other weeks chores.

Answer 2

That is a little difficult to do for something that seems relatively easy. Why not try something like this.

Column Headers
Choir Your Name Your Husbands Name
Item X
Item2 X
etc

This would still print on one page and you could alternate the information as you see fit. If your trying to make it alternate weekly or monthly then I would insert a Column for the Month and copy the same items and present them down so you know what is expected month by month. I hope that helps.

Answer 3

I dont know your situation entirly, but if you need to make an excel spreadsheet to divy up tasks i think you have an underlying problem.

I once faced a similar problem with my roommates. Basicly we had troubles. I was fine with a bit of mess, and he was a messphobiac. This of course caused problems when it came to the cleaning roster, cause i couldnt give a flying fudgepacker.

Making a roster wont solve the underlying problem, you need to address the issues you have. Dont know if its something you can fix with a yahoo question though :)