<div dir="ltr"><div>We've gone one step up in the organizing of spreadsheets to use a google sheet so everyone is working from the same ongoing doc (you can share the sheet with anyone with a gmail account too)! However, that only solves avoiding duplicates and incorrect versions (still a good step!). We too are looking for an affordable program to manage things like renewal notices!</div><div>In both excel and google sheets, you can have that top bar allow for categories to organize your data - that could be helpful for ensuring you have the full list of members on a single main sheet and then categorize them by type (i.e. we have Family, Senior, Student, Youth, Adult) and then when you need to, you can use that top row to sort them (or sort them by expiry date or any other data you have been collecting).<br></div><div><br></div><div>-Joelle<br></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Rossland Museum & Discovery Centre<br>(250) 362-7722<br><a href="http://www.rosslandmuseum.ca" target="_blank">www.rosslandmuseum.ca</a><br><br>Open Year-Round - Tuesdays to Saturdays: 11am to 5pm<br>Find us on <a href="http://www.facebook.com/rosslandmuseum/" target="_blank">Facebook</a>, <a href="http://twitter.com/RosslandMuseum" target="_blank">Twitter</a>, and <a href="http://www.instagram.com/rosslandmuseum/" target="_blank">Instagram</a>!<br></div></div></div></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jan 28, 2020 at 12:06 PM Moderated BCMA subscriber listserv. <<a href="mailto:bcma@lists.vifa.ca">bcma@lists.vifa.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">The Summerland Museum & Archives is looking to update how we manage our memberships. Currently, we use a set of excel spreadsheets that are a little disorganized, and we would like to know how other smaller institutions handle their memberships. Due to our size, we are unable to purchase expensive membership management software, but if anyone knows of cheaper alternatives or a way to make our excel sheets more efficient we are all ears!<div><br></div><div>Thank you,</div><div>Julien<br clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><table style="border-spacing:0px;border-collapse:collapse;background:rgba(0,0,0,0) none repeat scroll 0% 0%;color:rgb(51,51,51);font-family:Roboto,Helvetica,Arial,sans-serif;font-size:14px;table-layout:fixed;border:0px none;margin:0px;padding:0px" width="100%" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td cellpadding="0" cellspacing="0" border="0" style="padding:0px 7px 0px 0px;border-color:rgb(212,0,120);border-style:none solid none none;border-width:medium 3px medium medium;width:87px" valign="middle"><font size="1"><img src="https://www.designhill.com/uploads/data/email-signature-img/thumb_q06q9f20rb1ln810s8teopsvu0_5cae30caba4e6_1554919626.jpg" style="border: 0px none; vertical-align: middle; max-width: 100%; width: 87px; border-radius: 50%;"></font></td><td cellpadding="0" cellspacing="0" border="0" style="padding:0px 0px 0px 7px" valign="top"><table style="border-spacing:0px;border-collapse:collapse;background-color:transparent"><tbody><tr><td colspan="2" style="padding:0px 0px 3px;line-height:1.4;font-weight:600"><font size="1"><span style="color:rgb(212,0,120);font-family:Arial,sans-serif">Julien</span> <span style="color:rgb(212,0,120);font-family:Arial,sans-serif">Butler</span></font></td></tr><tr><td colspan="2" style="padding:0px;font-family:Arial,sans-serif;line-height:1"><font size="1">Curator & Archivist</font></td></tr><tr><td colspan="2" style="padding:0px;font-family:Arial,sans-serif;font-weight:bold;line-height:1"><font size="1">Summerland Museum and Archives</font></td></tr><tr><td colspan="2" style="padding:0px;line-height:1.4"><span style="font-family:Arial,sans-serif;margin-right:10px"><font size="1">(250) 494-9395</font></span></td></tr><tr><td colspan="2" style="padding:0px;line-height:1.4"><span style="outline:currentcolor none 0px;display:inline-block;font-family:Arial,sans-serif;margin-right:10px;background-color:rgb(255,255,255)"><a href="mailto:archives@summerlandmuseum.org" style="outline:currentcolor none 0px;display:inline-block" target="_blank"><font size="1" color="#666666">archives@summerlandmuseum.org</font></a></span></td></tr></tbody></table></td></tr></tbody><tbody><tr><td colspan="2" style="padding:0px;width:608px" width="100%"><font size="1">The Summerland Museum and Archives respectfully acknowledges <br>that we are situated on the unceded and ancestral territory of the Syilx Peoples.</font></td></tr></tbody></table></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
_______________________________________________<br>
BCMA mailing list<br>
<a href="mailto:BCMA@lists.vifa.ca" target="_blank">BCMA@lists.vifa.ca</a><br>
<a href="http://lists.vifa.ca/mailman/listinfo/bcma" rel="noreferrer" target="_blank">http://lists.vifa.ca/mailman/listinfo/bcma</a><br>
</blockquote></div>