cell contains

Hi, I'm looking to use the replace to change a known value to another value. but i have multiple values to i want to list them all out in a sheet and loop once i've replaced the values in the list i want to loop and do the same in another work book for example my list is Change from...

Hello everyone, I wanted to know if there was a formula or macro that I could use which would look up a string of text in column B:B and if found in column D:D return the value which correlates to its row, but the value i want is in column A. Its hard to explain but i am attaching an image...

Hi, I haven't written/recorded a macro in a very very long time and am struggling to try and do something simple. I need to search all worksheets of a file (containing around 100 tabs) for cells which contain the text "_web.pdf". There is also other text in the cells. Then for all cells which...

Hi, I have this formula: =COUNTIFS('RAW DATA'!$H:$H,"="&$A$1, 'RAW DATA'!$E:$E, $A7, 'RAW DATA'!$G:$G, "*U6:U28*") In the last criteria I am trying to count if the cell contains text from a range but the result it is giving me is 0, when I know the output should be 12. And I need it to be a...

Team, I am trying to use an excel spread sheet copied into a Sheet in excel to input information. Example: Sheet 1 Cell A2(in cell A2 =desired number) I want information to be filled with units sold by Location1. The location information will be in Sheet 3. The difficult thing is the...

Hi All, Have a major problem with our monthly call billing, we basically have a spreadsheet which shows a number called and the total cost of the call. However our the calls for 0844 & 0845 numbers are 10x the actual cost! Does anyone know how i can run a macro which will find the 0844 &...

Hi There, I want to get a VBA code for checking if a particular cells has got any email address Suppose Cell A1 = abc then it should give error "Please enter a valid email address" and If Cell A1 = abc@xyz then it should let the user enter that value as it is a valid email address VBA code...

Hi all!;) I will appreciate your help. I need to find out if a certain cell contains other cell's text- it's not a specific text.If A1 contains the text in C1.... do you have any idea how to do that?? Another issue if you can figure out is the formulas I've tried so far couldn't identify if...

Hi, I have a cells drawing information from a table. In this table I have model numbers to depict products in one column. In another column I have sales totals for those model numbers. I would like to sum the sales for those model numbers if the model number contains an S. Conveniently...

<TABLE style="WIDTH: 159pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=211><COLGROUP><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><TBODY><TR...