Comparison of data between three spreadsheets

J

John

I want to compare data between three spreadsheets in three different XLS
files.
More specifically, I have a project progress report that I run every three
weeks. I want to do a comparison of the finish dates that are attached to
the projects. If the date cell was flagged with a red color in the last
report and the report before that, I would like a flag (of some type) to let
me know that that project should be looked at this week.

My question is can I do this? If so, how? Or would it be more effective to
develop a little database in MS Access that can do this for me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Calculating an average of data between two dates 1
Need Help with a VBA subroutine 0
multiple cell comparisons...nested if formulas? 1
How can I link data in three different cells? ck# date amount 2
Default IF Date Is between 2 Dates then output additional column 1
data comparison/update query 3

Top