Okay, this is my first post on the site, and I hardly know anything about the advanced features of Excel. But I'm working on a golf handicap tracker for myself, and need some help.
I have a sheet that includes a list of golf courses that I have played, along with that course's name, slope, and rating (along with some other general course information). The information for each course is on its own row.
On another sheet (the handicap tracker), I currently have it setup where I have to enter the course name, slope, and rating (along with my score) to calculate my handicap. Therefore, I have to click to the course sheet to gather the course information, and then I must click back to the handicap sheet and type it in manually.
Is there a way to set it up (either with regular formulas or with code) to enter a course name on the handicap sheet and have that course's information be automatically pulled from the courses sheet and put onto the handicap sheet?
I have a sheet that includes a list of golf courses that I have played, along with that course's name, slope, and rating (along with some other general course information). The information for each course is on its own row.
On another sheet (the handicap tracker), I currently have it setup where I have to enter the course name, slope, and rating (along with my score) to calculate my handicap. Therefore, I have to click to the course sheet to gather the course information, and then I must click back to the handicap sheet and type it in manually.
Is there a way to set it up (either with regular formulas or with code) to enter a course name on the handicap sheet and have that course's information be automatically pulled from the courses sheet and put onto the handicap sheet?