D Marshall
New Member
- Joined
- Jan 14, 2010
- Messages
- 6
I have a workbook set up as a team calendar, the first sheet "Programme" contains all the calendar data with a second sheet "dashboard" containing some calculations.
Within "Programme" columns D to NI represent every day of the year and rows 3-32 represent staff, columns A-C holds a list of staff names and various qualifications whilst row one is the days of the week and row 2 is the date (dd/mm/yyyy) starting at 28/12/2019 in 'D'.
Twice every week I want to take a snapshot of the upcoming week, is there a way to utilise the camera tool to automatically display an image of the upcoming week that i can then Ctrl+C into an e-mail?
The 'image' would always cover the same area of cells, i.e. seven columns wide by 32 rows. By way of example next weeks range would be in AA1:AG32 and the following weeks would be AH1:AN32 etc.
I'd like an image of the relevant range in "Programme" shown in "dashboard" of the seven columns corresponding to Monday to Sunday of the following week (derived from today's date). The row numbers for the range would not change, only the column numbers which would be derived from an existing formulas as shown below;
.
I've tried inserting an image and then changing the cell reference to indirect or index formulas referencing cells B7:D7 but without any joy.
Does anyone have any idea how this could be achieved?
thanks,
Dave
Within "Programme" columns D to NI represent every day of the year and rows 3-32 represent staff, columns A-C holds a list of staff names and various qualifications whilst row one is the days of the week and row 2 is the date (dd/mm/yyyy) starting at 28/12/2019 in 'D'.
Twice every week I want to take a snapshot of the upcoming week, is there a way to utilise the camera tool to automatically display an image of the upcoming week that i can then Ctrl+C into an e-mail?
The 'image' would always cover the same area of cells, i.e. seven columns wide by 32 rows. By way of example next weeks range would be in AA1:AG32 and the following weeks would be AH1:AN32 etc.
I'd like an image of the relevant range in "Programme" shown in "dashboard" of the seven columns corresponding to Monday to Sunday of the following week (derived from today's date). The row numbers for the range would not change, only the column numbers which would be derived from an existing formulas as shown below;
I've tried inserting an image and then changing the cell reference to indirect or index formulas referencing cells B7:D7 but without any joy.
Does anyone have any idea how this could be achieved?
thanks,
Dave