+ Reply to Thread
Results 1 to 2 of 2

insert row for new items before TOTAL row based on matching between two sheet

  1. #1
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    insert row for new items before TOTAL row based on matching between two sheet

    hi experts
    I have two sheets DATA and before . the sheet after just to understand what I want . the result should be in sheet before . so what I want match data between two sheets in COL B,C ,D for each item in COL A the values should be in last columns IMPORT, EXPORT because every time I insert theses columns so when if new data are existed in sheet data but not existed in sheet before then add to before TOTAL row as highlighted by red and if there are existed into two sheets then should pull the values and put in last columns IMPORT , EXPORT as highlighted by blue
    note: when insert new row should not affect for the borders and formulas . I put the result in sheet after
    Attached Files Attached Files
    Last edited by Mussa-A; 08-25-2021 at 07:13 AM.

  2. #2
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: insert row for new items before TOTAL row based on matching between two sheet

    is there any help?

+ 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. [SOLVED] insert TOTAL row for each items are duplicated from sheet to another
    By MKLAQ in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-16-2021, 12:49 PM
  2. [SOLVED] inser row befor total rows
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-12-2020, 03:04 PM
  3. Sum from multiple items in a list, based on rank, until a total is met
    By tim_71 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-19-2013, 09:17 PM
  4. Creating a total (sum) of items matching a text value
    By Decibel_116 in forum Excel General
    Replies: 4
    Last Post: 03-16-2012, 10:27 AM
  5. Populate Cell Based on Matching Items
    By d0518mills in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2011, 05:23 PM
  6. Remove matching items from a workbook based on a master list
    By Apel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2009, 08:20 PM
  7. [SOLVED] Best way to inser file property into and excel sheet (cell)
    By Luc in forum Excel General
    Replies: 3
    Last Post: 07-05-2005, 04:05 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