Hello,
I have a Sheet which is an automated calendar (called ‘Calendar’) which looks like this:
01/01/2012 Sunday 1 St. Godric
02/01/2012 Monday 2 St.Lawrence
03/01/2012 Tuesday 3 Lord Worsley
On another Sheet called BH I have a list of bank holidays which looks like this:
New Years Day Good Friday Easter Monday May Day
01/01/2000 21/04/2000 24/04/2000 01/05/2000
01/01/2001 13/04/2001 16/04/2001 07/05/2001
01/01/2002 29/03/2002 01/04/2002 06/05/2002
01/01/2003 18/04/2003 21/04/2003 05/05/2003
What I am trying to do is put together a bit of code that will run through column A in the Calendar sheet and look up each date
In the range (call it A1 to D5) on the BH sheet. If it finds a match then I want it to copy the name at the head of the column in the range and
Paste it in front of the text in column 4 on the Calendar sheet, to produce:
01/01/2012 Sunday 1 New Years Day, St. Godric
02/01/2012 Monday 2 St.Lawrence
03/01/2012 Tuesday 3 Lord Worsley
Seems easy enough, but I’m a little stumped, I can record something that’s close to it and manipulate it from there like I normally do with Macros\VB, any help appreciated,
Thanks
Andy
I have a Sheet which is an automated calendar (called ‘Calendar’) which looks like this:
01/01/2012 Sunday 1 St. Godric
02/01/2012 Monday 2 St.Lawrence
03/01/2012 Tuesday 3 Lord Worsley
On another Sheet called BH I have a list of bank holidays which looks like this:
New Years Day Good Friday Easter Monday May Day
01/01/2000 21/04/2000 24/04/2000 01/05/2000
01/01/2001 13/04/2001 16/04/2001 07/05/2001
01/01/2002 29/03/2002 01/04/2002 06/05/2002
01/01/2003 18/04/2003 21/04/2003 05/05/2003
What I am trying to do is put together a bit of code that will run through column A in the Calendar sheet and look up each date
In the range (call it A1 to D5) on the BH sheet. If it finds a match then I want it to copy the name at the head of the column in the range and
Paste it in front of the text in column 4 on the Calendar sheet, to produce:
01/01/2012 Sunday 1 New Years Day, St. Godric
02/01/2012 Monday 2 St.Lawrence
03/01/2012 Tuesday 3 Lord Worsley
Seems easy enough, but I’m a little stumped, I can record something that’s close to it and manipulate it from there like I normally do with Macros\VB, any help appreciated,
Thanks
Andy