Design issue; and finding and displaying row on other workbook

1. An academic course is divided into two sections: lecture and
discussion. The lecture section contains all classes, but the
discussion classes do not. The discussion section is further divided
into three subsections, each containing multiple classes.

The need is to coordinate student attendance and grades for all
sections. Currently we have 1 lecture section workbook with all
student names, IDs, and other info; and 3 discussion section workbooks
with the same only for the relevant subsection. And then there is a
consolidation workbook where lecture and discussion are put together
and attendance and grades totaled horizontally by student. The
teachers email in their workbooks weekly for the consolidation.
(Ideally, we'd just all update a common database, but that isn't
practical at this point.)

Currently the consolidation workbook just composed of links to the
teacher workbooks, and they were gotten by copying and pasting links
from those. So at weekly consolidation time, all the teacher workbooks
are loaded and then the consolidation. This seems to work well as long
as no rows are out of place or deleted in any workbook, so care must
be taken that no workbook has been sorted differently from the
original linking.

My question is, does this seem a reasonable design or not, or should
something else be done, like copying rows per session or lookup etc.

2. We have another workbook of private student info by student ID, but
it may or may not contain all the IDs on our attendance/grade
workbooks. We'd like to be able to click on a link beside an ID in our
attendance/grade workbook, or select a cell containing an ID number
and pressing a button, and be taken immediately to the correct row in
the student info file, to send an email or get the phone number.

Attendance Workbook A

     ID               Absences        etc.
      A
1 444555              4
2 666777              6


Private Info Workbook B

      ID                Email
      A
1 333554            joedoe@aoll.com
2 444555            janedoe@aoll.com
2 666777            (empty)

So say we want to get from 444555 in A to 444555 in B quickly without
having to manually do a Find or filter. Any easy way of doing that?

Appreciate any help, thanks!

0
2/9/2007 6:14:43 AM
excel 39879 articles. 2 followers. Follow

0 Replies
585 Views

Similar Articles

[PageSpeed] 39

Reply:

Similar Artilces:

VS2005/Vista issues
I spoke too soon about VS2005 Vista SP1 being more reliable; doing rather trivial single-threaded app debugging, I've managed to crash it six times in the last hour. Each time it seems to crash for a different reason, or at least as the consequence of some completely different action on my part. For those who have been using it, however, I've got a couple questions: It must be run as administrator, which requires an administrator password. What I'd like to do is set myself up to run as a normal user, but with the privileges of running as administrator whenever I want to with ...

Stack Chart Legend Display
I'm making a stack chart based on a quality report. My X-Axis is displayed in Time (Weeks) The Y-Axis displays defect counts by week. There are close to 20 different categories a defect can fall into, however, most of the time there are 5 or 6 categories that have data week to week and some catergories that have not had a defect yet. How do I make the stack chart legend only show the categories that have data attached to it with a number larger than zero. This way the legend won't display all 20 categories, but only the ones that have a value. For Example, let's say I h...

Issues with linking to exported source files
We recently loaded excel 2007 onto my PC at work, but kept excel 03 on it as the default program since the rest of the company still uses excel 03. I noticed that now my links do not work. Most of my excel reporting is done as a shell summary workbook that links to multiple source files that have been exported from our database interface. (These can be exported as .xls or ..xl5) Before loading in 07, all of my source files were exported as .xls and worked fine. Now, even though I've totally removed excel 07 from my pc and unistalled/ reinstalled 03, the links will not ...

How to find the cookies hit by paticular URL
Hi i am woring on AntiSpyware application, currently i am checking cookies. Could anybody please tell me about "How to find the cookies hit by paticular URL", like when i log in to yahoo i would be informed that yahoo is reading or writing the cookies. How i get count of cookies hit by particular site. Thanks in advance.... Mujtaba ...

how do i change to the new design in outlook 2007
Outlook 2007 is installed on my computer but everytime I open the program the old design is what I see. > Outlook 2007 is installed on my computer but everytime I open the > program the old design is what I see. The Ribbon is only available in new message/appointment/task windows, not to the main Outlook window. -- f.h. Microsoft Outlook MVP ...

Excel 2000... Missing row and column designators. #4
...

Shared workbook and VBA problem
Shared workbook and VBA problem Hi Group, I am new at this Excel stuff and I am hitting my head on a silly problem that I am sure many have seen before. I wrote a very simple spreadsheet where I use the Calendar control to pick some dates. Everything was fine until I decided that I needed to share it on the network with other users. As soon as I share it the calendar control stops working. I get a "runtime error 1004, unable to set left property of oleobject class". That's because the first thing I try to do is position the calendar. If I don't do that, it still doesn't...

design templates
Once I download a new design template (Letterhead), how do I make it available to all new documents. Currently, I can use the new template for one document. However, when I import any data, it disappears. Then, when I go to choose a publication design, the template is not available. How can I make new/downloaded design templates available from the publication designs window? Are you asking about those from the Office web site? Once the download is complete, save as... -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Char...

Switching to design mode causes VS 2008 to freeze.
When I'm working on a web project and switch a page from source to design mode, VS hangs. Anybody have any thoughts? This doesn't appear to project specific - just that's it's a web page (.aspx) when it happens. TIA - Jeff. ...

Design specifications and guidelines
A small question. Where can i find the Design Specifications and Guidelines - Visual Design. Spacing: How many DLUs should there between 2 group boxes (vertically arranged) in a Dialog box? best regards bav In theory, as many as you want, but in practice, only as many as you use. Since Microsoft has abandoned any attempt to maintan GUI guidelines within their own products, there is very little reason to be too wound up about this kind of trivia (I have largely ignored most of it. Build a dialog box that looks good, and nobody is going to be counting pixels). For group boxes, you can...

New Install Issues
I have just followed the 35 Page guide for installing CRM on a SBS 2003 server, but when I access the CRM website I have issues doing EVERYTHING....I have even logged in as a user with rights to EVERYTHING.... I try to create a new contact "Error, please contact your system administrator" or account....same thing... Any ideas? Check to make sure the CRMSecurityService is running on your server. -- Matt Wittemann http://icu-mscrm.blogspot.com "RcooperLTI" wrote: > I have just followed the 35 Page guide for installing CRM on a SBS 2003 > server, but when I ac...

Automatically insert row between groups of records
Hello! Can someone provide a suggestion for the following scenario? I have a list like the following (or I will, once I apply a macro solution I found in another post). I'd like to scan through the list, insert a row at each change in value in Column1 (column headers don't actually exist in my worksheet), and insert a lookup formula in Column 2 of the newly inserted row which uses the value in Column 1 to lookup a corresponding value on another worksheet. Column1 Column2 Column3 1000 Requirements 40 1000 Design 5 1008 Requirements 10 1008 Design 8 Run a macro that produ...

front end and back end server issue
I am planning to use front-end back-end exchange server in the company network. We have several exchange servers in different geographic sites. For example: We have 3 exchange servers in site A and another 3 in site B. If I set one exchange server in site A to be front end server, will it cause problem to the other 3 servers in site B? I suppose I can always use the front end server in site A for the clients in site B. Is it correct? Hi, Can you provide more information? Ideally: What version of Exchange (include SP) in each site? Does each site have it's own SMTP gateway Are bo...

Using decisions in Access design
Hi all, I want to set up an introductory page for an Access 2007 project. On this page would be some instructions and links to different pages with the usual form entries. Each of these pages would be different enough to warrant their own page and fields, but there would be similarities between all pages that need to keep them in the same database. Example: I have that introductory page with instructions and links to eight new pages. Fields 1-3 on each of the eight pages would contain identical types of information (Name, URL, and Password). These would have the same fiel...

Design
Hello, I have been working through serveral lessons within a workbook course but the problem that I am having is when I want to setup my own spreadsheet outside of the workbook I have problems with doing that. What type of approach should I take with designing a spreadsheet. Kelly I think that would depend on what it would be used for , Inventory, calculating values such as Cpk, Ppk, Stdev.... Sales report... they all have their own needs as to how you would design your spreadsheet, so that it suits the best of your needs. "Jessica@aol.com" wrote: > Hello, > > I...

Repeat Rows at Top
Is it possible to repeat rows at the top of each page, but not for the Final Page? For instance I repeat rows 1 and 2 and have page breaks for a total of seven pages. I want the repeated rows on pages 1-6 but not my totals page which is page 7. Thanks. Not possible in one print job. Two separate print jobs. pages 1-6 with rows to repeat then page 7 without. You could do it with VBA but will still be two print jobs. Gord Dibben MS Excel MVP On Wed, 6 Jan 2010 12:46:02 -0800, Gandor <Gandor@discussions.microsoft.com> wrote: >Is it possible to repea...

issue with options
Everytime I try to change my options I get a pop up telling me "Cannot Access Directory" I am trying to change my autosave options to another folder location but I cannot do anything because of this. Can somone tell me what is wrong? thanks Bacchus Perhaps you have entered more than 53 characters in the file path to your default file location in Tools>Options>General or in the Autorecovery path. Try re-naming folders in the path to come up with less than 53 characters then re-enter your new path. You may have to edit the registry in order to change the path if You can...

Trouble Installing CRM - SQL Server
The CRM install gets stuck trying to find the SQL Server. Errors: "Can't find" or "SQL Agent must be on" yet it is on - I can SQL ping the server from the CRM server. The CRM admin has top Forest access to the SQL server. I've recycled the SQL services, rebooted booth CRM and SQL servers. Very misterious. Anybody have any ideas? I had some issues with this. I re-installed SQL server. It seems there is any issue with CRM and SQL if you add active directory to a server after you install SQL. "Darryl" wrote: > The CRM install gets stuck trying to...

Extracting data from multiple rows
I have a list of 40 records in one column, each record about 20 rows long, with different data, but with the same field headings (100, 245, 260, etc.) that looks something like this: 100 Joe Smith 245 Book of home repair 260 Simon and Shuster 440 Language tape 500 Audio File 655 Audiobook 856 Bibliographic record URL 994 Location designation 100 Mary Jones 245 Cooking light 260 Random House etc. If I only want to view certain fields, like 100 and 245, how can I extract that data from all the records and create a new table with that information? Like this: 100 Joe Smith 245 Book of home repa...

owa issue with the url
hello all, we have exchange 2003 and we want to use the owa features. where im confused is..... the url for owa. heres what i have... I added an A record in the dns owa.my domain.com to point to the mail server. and on the public side we had our web hoster to create a redirect that look like..... http://my domain.com/exchange resolves to http://mail.my domain.com/exchange my problem is ive see companies the do not use the switch ( /exchange or public ) this is what i want on the public side http://owa.my domain.com on the private side http://owa.my domain.com i dont want the ...

Outlook password issues...
After having set up outlook I find that there seems to be a password issue with the email account. Outlook will not save it! I have tried deleting the account and resetting it, and even as far as uninstalling and reinstalling the suite again, still same issue. Checkdisk shows no errors. Odd thing is that this happens with xp pro and 2003 pro as well. Have tried both... Could this be a virus that none of my sanners are picking up on? Help Please!!! Thank you, Brian "Brian LaPlante" wrote in message news:781875A5-D247-46E3-A87B-5605B618C059@microsoft.com... > After having ...

Bug or By Design?
Hi, I recently had a problem with one of my XPath expressions which led me to believe there might be a bug in XmlNode, although it could be by design since I didn't find anything in the KB. Consider the the code appended below. The function CleanEmptyElements removes all empty elements from the document using a XPath expression. As you will notice in the code, I add two empty elements. If you check the resulting testXml.xml file, the "SpecialEmptyElement" element, though emtpy is still present. The only special thing about it is that I assign a null string to the InnerT...

Locking rows (not columns)?
Hi I download and store my bank statements in an Excel spreadsheet. This is maintained in conventional 'bank statement' format; ie columns for date, payee, amount, account balance, with one statement entry per row in chronological order. I find it very useful to be able manipulate the spreadsheet eg by sorting alphabetically by payee, so I can easily see all payments made to a particular company grouped together. However, it's very easy to use the 'sort' function incorrectly, so that the date/payee/amount columns become completely dissociated from each other, and if some...

copy a formula over two rows but increase the row # by 1 only
How do you copy a formula from one cell in row "a" to row "c", but only increase the row reference to "b" automatically? Dave, Copy it to row 'b' then drag the copy from 'b' to 'c' HTH, Bernie MS Excel MVP "Dave" <Dave@discussions.microsoft.com> wrote in message news:5F8E96F9-15A7-4742-AC0D-40A0D64F14D9@microsoft.com... > How do you copy a formula from one cell in row "a" to row "c", but only > increase the row reference to "b" automatically? Rows are numbers, columns are letter...

Enterprise Reporting Issue
We are on ER 7.5. My users are having an issue with a filter formula. It is as follows: =(-amt+ AC[40000:89999] D4['01-????':'04-????'].AMT)/1000 The above formula returns all account amounts for 01-???? through 03-???? but it does NOT include 04-???? as it should. However, the following formula works, but is too cumbersome to actually apply to their work: =(-amt+AC[40000:89999] D4['01-????','02-????','03-????','04-????'].AMT/1000 Could someone let me know what might be going wrong? Thank you! Lisa ...