MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Please I really need help!


Posted by Jenny on November 02, 2001 2:14 AM

: I have set up this excel timecard spreadsheet and now I am not sure if it set up correctly to get the information I need from it.

Would this be better if I did this in MS Access instead of excel?

I just don't see any way of sortng it like she wants it and still keeping the pretty formatting she wants.


Posted by Kevin on November 02, 2001 5:05 AM

I think that Access would be your best bet. You could combine all of your pages in Excel to one table in Access, with all of your fields for date, employee, hours worked, etc., etc., and then you could sort, filter, and arrange the table in a multitude of different ways. Nothing against Excel, but if you know how to use Access, I definitely think that you should give it a shot.

Posted by Mark W. on November 02, 2001 5:20 AM

Jenny, in order to do the kind of analyses that
you mentioned you really need to organize your
data into a single columnar list. I strongly
urge you to consult the Excel Help Index topic
for...

1. About using a list as a database
2. Guidelines for creating a list on a worksheet

Posted by Joe Garza on November 02, 2001 5:49 AM

Re: Real Answer

If I understand you you have a tab for each employee, and 26 columns of data.

The others are correct, but if you feel your way deep into this one.

I would create a "summary sheet", and "Paste Link"("copy" your data, then "paste special", then click on "paste link") all of your data.

Later, you can go back and reorganize.

Then you can create your graphs and such

Posted by Mark W. on November 02, 2001 8:07 AM

Gee, I thought mine was the "real answer" : ) (nt)