Excel Roadmap Automation - HELP

Hello all... I need your help with the best solution.

I'm searching for a solution to plot a single roadmap from several different sources. This roadmap is much like a schedule for a location and plotting projected timeframes in which actions will occur.

Attached is a mock-up of what I'm trying to get toward, but automated based on the tabs/sheets listed at the bottom.

In addition, I have the following software at my disposal and unable to utilize add-ons.

Microsoft Excel
Microsoft Visio
Microsoft Project

Can someone please point me in the right direction?

~Nightwolf

define plot? your file looks pretty good as is. it sounds like you need a database.

Adam,

Thank you for the quick reply.

The goal is to update the dates and add additional dates within the Exercise # tabs. I'm looking for the Roadmap TAB to read the dates from the exercise # tabs, identify the location ID, and map/plot an image or highlight rows to identify the time frame in which the exercise is taking place.

Also, how do you recommend going forward with the database?

~Chris

Originally Posted by Nightwolf101

The goal is to update the dates and add additional dates within the Exercise # tabs. I'm looking for the Roadmap TAB to read the dates from the exercise # tabs, identify the location ID, and map/plot an image or highlight rows to identify the time frame in which the exercise is taking place.

you can do all of that in excel if you wish. no need for a database.

Originally Posted by Nightwolf101

Also, how do you recommend going forward with the database?

anyone who works with excel and is used to it should naturally move to microsoft access. anything else would be overkill.

I don't believe your sample file is representative. When you supply a sample file, it should show what it should look like based on the values given. Maybe I'm missing something, but I don't see how what you show on your "Roadmap" sheet is created based on your Exercise sheets.

Gregb11, thank you for replying to my question. Yet, I think you're missing the key details I mentioned within my initial post.

.....Attached is a "mock-up" of what I'm trying to get toward...

At this time I'm starting from scratch and hoping someone within this excel forum could point me in the right direction. VBA_PHP did just that and I appreciate his responses.

Lastly, I believe my problem is clearly painted but will again try to articulate it the best way I can.

GOAL: 1) Have 1 excel workbook with multiple sheets. 2) Input raw data (location name, start date, and end date) on the exercise tabs 3) Create a formula or use VBA to search within exercise tabs for location identified w/in the adjacent column of the Roadmap row. 4) If a date/value is within range the cell will display a number (i.e. 1... 2.. etc).

I've attached another spreadsheet with a draft formula. Can anyone assist me?

Originally Posted by AliGW

Are you still using Excel 2010? If not, please update your forum profile.

Profile updated... thanks!

This worked great... Thanks!