Forum Discussion
Bryan_Rooney
Jul 01, 2020Copper Contributor
Childcare Service Waiting Lists in Excel
Hi there, I am trying with little success to build a waiting list tool in Excel for a community childcare project. Basically, I am looking to have a sheet 'childlist' which can function as a wa...
hynguyen
Jul 03, 2020Iron Contributor
Bryan_Rooney You can try this workbook by changing Room in column B of Tab Childlist, then click button "Update". Once you are comfortable with its logic, I can help you to modify the VBA code to match your actual workbook.
Disclaimer: My VBA is very rusty so the codes may not be as neat as it should be but it seems to work. VBA would be the most efficient to meet your requirements instead of Excel formulas.