Results 1 to 7 of 7

Search for unique numbers and copy thier specific data to another sheet in excel VBA code

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Search for unique numbers and copy thier specific data to another sheet in excel VBA code

    I have a workbook which has three sheets.

    On Second Sheet named "Grade Wise" i have raw data. I want to create a button on 3rd Sheet named "Sheet1" which will copy data from 2nd sheet to 3rd sheet.

    On 2nd sheet which has raw data, in column A and B data is repeated due to fact that these farmers have provided different grades with different weights.

    Now the challenge here is i want to copy unique Farmer numbers and names (of column A and Column B) data for each farmers to 3rd sheet (As shown in attached picture).

    In 2nd sheet, Column C has different grades, whose starting alphabets are X,C,M,B and their third alphabets includes A,F,C also.

    CHALLENGE 1: Now, i want to copy sum of all X to X (on 3rd sheet column D), sum of all C to C(on 3rd sheet Column E), sum of all M to M (on 3rd sheet Column F) and sum of all B to B (on 3rd sheet Column G) for each unique number--As Shown In Attached Picture.

    (VBA CODE IS WRITTEN FOR THIS CHALLENGE AND IS WORKING PROPERLY BUT I WANT TO ADD BELOW OPERATIONS TO THE VBA CODE) SHEET SAMPLE IS ATTACHED

    CHALLENGE 2:It should also look for third alphabet(A,F,C) and copy their Sum of all A to A (on 3rd sheet column N), Sum of all F to F (on 3rd sheet column O), Sum of all C to C (on 3rd sheet column P) as shown in attached pictures I need VBA code for this operations please help me. :Untitled-1.png
    Attached Files Attached Files
    Last edited by Zahid0111; 03-11-2020 at 10:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vba code for copy specific data to another sheet
    By rishikrsaw in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-07-2017, 05:01 AM
  2. [SOLVED] Vba code to copy unique email id data from input sheet to output sheet
    By UPA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-09-2017, 07:19 AM
  3. Replies: 4
    Last Post: 05-16-2014, 06:30 AM
  4. VBA code to select all data then copy and paste all unique value to another sheet
    By ahs004 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2013, 09:07 AM
  5. Macro to search sheet for certain criteria and copy specific data to cell
    By ThaGonz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2012, 12:34 PM
  6. Replies: 11
    Last Post: 11-23-2011, 04:39 AM
  7. Replies: 0
    Last Post: 11-19-2009, 09:20 AM

Tags for this Thread

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