find & offset

I have looked at a lot of different ways to do this and tried to incorporate their ideas into this sub but I keep getting different errors every time I run it. I am searching for "0" in the listed ranges of the STATUS SHEET and finding the offset value which is the vehicle number. then finding...

Hello All, I have something similar situation on my workbook. Sheet1 has large amount of data with Product name (column A) and current value (column D). There are some blank records in between too. Sheet2 has Product name (column A) and sold amount (column B). There are no blank records in...

Hi, Sorry for two posts about the same thing, won't let me delete the first one. I want to create a VBA code so that I can look up the string "Category 1" and use it as a reference to add a certain number of columns based on another cells value. The new cell values are to have the headings...

Hi, It's been a few years since I've done any vba coding and I can no longer stitch together small codes by searching for answers across different forums - so I'm hoping someone will be able to help me with the entire code... What I need is: 1) In row 4, if the value in the first month being...

I am trying to take my current code, that uses a Find function to search for the value in cell "H4" (this value is in the worksheet where the code is) and find it in a second workbook searching from Columns A3-A100000 (Find functions start at the next row after the first, hence why in my code I...

Hi all, I am looking for a macro that will look down a list and report anything that's not on the list. My list is on Sheet1 in column A Starting with the value of cell A1 I want to search 3 sheets, "AttendanceA", "AttendanceB" and "Returns". There might be multiple instances of the search...

Hello, I'm stuck and I hope you guys can help me with this simple problem. I'm trying to get the market returns (A) to sum over the days where the stock returns (B) is not available. I have tried with if and lookup function but I can't get it right. I have copied a small section of the issue...

Hi,There are two workbooks which I refer as workbook 1 and workbook 2.What I need to get done is there are some values in column "B" of workbook 1,and I need to find these values from column "I" of workbook 2 and copy correspondent value of column "K" of workbook 2 and paste it to the column "C"...

Hello, The is a problem with part of my Macro and I can't seem to figure it out. When a cell in column B is Security Total I need the cell in column A to be . . This code will work on one cell. Even if I repeat it, it won't work. Any suggestions? Set Found =...

Good afternoon, Sorry if this is repeated by I'm not even sure how to work this. I have a call that has the value "Total Cash". I am using this to find the cell. I can also use find and replace. Cells.Find(What:="TOTAL CASH", After:=ActiveCell, LookIn:=xlFormulas, _...

Hi, I have a reference sheet called 'Hosts List' which has one row per host. It contains lots of term dates which are grouped by academic year. There are six columns of term dates per academic year which go across the sheet, with multiple academic years. At the start of each group of date...

Hi, I need to create a nested loop involving a find, copy and paste but don't know how to. There are two sheets, ws and ws2. In ws, where acad_year is a certain value, the first loop goes through the list looking for pop_fin (the unique id of the record) and matching it up in ws2. However...

Hi, I have created some code for doing some vlookups to auto-populate data into a spreadsheet list. Against each record, the user selects the correct value from a drop down list, then, based on the value chosen, the vlookups find the matching value from a different sheet (the ‘Hosts List’) and...

I have data in my cell d2 that has lots and lots of data merged together. I am attempting to write a formula that finds the specific word, and then give me the code associated with it. the data I want is never in a set format/length. The formula I am attempting to use is: =MID(D392,FIND("BR...

Hello. In columns A and B (A2:A500 and B2:B500) I have a list of product names (text cells) and in columns C and D their corresponding values (numbers in the range from 0 to 1000). When product is in column A his value is in column C (in the same row of course) and when the product is in...

I'm able to search the website html text for a specific string. I'd like to go one step further and, if that string is found, then return the word(s) that follow the found string. Example web text: "The player's final review: Excellent" I would search for "final review:" and would want to...