hey guys - this is a tough one and I am in DESPERATE need of your Excel Guru Greatness!!!
I have two spreadsheets - one has leads - one has our ICP criteria on it.
The ICP has like 10 questions with say 4 possible answers per question. Each answer has a "score value" so the answers are...
Fluff provided some great code in the thread below!!!
https://www.mrexcel.com/board/threads1112978/
I have modified it a bit and I need some extra direction on it's functionality, if anyone could be so kind.
Sub Match_Our_Price()
Dim Cl As Range, mydiffs As Integer
Dim Dic As Object...
Hi,
I have the below drug list shared by insurance companies each Monday, this list always varies with multiple fields such as drugs added/removed, drugs shifted to tier 2 from tier 3 or vise versa, unit price increase.. and all the the fields.
example
February 21 sheet lets call it sheet 1...
Hello all, I have data in sheet1 and sheet2. Sheet1 is source data and sheet2 is input. I want to compare data in column A and B of both sheets. i.e comparing as combinations. In the example below, the VBA has to look for combinations, if it matches in both sheets then data in sheet2 B column...
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, 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...
Hello,
I am working on a project that I would like some help on, i have a list that is delivered at 9 am everyday to the same file location. The list is formatted the same everyday, however there are changes. I need to find and record the changes between each day the list is generated. What i...
Hi I need a little help.
I need to compare the value in Sheet1.Col-E with Sheet2.Col-F if they're equal then copy value from Sheet1.Col-A to Sheet2.Col-E.
Thanks for any help
David
Thank you for taking a look at my issue. It is a little long but I have tried to explain it as concisely as possible and will be happy to answer any questions. The included example data shows what i would like the end result to look like. I am using windows 7, Excel 2010.</SPAN>
I am looking to...
Hello,
I used a UserForm to enter information into a few cells in Sheet1. On Sheet2, I have a column of codes (ie 23456; 25678; 12345MD; 15389MD). I am trying to compare one cell from sheet1 to the top cell in sheet2, and if it does not match, move down the column until it does. The BOLD is...
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.