ExcelBanter - Merging cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Merging cells (https://www.excelbanter.com/excel-worksheet-functions/267699-merging-cells.html)

Hi,
I have a spreadsheet where I have taken dates, times, customer names, employee names and generated a calendar. It is almost done, but there is one bit I cannot crack. The calendar is broken down into 15m sections, so a 1hr appointment should have 4 boxes shaded in with the text "1hr Mr Smith"

So far, I can do this by deleting the content of the 3 cells after the one with the text - hope you can see this from the example I have posted.

I am using Excel 2003.

Unfortunatley I can't attach excel, but I can attach a screen shot of the calendar.

What I am looking for is a formulae that can allow the text to be shown over 4 shaded boxes for 1hr, and for 8 shaded boxes for 2hrs etc (as per the THURSDAY example on the attachment)

Quote:

Originally Posted by graeme_706 (Post 961574)

Hiya,
Just a short note to say i have cracked the problem, got a very useful macro that merges the appropriate cells to give me exactly what I was looking for. Thanks for looking.
If anyone wants a copy of it, i'll post it somewhere for you to pick up.