+ Reply to Thread
Results 1 to 4 of 4

Formulas or Function for copying datas from 1 sheets to another within a workbook

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    Borno, Nigeria
    MS-Off Ver
    Excel 2003
    Posts
    5

    Formulas or Function for copying datas from 1 sheets to another within a workbook

    Hello all,

    Please I need your assistance on how to copy datas or scores from one sheet to another by using Formulas & Functions.

    I tried to attached excel file as an example, but it couldnt.

    Let me explain briefly:
    The file contains 11 Sheets, the first 4 Sheets has students Continous Assessment of various subjects (about 7 subjects) in 4 different classess.

    What I want is, the formulas or functions to use on how to copy the total score in all subjects for each student in various classess (Primary 1A, Pri 1B, Pri 1C, Pri 1D) to Sheets (1st Term, 2nd Term, 3rd Term) as class summary.

    And thirdly, the total scores, position, grade & average to also appear in the Result Sheets for each student of various classes (Result Sheet 1A, Result Sheet 1B, Result Sheet 1C, Result Sheet 1D).

    Hope my explanation is not comfusing.

    I will be very much greatful, if you could solve my problem.

    Thanks alot.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Formulas or Function for copying datas from 1 sheets to another within a workbook

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    02-11-2014
    Location
    Borno, Nigeria
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Formulas or Function for copying datas from 1 sheets to another within a workbook

    Hello,

    I attached an excel file in respect of my above request as an example.

    Thanks.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-11-2014
    Location
    Borno, Nigeria
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Formulas or Function for copying datas from 1 sheets to another within a workbook

    Bump no respond.

    Please assist.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying sheets from a closed workbook - Excel 2013 crashes Sheets.Add
    By perducci in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2014, 09:03 PM
  2. [SOLVED] Need VBA code for copying datas from different sheets to one sheet
    By kesavanprabhu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2013, 05:42 PM
  3. datas in workbook 2 is not getting updated when datas in workbook 1 is changed
    By share knowledge in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2011, 12:21 PM
  4. correcting "Linked" formulas after copying sheets to another workbook
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2009, 11:00 AM
  5. Copying New sheets using formulas involving previous sheets
    By mcsc03 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-09-2008, 06:01 PM

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