Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 19th 12, 03:15 AM
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 2
Default Help Linking Rows Between Sheets While Sorting

Hello All,

I am fairly experienced with Excel, but unfamiliar with Macros.

I am working on a database for student assessment in which the first sheet lists student names and demographic information, followed by several additional sheets each for different subjects (math, science, etc.). The sheet for each subject is linked to the first sheet. For example, each student's name and demographic data is carried over into each subject sheet. This allows me to make any adjustments to demographics on the first page only instead of on each subject sheet. Since some of the data is dynamic, and there are many subject sheets, this is a fairly important feature.

The subject sheets are fairly complex themselves well. They are used not only to record grades and compute averages, but also to disaggragate data based on a variety of parameters.

Overall, everything is working well, but I have come across the following problem: If a new student is added to a class, when the student is added on the first sheet, the name carries over to all other sheets, but a new row is not added in each of the subject sheets which causes all of the data to mis-align. Is there a way to automatically program the database to add a corresponding row in each subject sheet whenever a new row is added to the first sheet, and if so, how?

Thanks ahead of time for any responses.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
linking within a workbook and sorting bmac Excel Discussion (Misc queries) 2 October 8th 09 04:23 PM
Linking then sorting mbwooten New Users to Excel 1 June 20th 07 04:31 PM
Linking messed up when Sorting Jugglertwo Excel Discussion (Misc queries) 1 March 17th 06 08:23 PM
Linking sheets when sorting row and column data Sean 3DD Excel Worksheet Functions 0 January 5th 05 12:21 PM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017