Results 1 to 6 of 6

VBA Codes to do unique part codes from one column and also sum of these

Threaded View

  1. 10-06-2021, 04:58 AM #1
    PRADEEPB270
    PRADEEPB270 is offline
    Forum Contributor
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2019
    Posts
    339

    VBA Codes to do unique part codes from one column and also sum of these

    Hi,

    Plaese refer my attachment.

    I have stucked in my working and it is so lenghty.There are 32 sheets consists in my original working file.

    In my attachment,I want to do this working through VBA codes instead of Excel formula one by one sheet.

    Required to do from VBA codes of unique column B,C and D on Column J,K,and L and also put their total on M and O.

    Besides these,one extra column should appear i.e.Column N and it is the value of column O divid by column M.

    Can it be posible through VBA Codes ?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding out the difference between two sets of codes -repetitive codes and interchanged
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2020, 07:05 AM
  2. [SOLVED] Compare JSON data and splitting into corrected codes, deleted codes and added codes
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-01-2020, 06:46 AM
  3. [SOLVED] Compare JSON data and splitting into corrected codes, deleted codes and added codes
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-29-2020, 12:06 PM
  4. How to extract unique code from a column having multiple codes in is cell
    By Antor Ray in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-02-2019, 02:03 PM
  5. [SOLVED] Convert Y Codes from one column to another based on Unique Codes
    By ashishmehra2010 in forum Excel General
    Replies: 2
    Last Post: 10-06-2015, 09:49 PM
  6. [SOLVED] Find the part codes having some indication and arrange them in a new column
    By PRADEEPB270 in forum Excel General
    Replies: 5
    Last Post: 02-20-2010, 05:52 AM
  7. count codes in a column w. several codes in a same cell
    By chum in forum Excel General
    Replies: 6
    Last Post: 11-28-2006, 01:08 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1