macro - search

Hi i have sheet that looks similar to this one but larger: <tbody> a b c d e name code LL KK AA a 3 1 b 12 c 8 d 4 9 </tbody> My goal is to copy headers from columns c, d, e to column b when cells have values. Here is what i try to accomplish: <tbody> a b c d e name...

Hi, this is my first post on this site so please bear with me if I don't seem to make much sense, or sound like I have no idea what I'm talking about (cos I don't)- this and vba are all very new to me and I've come to this site out of desperation so please help if you can! I'm essentially...

Hello to all I have 20 numbers from D3 to W3. Numbers range from 1 to 80. There are several rows with numbers. I would like a macro to pic from each row specific numbers and copy them to EC3. Any ideas? Thank you

Hi, I've been attempting to find a macro that would combine a number of similar workbooks into one large workbook. The files I'm dealing with are all .csv files with identical columns and headers. Let me also say, I have very little experience with these or code writing, so please be patient...

Hello All, I have a requirement where i have to search a value of cell in the C:C range and find all values found in that column, if the values are found then i have to copy the value of first string in A:A range. Example: A B C 1 Cat Cat 2 tiger Cat 3 son Cat here in column...

I am getting a bit stuck with this one. I have a sheet which has lots of information on it by US State and County with columns as follows:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p><o:p> </o:p> <TABLE style="BORDER-COLLAPSE: collapse...

I'm quite stumped trying to figure out how to do this, so I'm turning for this community for help. I'm working with Excel 2011 for Mac. The setup: I have a workbook with two sheets: Master List and User List. Master List contains a large number of rows (starting from a row 4) with various...

Hello, I have create a marco that will go on a site and extract data. thru a web query. I would like it to keep looping through the column that has all the urls. and stop at the last row containing a url... SO.... Column K has the URLS starting at K2 these urls come in because a rss feed...

Running Windows XP - Excel2007 Each month I prepare financial spreadsheets that include entries for that month and a running cummulative total for the year. I add the current month to the cumulative total last month (by referencing the same cell in last months spreadsheet). Each month I...

Having trouble with a macro that will search row k 12 sheets for a variable. Any time the variable matches I need it to copy to a seperate sheet. This is a monthly parts scrapping log and am trying to get running costs per dept. responsible

Hi all, this is my first post so I apologise for my lack of forum lingo and knowledge! I have a situation where I have a rather large spreasheet, that we populate each week with 35 columns and 20,000 rows worth of data. At the moment we have to manually go through this data and look at certain...

In one workbook i have a list of customers. In another I have a list using the same customer names in one column and a date assigned to them in another column. I would like to run a macro that when a customer in the first workbook is selected it would find the same customer in the second...

Scroll down windows in Cells E3:E25. Source =$T$7:$T$14 When option T14 ("Complete") is selected, I want the corresponding Row to be highlighted yellow. Rows have highlight prior to this. How would I go about this? Thank you for any help in advance.

I am currently using the below script which returns the location of a string. I need to change it to instead just search column b for string and give me the value of column A where its found instead of the location. Any ideas? Public Sub FindText() 'Run from standard module, like: Module1. Dim...

To make myself slightly clearer. I need to write a macro that will find the contents of a cell. For example in cell B3 is the word straw, I need to copy cell B3 and paste it into the find function and find all words with straw in. Now this works fine, but when I change the word in B3 to...

Hi All I have on sheet 1 a whole contacts database. eg : Column "A" contains Names "B" telefone numbers "C" emails. ext. on Sheet 3 i have a list of emails. how can i have a macro or something lookup the mail list on sheet 3 and delete the corresponding ROW on sheet 1 ?:warning:

I have a spreadsheet that has part number (formatted as text) in Column A, Description in Column B and Stock Count in Column C. I would like to search for the part number and have the active cell in column c waiting for the count, ask fr then next part number. Thank you

Hello All, My issue is doing analysis w/in a tight timeline, and before that can be done, the Main spreadsheet must first be updated by hand. Being that this spread sheet is comprised of over 50 different MOS types, x6 companies, it becomes very tedeous and time consuming. I have finally added...