macro - search

I have a large list where I'm trying to put everything into family categories. As an example, if I have the following list, a person could go through and identify that there are families of parts: ABC, ABCD, CDE, CDF, and ZZ. Sometimes the families are identified by the first 3 characters...

Hi there :nya: Need some help. Currently this macro only finds cells containing the exact text entered into the text box Search_OrganName. I would like it to find any cell from the range that contains that text rather than just exact matches. I'm thinking there is a really obvious solution...

Hello Excel world, I want to perform the LEN formula in a macro for column D. I want to test "=LEN(D:D)=9" and where the last TRUE is highlight all rows above it, including the last TRUE. I have scoured the internet with absolutely zero success in knowing if this is possible or not. Can this...

Hello I am new to the site and macros but would like to know if anyone can help. Basically I am learning macros and would like to know if it is possible to have a macro display a range from another sheet Sheet 1 has names (A13:A40) with IDs (B13:B40) and a 2015 calendar in range of M9:AI43...

Hi! I have a question regarding my macro. What I want it to do is search for all the cells that are blue colored and select all the cells that are blue colored. I, then, want it to take only the blue colored cells and email them. Help please? I have the email part down, I just can't seem to have...

Hi everyone, Good day to you all. A couple days ago, a kind sir by the name Mike Rickson gave me a macro to extrapolate a set of random numbers from a given range of numbers from column A:1 all the way to A:49 sitting on 49 rows. At the moment i am concerned for his wellbeing because he...

Hello, I have a lot of word documents that need to be constantly updated. The most important thing that needs to be changed is the dates on the documents. Each word document has multiple pages, and each page has a date in the format MM/DD/YEAR on the top right hand, no headers. Also on the...

I would like to be able to use a macro that ask for apart of an web address then use that address to get the information I want. Example: Items bold and underlined needs to be changed Sub Macro1() ' ' Macro1 Macro ' look at me ' ' With ActiveSheet.QueryTables.Add(Connection:= _...

Hey all, I'm new to this site and this is my first post, but I cant figure out what code to use for the following problem: I have a sheet with the following 5 columns: Acct #, Month, Year, Type A or B, and $ Amount. Basically, what I want to do is sum up the $ amounts for Type A and B...

Hi guys, I am trying to create a way to check for fraud in our system. We have sales reps that go around different parts of the country and they turn in info about their sales. The problem is some reps have found a way to submit multiple entries that count as sales, when in actuality, these...

Going to try to make this as brief and simple as possible. My workbook has 3 worksheets, each sheet's data starts at A4, columns are A:F. I'm trying to make my macro read Sheet1!A4:F4 as a single value, then check if it exists in either Sheet2 or Sheet3 (also A:F, not in a single cell)...

Hi all, I am hoping to put together a macro that will allow me to automatically update files from a database of corresponding files. I will have one folder of "Scorecards", each of which has a corresponding "Master Document" from which all of its fields can be populated. Currently, I just...

Hi, I have a list of emails(1400) that I want to find in another list of emails(38400). The second list of emails has first name and second name. Can anybody please help me with a macro or any idea that may help me find the list of emails(1400) in the second list of emails(38400) plus copy the...

Hi, I REALLY need some help, please! I can do basic macros and am expanding my skills, but not nearly to this level. Here's what I'm trying to do: Every two weeks, two reports are run and are exported into Excel. Productivity workbook has a spreadsheet for each employee; PROD PPE workbook has...

Hi all, I've created a macro that automatically updates periodic data sets. I now want to create a search box at the beginning with options to change the date/period (i.e. enter 2015 q1) for the macro to update.. would appreciate any insight. Thank you in advance

Hello, I have a large database with just about 2400 listings of addresses. It is in a single cell and most include the street name, then the city name followed by a comma. What I would like to do (since there are 2400 of them), is find a way to somehow auto-populate the next column in the...

Hello Everybody, This I my first post and along with that I am a beginner to VBA/Macro. I really need your expertise to help me pass through this hurdle I have been facing couple of days. I have tried alot and went through 100's of post but wasnt able to come up with something concrete that...

Hi, I got a macro that works most of the time with the data I have, but sometimes my data is incorrect and needs to be changed manually. The data is incorrect when in kolom A the text is not ZORS (or blank). I want to let the macro search in kolom A whether there is a value that is not: ZORS...

I'm copying a PeopleSoft department tree into Excel. For those unfamiliar, it is a grouping of departments similar to a file structure where certain departments roll up into other nodes (folders) that all eventually roll up to the ultimate parent node (folder). When pasting this into Excel...

Hi all, I am new to this forum and I have minimal knowledge on macro in excel. I have a problem and I hope you guys can help. I have a single worksheet containing text data and all the while I used Ctrl+F to find the texts that I need. I need to have a macro to create a search box and can...