I will agree... Will need the excel sheet you are talking abt so that we can
play around and find a solution.
Regards,
Rahul aka Dude
--- On Mon, 10/11/08, Akhilesh Karna <[EMAIL PROTECTED]> wrote:
> From: Akhilesh Karna <[EMAIL PROTECTED]>
> Subject: $$Excel-Macros$$ Re: scheduling with excel
> To: excel-macros@googlegroups.com
> Date: Monday, 10 November, 2008, 7:02 AM
> It will be much easier if you attach the file itself. Your
> question is not
> very clear to me.
>
> Akhilesh
>
>
> On Fri, Nov 7, 2008 at 4:16 PM,
> <[EMAIL PROTECTED]> wrote:
>
> >
> > 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.
> >
> > >
> >
>
>
Add more friends to your messenger and enjoy! Go to
http://messenger.yahoo.com/invite/
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
