+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 - how to get another sheet to update itself, ETC..

  1. #1
    Registered User
    Join Date
    08-18-2010
    Location
    Landstuhl, Germany
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Excel 2007 - how to get another sheet to update itself, ETC..

    I am working on a project that has information on employees on sheet 1 labeled "ALL". I have a sign-in roster on sheet 2 labeled "Training Roster".

    Some of the information on sheet 1 I need to auto update to sheet 2 as I type or end the line to include, borders, fonts, and background fills. Also, deletions.

    The cell columns on sheet 1 are D, E & J. The cell columns in sheet 2 are A, B & C.

    Sheet 1 starts data at Row 2. Sheet 2 starts data at Row 3.

    Sheet 1 complete page is A1:AB118

    Sheet 2 complete page is A2:C133

    Is there a macro that can help me with this? I have tried numerous types of macros but they are not all fitting to the plan. Some are only doing part of the job.

    Can anyone help?
    Attached Files Attached Files

+ 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