Entering data every 14th column across sheets

**raydaw** · 02-13-2008, 06:44 AM

I have created a booking diary which automatically books timeslots across 12 months (on sheets) with days of month (columns) and times (rows).

It works fine for one off or weekly bookings but some people want bi-weekly! At the end of each month I have entered "end" in the empty cells of each row and added an instruction to go to the next sheet (month) when cell value is "end". However, with bi-weekly bookings this means I cannot determine the start point for new month - for weekly bookings I have a named range for the first day of the month call "Monday1" etc.

Bet there's an easy way to do all that but I'm a bit of a newby at the VBA lark. HELP

**royUK** · 02-13-2008, 07:48 AM

Why aren't you using dates?

**StephenR** · 02-13-2008, 07:50 AM

This is a cross-post: http://www.ozgrid.com/forum/showthre...d=1#post416344

**royUK** · 02-13-2008, 07:58 AM

Thanks Stephen

raydaw

Post back with an acknowledgement that you have read & will follow the Forum Rules & I will upload an example workbook that I~ have.

**raydaw** · 02-13-2008, 09:46 AM

Didn't realise the Oz Grid question had been posted - my web link keeps crashing!

Confirm I have read & will abide by the rules Roy. Any help would be appreciated.

**royUK** · 02-15-2008, 04:47 AM

Thanks for that Ray.

This is an example I put together a while ago. It has a sheet to enter bokings & "lookahead2 sheet that enables you to see bookongs for 16 days, this updates by changing he date in A1