Hello, I hope someone can help me. I have some basic knowledge of Excel but am stuck trying to get it to do something via a macro or formula that I currently do manually.
I run a swimming club and I keep all the records in an Excel sheet (Office 2007).
When we do up a program for the kids, it has their past results in it over a particular distance. What I do is use the filter on my sheet to filter the date so I can get results only for the past 12 months, then I specify a distance. Some races are over 50m, some 75m, some 100m, etc as we use a 25m pool for the young ones. So I set a filter on the distance that will give me +50m or -50m from a specified distance (eg: greater than 50m and less than 150m). Then in the name field I use the filter again and enter the kids name. From this result, I take the last 4 rows of data and copy & paste into another worksheet that we use to print out the program.
It all works fine, but it is very time consuming and people have told me that it could be done with a macro or some sort of formula. I only have a basic knowledge of these things and have some formulas in my sheet, but nothing with multiple criteria, etc.
Can this be done? Can I specify the criteria of date, dist range and name and get it to give me the result of last 4 swims into cells on my other sheet? If so, could someone please give me an example of what this sort of formula would look like. I have tried reading an excel manual but it is over my head I'm afraid, but I have been able to use formulas in the past that have been shown to me and change them by adding the correct cell references.
Many thanks if anyone can please help.
I run a swimming club and I keep all the records in an Excel sheet (Office 2007).
When we do up a program for the kids, it has their past results in it over a particular distance. What I do is use the filter on my sheet to filter the date so I can get results only for the past 12 months, then I specify a distance. Some races are over 50m, some 75m, some 100m, etc as we use a 25m pool for the young ones. So I set a filter on the distance that will give me +50m or -50m from a specified distance (eg: greater than 50m and less than 150m). Then in the name field I use the filter again and enter the kids name. From this result, I take the last 4 rows of data and copy & paste into another worksheet that we use to print out the program.
It all works fine, but it is very time consuming and people have told me that it could be done with a macro or some sort of formula. I only have a basic knowledge of these things and have some formulas in my sheet, but nothing with multiple criteria, etc.
Can this be done? Can I specify the criteria of date, dist range and name and get it to give me the result of last 4 swims into cells on my other sheet? If so, could someone please give me an example of what this sort of formula would look like. I have tried reading an excel manual but it is over my head I'm afraid, but I have been able to use formulas in the past that have been shown to me and change them by adding the correct cell references.
Many thanks if anyone can please help.