Code to delete rows across 12 worksheets

[madforgolf]

Title should read to delete data from rows, not delete rows

Hi Guys,

I have a holiday sheet with a summary page.
Im looking for the best way other than manually going through each worksheet to delete data in the rows if a person is removed from the summary sheet.

The names are in the summary A3:A49. not all names may reach A49 due to which group is using a copy.
The months are in the other 12 worksheets, starting from April to March'13.
The data for hols are in range B3:AF49 (Days in the month) in all months sheets.

Is there a way for a macro to check that if a name is removed (say from A16 in the summary sheet, that then checks all rows with names, and then deletes the data from range B16:AF16 on all other worksheets (except the summary sheet as the forumlas are on this page.) because the summary sheet A16 is blank? This can apply to all names in Column A in summary sheet.
I dont want excel to move cells up if blanks are found.At present i delete the data from the rows effected manually if a person leaves the group even if there are spaces spare for others to be added.

Hopefully i have not confused anyone to much.

Cheers

Marty

 

[adam087]

Any chance you could show some samples of the sheets (any sensitive information scrubbed naturally).

Thanks
Adam

 

[madforgolf]

how do i insert the pic of the Excel Jeanie?

 

[madforgolf]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
2	STAFF NAME	APR	MAY	JUN	JUL	AUG	SEPT	OCT	NOV	DEC	JAN	FEB	MAR	ENTITLED	BOOKED	REM
3	STACEY REID	0	3	0	0	0	0	0	0	0	0	0	0	20	3	17
4	HELENA DOHERTY	0	0	1	1	5	0	0	0	0	0	0	0	20	7	13
5	ISOBEL McARTHUR	0	0	0	2	5	0	0	0	0	0	0	0	20	7	13
6	CHRISTINE HOLMES	0	0	0	0	0	0	0	0	0	0	0	0	20	0	20
7	SHARON MARTIN	2	0	0	3	0	4	0	0	0	0	0	0	20	9	11
8	STACEY RITCHIE	0	0	0	4	0	0	0	0	0	0	0	0	20	4	16
Holiday Entitled

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	April-2012	1st	2nd	3rd	4th	5th	6th	7th	8th	9th	10th	11th	12th	13th	14th	15th	16th	17th	18th	19th	20th	21st	22nd	23rd	24th	25th	26th	27th	28th	29th	30th
2	NAME	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	N/A	N/A	Y	Y	Y	Y	Y	N/A	N/A	Y	Y	Y	Y	Y	Y	Y	Y
3	STACEY REID
4	HELENA DOHERTY
5	ISOBEL McARTHUR
6	CHRISTINE HOLMES
7	SHARON MARTIN																					HOL	HOL
8	STACEY RITCHIE
April