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...
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...
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...
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...
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...
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...
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...
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 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.