Hello! I am building up a database for a lawn care company - I am trying to set up a workbook that will work as a way to schedule and keep track of our customers services.
What I'm wanting to do is have a different worksheet set up for each program that we offer (5-round, 4-round, 3-round, aeration, mowing, etc.) - basically I would like to have it set up so if I have the "Program" column for a customer set up so it has the different programs, such as "5-Round" or "Mowing" typed in the cell, to then have a function set up to get those customers into a separate "5-Round" or "Mowing" worksheet and, ideally, have it also transfer the other corresponding columns that contain the customers names and addresses.
Any help would be greatly appreciated, hopefully what I explained well enough what I'm trying to do...
What I'm wanting to do is have a different worksheet set up for each program that we offer (5-round, 4-round, 3-round, aeration, mowing, etc.) - basically I would like to have it set up so if I have the "Program" column for a customer set up so it has the different programs, such as "5-Round" or "Mowing" typed in the cell, to then have a function set up to get those customers into a separate "5-Round" or "Mowing" worksheet and, ideally, have it also transfer the other corresponding columns that contain the customers names and addresses.
Any help would be greatly appreciated, hopefully what I explained well enough what I'm trying to do...