Hi All, I’ve been trying to automate a spreadsheet for a while now and I’m completely stuck with how to do it. I have a job card that comes to the office and it has frequency of visits on it. The choice of frequencies are 52 weeks (once a year), 26 weeks (every 6 months), 13 weeks (every 3 months), once a month and once a week. Now the clients will choose any one of these options for the year. We will then input this data in to a spreadsheet. Every Monday morning we will then have to search through all clients to see which visits will take place that week which takes ages. Is there a way to automate this. So once we enter the data in to the spreadsheet it will automatically add visits to other sheets for the visits? If you need more information please let me know.