I have set up a spreadsheet to keep track of my daily workouts. The spread sheet is set up as follows:
Column A: Date
Column B: Description of 1st workout
Column C: workout 1 score
Column D: Additional work
Column E: Description of 2nd workout
Column F: workout 2 score
with each month being on a new worksheet.
Each workout can range from 1 to 10 different exercises. I am wanting to write a macro that will enable me to search for all workouts that contain a particular (or combination of) movements. For example if todays workout involved pull ups, box jumps and squats I want to be able to search back through all previous workouts that include squats or all previous workouts that include the combination of both pull ups and squats and have those days entire row copied to new worksheet so i can look over my scores of similar workouts and track my progress.
I would like to search columns B, D & E (in numerous worksheets) for particular words (e.g push up) and have the entire row in which they appear to be copied to a new worksheet.
I have no experience in writing macros and any help would be greatly appreciated.
It would be really helpfull if you could upload your workbook using a site like www.speedyshare.com.
I was thinking about an inputbox which would let you input and seacrh for a workout. Put the results in a summary sheet. Then you could search for another workout to be placed in the summary sheet for you to look for combinations of workouts. Then you can manually clear the summary sheet to look for other workouts.