+ Reply to Thread
Results 1 to 9 of 9

Suggestion Rq: copying data from Sheet 1 and pasting in a sheet 2 for Calc purpose

  1. #1
    Registered User
    Join Date
    12-18-2015
    Location
    Coimbatore, Tamilnadu
    MS-Off Ver
    2013
    Posts
    38

    Suggestion Rq: copying data from Sheet 1 and pasting in a sheet 2 for Calc purpose

    Dear All,

    I have data of class wise student strength (each schools) in few columns and standard Price of Books per student in columns along with actual price given. I have to arrive total class strength, total of standard book price and actual price (to find deviation) in sheet 2.

    Please suggest me which method to follow to bring the data in sheet 2.

    to me. i have only idea to use "=" function.

    Just want to know is there easy or efficient way to do this.

    TIA

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Suggestion Rq: copying data from Sheet 1 and pasting in a sheet 2 for Calc purpose

    send a sample of your data and the expected output please

  3. #3
    Registered User
    Join Date
    12-18-2015
    Location
    Coimbatore, Tamilnadu
    MS-Off Ver
    2013
    Posts
    38

    Re: Suggestion Rq: copying data from Sheet 1 and pasting in a sheet 2 for Calc purpose

    please check.. attached sample
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Suggestion Rq: copying data from Sheet 1 and pasting in a sheet 2 for Calc purpose

    hard to say without seeing what you are working with, but it sounds like you need to look at SUMIF or SUMIFS

    OK, I just saw your file - could you include some sample answers?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    12-18-2015
    Location
    Coimbatore, Tamilnadu
    MS-Off Ver
    2013
    Posts
    38

    Re: Suggestion Rq: copying data from Sheet 1 and pasting in a sheet 2 for Calc purpose

    Attached... please check
    Attached Files Attached Files

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Suggestion Rq: copying data from Sheet 1 and pasting in a sheet 2 for Calc purpose

    Thanks for the file

    Trying to see where the data is coming from...sheet2 has entries for Adam and for school1 to school4, I can find no reference to any of these on sheet1? Can you either point me to where they are - or, provide data that matches your requirements. Remember, you know exactly what you what, we have no idea

  7. #7
    Registered User
    Join Date
    12-18-2015
    Location
    Coimbatore, Tamilnadu
    MS-Off Ver
    2013
    Posts
    38

    Re: Suggestion Rq: copying data from Sheet 1 and pasting in a sheet 2 for Calc purpose

    assume that.. each row will be replicated in the sheet 2...however not all rows but only what is given in the sheet 2...

  8. #8
    Registered User
    Join Date
    12-18-2015
    Location
    Coimbatore, Tamilnadu
    MS-Off Ver
    2013
    Posts
    38

    Re: Suggestion Rq: copying data from Sheet 1 and pasting in a sheet 2 for Calc purpose

    any suggestion guys ???

  9. #9
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Suggestion Rq: copying data from Sheet 1 and pasting in a sheet 2 for Calc purpose

    It is not clear in the sample available. Could you please send the expected results based on the input?

+ 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 columns of 10 data sets and pasting them into a new sheet
    By novious1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2015, 10:59 PM
  2. Scanning data, and copying/pasting hits on new sheet
    By Hesler14 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2013, 02:59 PM
  3. Replies: 9
    Last Post: 05-13-2013, 05:43 AM
  4. Copying All the visible Rows in the current sheet and pasting it to another sheet
    By vickyyar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2012, 08:46 AM
  5. [SOLVED] Copying a range of data in a column and pasting to another sheet
    By JP777 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2012, 07:44 PM
  6. copying and pasting data in separate sheet
    By ashwin_bist in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2008, 09:36 AM
  7. Pivot table - copying & pasting the data into another sheet
    By chedges in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2007, 10:30 AM

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