Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing bookings in a calendar
Excel 97
I use a database to record bookings, that is a list of individuals' names and dates for which we have booked them, often up to about 12 months into the future, (along with several other columns of details.) In a seperate file I also have a calendar in which I show these individuals' bookings, simply by inserting "B" in the appropriate column, against that individual's name. The dates are column headers running across the top of the sheet and the names run down the side to identify the rows. I want to write a macro to automatically insert a "B" inthe correct cell for each booking we have made. I should be grateful for any help with this task. Many thanks Bob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing bookings in a calendar
If you want to send a workbook(s) with a sample of the list of bookings and
the calendar, I can provide something for you. -- Regards, Tom Ogilvy "Bob M" <Bob wrote in message ... Excel 97 I use a database to record bookings, that is a list of individuals' names and dates for which we have booked them, often up to about 12 months into the future, (along with several other columns of details.) In a seperate file I also have a calendar in which I show these individuals' bookings, simply by inserting "B" in the appropriate column, against that individual's name. The dates are column headers running across the top of the sheet and the names run down the side to identify the rows. I want to write a macro to automatically insert a "B" inthe correct cell for each booking we have made. I should be grateful for any help with this task. Many thanks Bob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing bookings in a calendar
Bob,
Tom Ogilvy replied to me ( http://en.allexperts.com/q/Excel-105...ookups-VBA.htm ) on what shoud work for you. I had basically the same thing. Hope that helps. And dont forget to give Tom the credits. Brian "Bob M" wrote: Excel 97 I use a database to record bookings, that is a list of individuals' names and dates for which we have booked them, often up to about 12 months into the future, (along with several other columns of details.) In a seperate file I also have a calendar in which I show these individuals' bookings, simply by inserting "B" in the appropriate column, against that individual's name. The dates are column headers running across the top of the sheet and the names run down the side to identify the rows. I want to write a macro to automatically insert a "B" inthe correct cell for each booking we have made. I should be grateful for any help with this task. Many thanks Bob ----------------------------------------------------------------------------- Less Spam Better enjoyable experience Visit : news://spacesst.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create a page by page yearly diary to record bookings | Excel Worksheet Functions | |||
Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
excel calendar - list of names displayed on calendar | Excel Worksheet Functions | |||
Showing orrect FY-QTR for FED GOV calendar | Excel Discussion (Misc queries) |