palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
Every week, I receive a spreadsheet of school sporting fixtures from an organising body, for example ...
I currently have a different spreadsheet that uses index/match to draw relevant information from Touch Football to create a 'Fixtures Information Sheet for Parents' ...
In the image I showed of the original spreadsheet (the one I receive from the organising body), the location of the touch football information currently lies in the range A21:H38, however, from week to week, it won't always be in that range, nor will it always be the same number of rows (for example, next week it might be in the range A16:H45), so my current index/match formulae won't always read correctly.
I have no control over the structure and cell-labelling of the spreadsheet given to me by the organising body, so I can't adjust things to suit my needs without weekly effort, and I'm trying to set this up so it creates my 'Fixtures Information Sheet for Parents' automatically with no weekly re-visit.
To my query ... with the position of the Touch Football information in the 'organising body spreadsheet' likely to change from week to week, is there a way I can accurately extract the information I need ?
Kind regards,
Chris
I currently have a different spreadsheet that uses index/match to draw relevant information from Touch Football to create a 'Fixtures Information Sheet for Parents' ...
In the image I showed of the original spreadsheet (the one I receive from the organising body), the location of the touch football information currently lies in the range A21:H38, however, from week to week, it won't always be in that range, nor will it always be the same number of rows (for example, next week it might be in the range A16:H45), so my current index/match formulae won't always read correctly.
I have no control over the structure and cell-labelling of the spreadsheet given to me by the organising body, so I can't adjust things to suit my needs without weekly effort, and I'm trying to set this up so it creates my 'Fixtures Information Sheet for Parents' automatically with no weekly re-visit.
To my query ... with the position of the Touch Football information in the 'organising body spreadsheet' likely to change from week to week, is there a way I can accurately extract the information I need ?
Kind regards,
Chris