compare & add rows

  1. SkywardPalm

    Aligning sections for comparison based on section number

    I'm working on a variance calculator and am in search of a way to Line up the matching sections and the proper variances. Where there are missing sections from previous/current, there should be blank cells rather than missing the blank sections and being unaligned with the wrong sections...
  2. B

    Excel Formula to add lines dynamically based on the source data

    Hi Team, I have data in sheet1 as below. ABCDEFGHIJ2FirmNumberName1/11/2021ZoneTotal3Gagu Personal3439Adamcova, Milena14:1822:308.20.837.37OST1077.04Gagu Personal3441Balaz, Gabriel14:1922:187.980.837.15TRK571.05Gagu Personal3477Basno, Dorina14:0522:298.40.57.9TRK341.06Gagu...
  3. B

    VBA Code to add lines by comparing to workbooks

    Hi People, Can someone help me with below requirement. I have two workbooks(Wk1 and Wk2) with same headers and data. now i want to compare WK1(latest data) with WK2(old data) and add the lines of data to WK1 which is present in WK2 but not in WK1. to compare I can use column A in both sheets...
  4. W

    VBA code to compare data in two columns and update

    Hi, Have been trying to write a logic but not able to gte through, can someone help me with this. I have below data in A & B columns of sheet1. AB1Senior ManagerManager2GERMANOTTA, DOMINIC3BONOMO, MICHAEL4HALL, TAMARA L5PRADHAN, JEETENDRA 6RANGARAJAN, JAGANNATH K7STRATFORD, CHRIS8STRATTON...
  5. W

    VBA code to compare two columns in different worksheets

    Hi, I have below code where I am trying to compare two columns of data in different worksheets and if anything new is found then it has been added above last row of sheet1 in column "A". the below code is only adding empty row. can someone help me with this. It has to basically compare column A...
  6. W

    VBA code to compare two lists and update

    Hi, Can someone help mw with a VBA code for the below. below is my input list AB1Name1Name22A3A14A25A36A47B8B19B310B211B412C13C514C615D16D717Grandtotal and this is my output list. AB1Name1Name22A3A14A25A36A47B8B39B210B411C12C513C614Grandtotal this is my expected output...
  7. P

    Trying to compare columns only if Column B and D are empty

    I have a massive spread sheet that is missing data. I need to compare it with data in another workbook, but my criteria is to only compare column C from both workbooks if columns B and D are empty in workbook 1. If it is empty and a match is found then it needs to copy over the data from...
  8. P

    Finding only one value when comparing two workbooks

    I am using two workbooks to search for missing information that is in one book but not in the other. My code works but in some instances I have multiple matches being returned and only one value is entered in to the cell. I need to be able to add the first match to the existing row in workbook1...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top