+ Reply to Thread
Results 1 to 3 of 3

Linking information from one worksheet to another

  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    texas
    MS-Off Ver
    Excel 2011 MAC
    Posts
    16

    Linking information from one worksheet to another

    I have attached a basic attendance template that contains formulas for points with tardies, absences, etc. from January through December.

    When I add an new employee in January, he/she is not added through December. How do I link this info for every month without having to go to each month and doing it separately?

    For example, if I add John Smith in January, he will automatically appear in February, March, April, etc.

    Also, if I change the format in January, is it possible for the formats to change for all of the months as well? For example, if I change the font or font size.

    Any comments/suggestions are appreciated!!

    Thank you.
    Attached Files Attached Files
    Last edited by amytr1122; 01-15-2013 at 01:23 PM.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Linking information from one worksheet to another

    Welcome to Ozgrid.

    I would opt for using a single worksheet for tracking, using a classic database structure, meaning, at minumum:

    1. Top most row of the data table is a header row
    2. Cells in top row (spanning across columns) are field descriptors (e.g. Name, Data, Position, Points, etc)
    3. All rows below are records
    4. No merged cells
    5. No blank rows or columns used to spacially separate data (resize them instead) - blank cells in a "record" are fine

    Since you are recording exceptions (absent, tardy, etc), you only make entries as these occur. All data in one sheet makes analysis easy.

    Not sure about Excel on Mac, but if you can use tables (search on Excel 2010 Tables), then all formatting/formula are automatically carried forward to new rows/data entries. If you use Data Validation in the name column, you could create dynamic named range for a name list (maintained on a spearate sheet) and set the Data Validation to use this list. Using a dynamic range for the name list will automatically include new names and you only have to maintain a single list of names to be used anywhere in the workbook.

    In answer to your question about changing the font and size on all sheets at once:
    This can only be accomplished two ways.
    1. Group Select all of the sheets you want to change, select the cells on, say, the first sheet selected and make the changes. All sheets will be changed. You are not limited to font changes, but any kind of change to a worksheet will affect all sheet that are grouped, such as resizing rows or inserting columns or even entering data into cells. Just remember to ungroup the sheet afterwards or you will have unintended changes.

    2. The other method is VBA.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Registered User
    Join Date
    12-27-2012
    Location
    texas
    MS-Off Ver
    Excel 2011 MAC
    Posts
    16

    Re: Linking information from one worksheet to another

    Thank you for the response. I am new to Excel, so much that you have said to me is like a foreign language. Please excuse this. I am going to attempt to edit the spreadsheet like you have said.

    Again,

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1