Could you please e-mail the file so I can work on it. Need to take a look at the data. If you send the file, then also please provide in detail the criteria for processing.
Ajit -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, November 07, 2008 12:47 PM To: MS Excel & VBA Macros Subject: $$Excel-Macros$$ scheduling with excel I want to use excel to schedule services on trucks. Individual trucks can have services of 6 weeks, 8 weeks or 10 weeks apart through the year.Up to a max of 52 weeks. I want to put the last service of last year in column 1 and let excel highlight or populate the cells from 1 t 52 (weeks) according to the service schedule. i.e. if the truck has a service every six weeks and the last service was December 1st, excel would highligh week 2 week 8, week 14, week 20, etc. I tried conditional format with a nested if statement but I can only nest 7 iterations. I also tried producing a table on one worksheet and attaching the data to another with the same limitations. At the moment I am playing with Hlookup to see if I can pull the info from there. The catch is that the table produced should stop calculating the first time it reaches 53 otherwise it displays this years details overwritten by next years. NB on one spreadsheet I will have a selection of these trucks, top two trucks @ 6 weeks, next 2 @ 26 weeks next three @10 weeks etc. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
