xlwhole

ok so I have been racking my head against the wall to try and figure this out. I have a userform that when the user clicks the ok button. I need to get this to perform a vlookup the value from a combobox in sheet "Employee Data" in range B4:B49. It needs to return the value in column 3. But...

Hello, I have t below code and I need to add another range. For Each c In sh1.Range("AT5", sh1.Range("AT" & Rows.Count).End(xlUp)) - I want to add range ("AR5", sh1.Range("AR" & Rows.Count) Set f = sh2.Range("O:O").Find(c.Value, , xlValues, xlWhole) - I want to add range ("M:M").Find(c.Value...

Hi Guys. Can someone please help me to consolidate/simply the following code. I have a need to delete a number of rows in a large sheet that contain variable keywords (10) within a range of text strings in column A. Each key word only appears in the cells of column a once, the remaining text...

Hi All, The code bellow is looking for values (Materials*) but its not finding en exact match, its finding any cell with Materials or any part of the word in it and copy and pasting from there :/ Any ideas? :) Thanks, Dan Sub MaterialsInsertNewRow() ' Materials Controls Dim b As...

The cut and sort feature is not working. I need it to look in column 3 and if any of the 3 names appear cut and place them at the bottom after the sort placing 3 empty rows between the final row and the ones I am pasting. Here is the code...

My problem: I have a large excel sheet containing responses from on online survey. The online survey system exports in mainly string form with each answer being in its own column. I already have an SPSS data input set up with particular variables which already has entries. So I am unable to...