I've got a problem that's causing me a headache. i have a document with 1 column and 4000 rows (its an export from active directory).
I need to do a search cell by cell (so A1 - A4000) for any cells that contain the text "changeType". When a cell is found, i need excel to insert a new row above the current cell and insert the text "modify" into the new row (in the first column).
I have this macro below written. It isn't working for me and I am trying to figure out how to write it. Basically, the macro is supposed to go to the test.xls workbook and then look at names in row 4, from there it will take each name and search for it on the all csrs new.xls workbook and then move over to the right 5 times and copy data and paste 1 down from the name on the test.xls workbook. One workbook has the names going to the right and the other workbook has the names going down....
I need a Macro that will search all of the cells for specific text, and delete all cells containing the text. I prefer to make a list of the specific texts and run macro to find all of them and delete all cells containing the text. I need to be able to add some more text into the list in future.
Daily At the end of day We receive sales files from our different teams, these files are received at different times due to difference in working shifts. I have collated last one month data and from this data I want to know the earliest and maximum time and date on which we received the files in last month, so that i can fix the receiving time for all regions.
I have a report that I pull that I pull fairly often that is in this format and shows which footage of products each store is getting (out of over 1800 stores)!
Above is the format that it comes back as. And here is a spreadsheet that shows what steps I take to find correct values in detail.
So each FTG has an ID# and Desc. The ID is in text format and each ID is seperated with a comma, no space. Description also. Date is seperate by a space and comma. Stores change footages a lot so I want to find out which footage is effective today (1/27/2014) For ex: Store 63 would have the 5ft effective right now because we are between 5/23/08 and 5/22/14. So each ID# and Ftg Description is in the same order as Date.
When I have hundreds of stores, it is difficult to go through and get each one (even with the way I've been doing it.) But my ultimate goal is to create a macro to put only the current footage ID#, Desc, and Date in Columns C,D,and E. I'm not sure even where to start with doing a macro.
I usually just find the store with most ftgs, count them, insert that many rows after ID and Description columns, then do a text to columns (comma, delimited), sort by 2nd date column (so they all come up top) and then manually go through them and delete unneeded columns once I have them all.
Need macro to search xls files in folder/directory for common text string "see reference" and then output the file number which is located in cell A1 to new spreadsheet for each file the text "see reference" is found.
I am using the following code to find a NAME in my work sheet and to enter their status. But this macro is not compatible if a duplicate or Similar name exist.What I need is I need this macro to activate the search NAME Cell and then a VB box with OK & NEXT button has to appear. if the activated NAME is exactly the one I am searching, then I will click the OK button then it should display the "Enter Employee Status" box and as continue in my code, But If I press NEXT, the macro should search the next similar NAME and activate it, This process should continue until I click the OK button. (Same like CTRL+F function with an additional Status entry button)
Code: Sub Button1848_Click() Application.ScreenUpdating =False Dim BeginCol AsLong
the above information have following header ie. Location, P.O.Box, Address, Tel, Fax and Category.
every time one of the header inforamtion is missing ie. Address or P.O.Box, Or Fax, due to this problem every time cell address of information aganist header is change. supose in first copy/paste Tel inforamtion is in A15, but second time it may be on A13, and 3rd time it may be on A17 and so on.
I want to make a macro which search header ("Location", "P.O.Box", "Address", "Tel", "Fax", "Category" ) from a Range A1:A30. than down two steps to copy header information (75325412) and paste in fixed cell location C1:C5 (C1=Name, C2=Location, C3: P.O.Box, C4=Address, C5=Tel, C6=Fax, C7=Category) in same sheet. and repeat the steps to copy information aganist header from all header in Range A1:A30.
giving me a macro to find a word in a sentence by using the "FIND" method. For example I have a sentence say "I am happy" in which I have to search whether any of 2 words say "Happy" or "Sad" is there or not. If the sentence contains any of these words, then that row has to be highlighted.
I have an excel workbook with 2 worksheets. One worksheet shows the MASTER LIST of COMPLETE Customer Names (e.g. ABB Supplies Incorporated). The other worksheet has information on customers but the customer names typed in are incomplete (e.g. ABC Supplies). I need a macro that would look do a comparison of the customer names in the 2nd worksheet to the Master List worksheet and pull the data (complete name, address, etc.) for those that would match (partial match since company name is 2nd worksheet is usually incomplete).
I want the script to find if the value entered in the form is matching the values in column 'A' in the database and if it matches then it needs to select the cell as active cell - to populate the form details. And if there is no matching value found, the script needs to select the last empty cell of the column 'A' to populate the data entered in the form.
1) Form has 10 different fields that needs to be filled by the user.
2) Field 1 - is a text box for 'Request #' to be entered by the user.
3) After filling in all the fields - once clicked on OK, the form should search for the the 'request #' entered on the form in the database (Form and the database are in the same workbook).
4) If the 'Reqeust #' in the Column 'A' matches the the 'Request #' entered in the form, then the matching cell should be selected (Activecell -Were the data can be overwritten, with the new entry)
5)If there is no matching 'Request #' found in the database, the script should loop to select the next available blank cell in column 'A'. So that the form data can be entered.
I am trying to create a formula, but my knowledge of excel formulas is very new! I am trying do create an excel formula which calculates the difference in video view data which I enter, comparing today to yesterday to see the growth.
My column A is dates. My column B is video data.
Is there a way Excel can work out the TODAY date's data and minus YESTERDAY date's data to find the growth?
My thinking is that this would look something like the following, but I'm not sure how it would be written in Excel's formua:
Where Column A is = TODAY (), conduct sum where TODAY () minus data from yesterday (TODAY () -1).
-Find TODAY () - FInd TODAY'S associated data - Find YESTERDAY or TODAY -1 - FInd YESTERDAY'S associated data - Minus Yesterday from Today to find the difference.
The 1st set is in a column. Nice & tidy all twelve characters in length & alpanumeric
zx0123123123 zz0123123124 zy0123123129
The second set is a mess, taken from a lotus notes inbox from the subject line off an email, eg. there Blah blah zz0123123124 etc etc. What I want to do is do a reconcilliation between the two with a lookup, but have no idea which route to go down to get round the messy data. I have been using =IF(ISNA(MATCH(A1,'[spreadsheet to lookup to.xls]sheet1'!$A:$A,0))," No match"," Match") but here the data is clean. I have searched teh forum ;o) DaveH & found something about > Instr() but this can't be used in formulas..
I am trying to look up a numerical value in Sheet 1 Cell:F7 and find that value in Sheet 2 Column B, then offset 29 columns in the row where the value was found. The number will not have any duplicates within Sheet 2.
And I have declared 'a' as public variable. New Records will be added to the worksheet while macro is running. so at certain places i have re-written the above code to find the updated last row value. But I have a problem here. Assume that the above code finds the last row and updates the value as '8' in the variable 'a'. Then my macro will add some more records to that worksheet and check for the lastrow again. now the variable 'a' should have the new last row value. But the variable 'a' still holds the old value '8'.
I have splitted my entire code into two modules. And the variable 'a' is declared as public in Module1.
I have a sheet where three columns are appearing as City, Assignee Name, Email id. In macro there is a form with one find button, one combo box for selecting city, two input box> one for assignee name. 2nd for email id, This code is for combo box but its taking a1 also after clicking on combo box i wanted that the header should not be on combo box after clicking on it-
Private Sub CmbEmpNm_DropButt*******() Dim EmpRnge Sheets("empdata").Select Sheet1.Range("B1").Select ActiveCell.Sort Range("a2"), xlAscending, , , , , , xlGuess, , , xlSortColumns, xlPinYin EmpRnge = ActiveCell.CurrentRegion.Address CmbEmpNm.RowSource = EmpRnge End Sub
Appart from that for find button the coding is -
Private Sub CommandButton1_Click()....................
I have recorded a Macro in excel 2000 that will find cells containing ".xls" and then copies and pastes the values into that cell. How can I get this macro to repeat until it has found all the cells containing ".xls". The Macro I have recorded is:
I need a Macro that will go to the last row of a set of numbers that will need to be summed - there willbe a varying number of ropws depending upon the numbers pulled so I think " last row +1 " would be involved but then the sum function for each column would need to be inserted to get the total of each column (I have the macro to pull the numbers into the columns but need the final piece to automatically sum up those colums)
I have a table with 500 entries which is some physical properties for some chemicals. What I am needing to do is get something to find out what chemical formula the user has typed in another cell on a separate sheet, then VBA finds the component on this table and picks out information from columns within that row. Some of that data will then be used to do a calculation. The user can select up to 20 components, so VBA needs to be able to do it for 1 or anything in between 20 components. The data which I need to use for further processing is within columns D to J.
I have tried to record this but I cannot get it to work? On the tab “Add & Delete” cell “L17” I have a drop down list that is a list of the policy numbers from the “Data” tab.
What I am trying to do is assign a macro that searches column “J” on the “Data” tab based on the “L17” content on the Tab “Add & Delete” when it finds the data it then clears the contents of that entire row.
I have a spreadsheet with 20 sheets, with each sheet representing work done by an individual. The sheet would contain all the tasks and the percentage of work alotted. I now need to capture all these in a summary spreadsheet BUT only if the task is "IN PROGRESS" which is indicated in one of the cells.
Currently, we're doing it manually and it is a pain to go through all the names and copying the rows one by one. The summary should show the names with the corresponding project name and allocated time (copy whole row).
I'm trying to come up with a macro which will go through column A once searching for a value (ex. "apple") and upon finding a cell with that value, take cells 79-100 from that row, copy them to cells 82-103 of the next row, and delete the row which contains the value.
I have a workbook (materials forecasting) that automatically pulls from another workbook (production schedule).
The materials forecasting workbooks are named in regards to the current Monday (ie 02-02-09.xls, 02-09-09.xls, etc). The production schedules are named in accordance with the financial periods and weeks, ie PD1WK1.xls, PD1WK2.xls, PD1WK3.xls, PD1WK4.xls, PD2WK1.xls, etc
The materials forecasting sheet looks two weeks out.
EXAMPLE (pretend that today is the first day of PD1WK1)
Cell C1 will reference PD1WK1.xls Cell C2 will reference PD1WK2.xls
Each week I copy the old materials forecasting sheet and rename it to the current week (ie I take 02-02-09.xls and rename it to 02-09-09.xls). I have a bunch of macros set up to move my deliveries up a week and what not. One macro I would like to set up, however, is that by putting a value in a cell the find and replace macro will work.
EXAMPLE Cell A1 will reference PD1WK2.xls Cell A2 will reference PD1WK3.xls Cell C1 will reference PD1WK1.xls Cell C2 will reference PD1WK2.xls
Then I would have the macro find all instances of whatever value is in cell C2 and replace it with whatever value is in cell A2. Then likewise fore C1 and A1 respectively. (If you think about what I am doing here... all I am doing is moving the schedule up one week so that I am forecasting using the right schedule).
I can manually do this but I would prefer a macro based on a simple user input for when people fill in for me.