OX-27
3rd Nov 2009, 11:35
I’m after some help regarding transferring data from one worksheet to another worksheet in the same workbook
What I have at the moment is a Personnel Holiday Workbook containing 9 worksheets. Sheet 1 is a yearly calendar with the names of each person annotated in column A, this carries on down the page for each month.
The other worksheets (2-9) are against the individual’s name, each sheet containing a grid from 1-28 (number of days holiday entitlement)
When holiday is booked, the dates requested are put in the grid on the sheet assigned to the person - (1 box = 1 date)
I would like to know if there is a way of transferring the number of days that have been booked, on to the calendar sheet (sheet 1). If 1/1/10 & 2/1/10 are booked holiday I would like sheet 1 to show 1 & 2 against the persons name and on the correct dates.
I hope you are still with me, and would be grateful for any info on how to achieve this.
What I have at the moment is a Personnel Holiday Workbook containing 9 worksheets. Sheet 1 is a yearly calendar with the names of each person annotated in column A, this carries on down the page for each month.
The other worksheets (2-9) are against the individual’s name, each sheet containing a grid from 1-28 (number of days holiday entitlement)
When holiday is booked, the dates requested are put in the grid on the sheet assigned to the person - (1 box = 1 date)
I would like to know if there is a way of transferring the number of days that have been booked, on to the calendar sheet (sheet 1). If 1/1/10 & 2/1/10 are booked holiday I would like sheet 1 to show 1 & 2 against the persons name and on the correct dates.
I hope you are still with me, and would be grateful for any info on how to achieve this.