Transfer data from one file to another

[jmj713]

I don't think this is doable, but I thought I'd ask anyway, because the
people here are super smart and Excel is a monster application.

I have two XLS files that I use constantly to track attendance. The first is
a detailed list of visits, and the second is a monthly summary. Instead of
trying to explain this in words, please take a look at the following
screenshots (names have been erased for privacy concerns):

File 1: http://img212.imageshack.us/img212/8376/image1xx3.png
File 2: http://img267.imageshack.us/img267/4728/image2xs3.png

Now, I have been manually entering the data into File 2 that you see, but
I'd been wondering if it's possible to have Excel look for this data
automatically in File 1. That is, to take from, File 1, for instance,
attendance by DOE, JOHN on January 2, 2008 during SHIFT 1, and enter it in
File 2 as an A for the same person on the same date.

I realize this is very complex, but is it doable? I've made search on this
forum for data transfers but I'm not sure what I did find is applicable to my
sheets.

 

[akphidelt]

This could be done but it would require programming... are you familiar with
VBA?

 

[jmj713]

This could be done but it would require programming... are you familiar with
VBA?

No, unfortunately. I'm just an Excel user.

 

[Roger Govier]

Hi

You could get something vary similar using just your data, and a Pivot Table
for a Report.
I have uploaded an example file for you here
http://www.glanuskfarm.co.uk/shifttotals.xls

 

[jmj713]

Thanks for this example Roger, but this would be difficult for me to
implement. The form has to remain as it is.