palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
Hi all,
I have a sheet called 'Year 8'. In that sheet I have ....
* 25 student names in the range B6:B107 ... each student has 4 rows allocated to them, example, student A has data from C6:AV9
* student results from C6:AV107
* Column Headings in the range B5:AV5
I'd like to have a single button, that when pressed, takes 25 screen shots .... each shot would have the individual student's 4 rows visible directly underneath the row 5 column headings.
I also have a sheet called 'Year 8 Screen Shots'. In that sheet I have ...
* the same 25 student names as those found in the 'Year 8' sheet. These names are found in the range B2:B26
* the 25 student email addresses in the range C2:C26
I'd like the 25 screen shots (taken from the press of the button in the 'Year 8' sheet) to be sent to the corresponding cells in column C of the sheet called 'Year 8 Screen Shots'
Is this possible ?
Kind regards,
Chris
I have a sheet called 'Year 8'. In that sheet I have ....
* 25 student names in the range B6:B107 ... each student has 4 rows allocated to them, example, student A has data from C6:AV9
* student results from C6:AV107
* Column Headings in the range B5:AV5
I'd like to have a single button, that when pressed, takes 25 screen shots .... each shot would have the individual student's 4 rows visible directly underneath the row 5 column headings.
I also have a sheet called 'Year 8 Screen Shots'. In that sheet I have ...
* the same 25 student names as those found in the 'Year 8' sheet. These names are found in the range B2:B26
* the 25 student email addresses in the range C2:C26
I'd like the 25 screen shots (taken from the press of the button in the 'Year 8' sheet) to be sent to the corresponding cells in column C of the sheet called 'Year 8 Screen Shots'
Is this possible ?
Kind regards,
Chris