ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi all,
I have a workbook in which I keep records of all of my parkruns and associated challenges etc. (Some of you may be familiar with my previous queries whilst developing this workbook). One such type of challenge is completing ’Regions’ all over the world (in this example, ‘East Midlands’ in the UK. In the workbook, this region’s worksheet is called ‘All Completed Runs - EM R (UK)’.
The challenge requires completing all 43 parkruns within the UK region of ‘East Midlands’ and which are a currently an active event. i.e. Within the ‘parkrun Reader Dump’ worksheet (which contains all of the parkrun source data), the following three criteria need to be satisfied:
At present I just copy / paste the list of parkruns for the region, from the relevant area within the ‘parkrun Reader Dump’ worksheet. So, I just want to automate what I currently do via a manual copy / paste process - which can become quite time consuming, as I have many of these regions in the workbook.
Additionally, I would like them listed alphabetically, as they currently are, in the manually populated version.
I believe the date column should work as it does at present - i.e. Display the first date that I did that particular event, otherwise appear blank.
I’ve highlighted what I think are relevant worksheets in yellow
Link to workbook (One Drive): parkrun Regions Example.xlsx
Apologies the workbook’s large and may take up to a minute to open. - I can’t cut it down in size for this example, as there are so many interlinked worksheets etc. that are required for it to work.
Thanks in advance!
Olly.
I have a workbook in which I keep records of all of my parkruns and associated challenges etc. (Some of you may be familiar with my previous queries whilst developing this workbook). One such type of challenge is completing ’Regions’ all over the world (in this example, ‘East Midlands’ in the UK. In the workbook, this region’s worksheet is called ‘All Completed Runs - EM R (UK)’.
The challenge requires completing all 43 parkruns within the UK region of ‘East Midlands’ and which are a currently an active event. i.e. Within the ‘parkrun Reader Dump’ worksheet (which contains all of the parkrun source data), the following three criteria need to be satisfied:
- The ‘Country’ (Column D) needs to be ‘United Kingdom’
- The ‘Region’ (Column L) needs to be ‘East Midlands’
- The Event needs to be an active one - (Column N - ‘Active Event (Venue)?’) needs to be populated with a ‘1’
At present I just copy / paste the list of parkruns for the region, from the relevant area within the ‘parkrun Reader Dump’ worksheet. So, I just want to automate what I currently do via a manual copy / paste process - which can become quite time consuming, as I have many of these regions in the workbook.
Additionally, I would like them listed alphabetically, as they currently are, in the manually populated version.
I believe the date column should work as it does at present - i.e. Display the first date that I did that particular event, otherwise appear blank.
I’ve highlighted what I think are relevant worksheets in yellow
Link to workbook (One Drive): parkrun Regions Example.xlsx
Apologies the workbook’s large and may take up to a minute to open. - I can’t cut it down in size for this example, as there are so many interlinked worksheets etc. that are required for it to work.
Thanks in advance!
Olly.
