Advice on my Excel Project

woodland81 · #1 12-27-2010, 03:03 PM

Hello,

I have a project at work to do using Excel. I know the basics and what I was told was a requirement didn't think it was possible so started googling excel functions and capabilities and maybe design it around that.

I thought maybe on the Forums, if I create my basic design, those who advanced knowledge could comment or even suggested what would be good for me to add or remove. All opinions would be great.

The basic outline is we have a list of vehicles & details on the vehicles. These are going to have advertising put on them and will need to record the Start and End Date of current advertising. Some sort of alert is necessary to bring it to attention of when one advertising is coming to an end.

Ive successfully done Todays Date minus due date and a column showing how many days until Due. and added some basic Conditional Formatting.

I inherited the spreadsheet and added few bits myself. The calendar bit was already there, assume its to Log who's advertising is covering what dates. Is there anyway for those square to be auto completed when you enter Start and End Date?

From my research I've seen you can add Buttons to create an alert drafted email that extracts info from the sheet, in my case maybe that would be the Vehicles Due within 7 Days.
Each time an advert ends and new one starts I'd have to manually alter the start and end date. maybe i need some way of recording the info on each advert. Maybe an Archive Button that Sends the info to another Sheet where I just have to enter whos advert it was and then could filter out the truck and view all the past adverts.

I guess im speculating theories which I have no idea how to implement : - /

Any words of wisdom or advice would be brilliant. or if you think what ive got so far isnt very professional.

http://www.mediafire.com/?ew1qsw09dpa60fe

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PST Advice	Panzer	Outlook	1	06-28-2010 06:29 PM
Connectivity issue of Project Professional with Project Server	kashif	Project	0	03-27-2009 06:37 AM
Gantt Chart: MS Project vs. Excel	Nance	Project	2	12-09-2008 01:59 PM
Error 9571 when opening Project Server from Project Pro	mona	Project	0	04-24-2007 07:50 AM
Seeking Excel Expert Advice for Web Publishing	tjmichner	Excel	0	10-25-2006 08:40 AM