+ Reply to Thread
Results 1 to 6 of 6

vba code to copy charges code,their respective cells and sum their amount

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,054

    vba code to copy charges code,their respective cells and sum their amount

    I Have a workbook workings sheet

    Need to copy a list of charges code at end of column F, G with charges value at end columns AA copy it to column AL to AM , autosum AM COLUMNS

    the charges codes can be 3,4 ,5, 6 depending of po orders (on sheet only 2 shown as example)

    however the code always start with F with a space before F

    AND delete their respective positions

    the workings sheet is dynamic as it may contains 100 to to 10000 rows of data
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-21-2016
    Location
    Emmen, The Netherlands
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    19

    Re: vba code to copy charges code,their respective cells and sum their amount

    Dear Jean,

    If the rows with charging codes are always at the end of the list, and the first row of Charging codes has an empty cell in column E, the following code wil work.

    Please Login or Register  to view this content.
    Succes and let me know if this helps.

    Ton

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: vba code to copy charges code,their respective cells and sum their amount

    Try
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,054

    Re: vba code to copy charges code,their respective cells and sum their amount

    Ton and Jindon

    Thank you

  5. #5
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,054

    Re: vba code to copy charges code,their respective cells and sum their amount

    Hi Jindon

    I noticed that the code looks a = Sheets("expected coding charges code").Cells(1).CurrentRegion.Value
    But what I was looking for that the code look directly in the sheet workings column F and G.

    the expected coding charges was a dummy of what charges may have.

    So could you adjust the code

    thnak you

    Please Login or Register  to view this content.

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: vba code to copy charges code,their respective cells and sum their amount

    Is this how you wanted?
    Find blank(s) in the bottom col.E within the data range.
    Please Login or Register  to view this content.

+ 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. Please Write code for respective Description
    By sai0449 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-18-2015, 12:22 PM
  2. Help with vba code for adding 0 depending on cells' amount of characters
    By ChristopherH in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2014, 09:42 AM
  3. VBA code needed deserately for similar cells but do not know how to copy code!
    By Gunner_gav in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-19-2013, 03:39 AM
  4. VBA code that cut .pdf files and copy in respective folders
    By waqarqrl in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 10-07-2013, 04:46 AM
  5. [SOLVED] VBA Code to Save Copy File without Macro Button and VBA Code on Copy?
    By cychua in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-12-2012, 07:23 AM
  6. Sumproduct formula:Empl Code Payroll Code Amount
    By bluemeg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2009, 02: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1