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 excel-macros@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
