matching

I have 200 Workbooks in one centralized folder. Each Workbook has 10 Sheets. Each Sheet is Identical throughout the entire workbook so there is no mixing and matching required. Is it possible to sum all 200 workbooks and generate one workbook of 10 sheets? TIA

Any help would be appreciated, I have a workbook where I need to find fuzzy duplicates, however I am not sure how to code in VBA to get excel to do what I want. I was looking to get it put a percentage and row number of the duplicate in the two columns next the data to indicate a duplicate/...

I have a spreadsheet with 13 columns and 900 rows (column 1 is zipcodes). I am trying to complete a vlookup that will look at the zip codes in row 14 (I added). Once I receive the matching zipcodes, I need to show the entire rows (Col 1 - Col 13) that has the matching zipcodes. Is vlookup...

Hello, I am trying to figure out this problem. Basically I have 2 sheets with identical purpose - to reflect the stock. The old sheet was messy and not sorted, no constant locations, duplicate locations, however I know that newer entries were added to the bottom. So each location has 3...

Hi guys, For Each cellImp In hideRange If cellImp.Value = NoOfImpressionsBox.Value Then cellImp.EntireColumn.Hidden = False Else cellImp.EntireColumn.Hidden = True End If Next cellImp I've got a range ws.Range("BF4:BY4"), that gets pasted to a function. Both the value of...

Hi! So here's a broad description of what I want to do: Given values in column B [1, 6, 3, 18... -5, -6, -22...] I want to write a script that gives a unique tag in column C next to each pair where a positive and negative value will cancel out. EXAMPLE: B | C 3 | 1 7 | 4 | 1 | 2 -3 | 1...

Hi there, I am trying to use Index Match multiple criteria function in excel but the value being returned is incorrect. Not sure how to fix it. this is the array formula: ={IF(OR($AE4="PRIMARY";$AE4="MGDC...

Hello Guys, I have the following table: <colgroup><col><col><col></colgroup><tbody> Driver Location G.J. WS G.J. CC G.J. CC G.J. HE G.J. HE G.J. DD G.J. DD G.J. TD P.S. TD G.J. T4 P.S. T4 </tbody> In this, I want to get a result in third column...

<tbody> Location Exp Date Status North North East South West North URGENT READY URGENT REQUIRED East 1/11/2018 South 20/05/2018 North South 1/06/2018 East 15/10/2018 West 10/06/2018 </tbody> I have a table (Above)...

Please help me out ... here I am attaching snapshots of two excel sheets 1. has description 2. names of persons What I wanna do is that , I want to check the names of person are matching should indicate me in red or whatever color in different cell from description list. If name is already in...

Hi All, I need a script that will use the "ThisWorkbook.Path" and looks for a folder called "sFiles" in the workbook path and if not found, then create it and inside it, create other folders matching the names for all items in TextBox2. TextBox2 is populated by TextBox1 Thanks in advance Kelly

Hello, For the life of me, I can't figure this one out... I am trying to search and return all records matching 2 criteria. This formula works perfectly for 1 criterion, but I am unable to get it a second one in there... Working Formula for 1 criterion...

Hi, I have a UserForm that takes data from a table on "Raw Data" tab and inserts it into a different table on "All" tab. Now things are getting complicated and I would appreciate some help/advice: With Vlookup I can have 1 criteria, but I need to return values based on 2 criteria. <tbody>...

Hello everybody, This is how looks my table (for better view look here) My goals here are : When somebody enters a data in SKU column which is matching to already existing one the new data will go one roll below the old data and copy several details like Description, Unit, Cost...

Dear All, I was look for a formula if a cell text is matching partially then vlookup from another sheet for matching value. Cell A 10.253.19.7 in Cell B & C, the formula should have if Cell A 10.253.19.* then vlookup the value from sheet2 and display Subnet mask & gateway respectively...

Hi there guys, Been a while since I've been using excel and the brain is a bit rusty.... I'm Just trying to get a formula right so that if someone enters a name, the matching phone number comes up next to it... breaks down like this.. I have a column A with names and a column B of phone...

I have a set of data Column A = Names , Jimmy, Jon etc Column B = Countries; Spain, Germany etc Column C = "Yes" of "No" Column D = Numbers: 1,2,3 etc In column E, I would like a formula where the if the row in column C = "Yes" it sums the previous 3 scores in column D, matching "Jimmy" in...

Column E has data Im looking for that matches with column O. Looking for the 4 smallest numbers in column O that match with column E. Want to average the next numbers of matching column E. Heres what Ive come up with for one match: =INDEX(E4:E66,MATCH(SMALL(O$4:O66,2),O4:O66,0)+1,1) TIA

I'm looking for some help/pointers with some vba (which I'm not great with). What I'm trying to do is this.... Column A on worksheet 1 contains "Item Number" Column A on worksheet 2 also contains "Item Number" I want to find matching ones in worksheet 2 and cut and paste the data from...

https://www.dropbox.com/s/ro4aftz437...2018.xlsm?dl=0 I'm trying to build a code that does the following when button is clicked.... - Enter Date (Value) into Cell's B2, C2, D2, E2 on "Daily Alignment" Sheet. - Import from "Deputy Availability" sheet all of the people who are scheduled to work...