I need an Excel genius

I am currently working on a project to reorganize a section within my company that has the potential to completely change the HR/administrative culture of my 700-Soldier organization. But I need an Excel guru.

Anyone out there?

 

I use it a lot, but I have no idea if I am a guru.

What do you want it to do?

 

I need one master tracker with multiple tabs to pull ver basic information from seven identical subordinate trackers. For example, when my admin officer opens the master tracker and looks at Tab A (evaluations, for example), I need her to be able to see, sort and filter the identical data it's pulling from the subordinate trackers.

 

If you can do that with Excel, then you are way over my head.

This sounds like a database, though.

 

Exactly what I was thinking. That Access might be your better bet.

 

Culturally, I'm afraid, we're stuck in the excel generation.

 

So, when you open your "master tracker" (I assume you mean the master spreadsheet) you want it to update with data that people have entered into other "subordinate trackers" (I assume you mean other spreadsheets). Is that correct?

 

Yep. And the seven subordinate spreadsheets will have multiple tabs.

 

OK. I am assuming that all these spreadsheets are saved on the same network, correct? The data in the master spreadsheet will only be as good as the last time that each of those seven linked files were last saved. You are not going to get updates in real time. Assuming that is all OK ... you will also need to protect (very highly protect) most of the information on the seven linked files so that the persons entering information into them cannot change anything at all except enter data into select fields.

Now, assuming that all the above is true ... I can do that for you, but not sure I can direct you through it over the 'net. If all the above conditions are met, though, yes it is possible.

 

I think all those conditions can be met.

 

Bags, the Access program Lies talks about, and she seems waaaaaaaaay more knowledgeable about this than me, is already in your system if you have MS Office, which you should since you have Excel.