Over 1 million tech questions and answers.

Excel VBA: Sub to find if URL exists

Q: Excel VBA: Sub to find if URL exists

I need to find out whether a file which is actually a URL (i.e. it is located on a web-server) exists, from a VBA subroutine in Excel.
Any way to do that ?

RELEVANCY SCORE 200
Preferred Solution: Excel VBA: Sub to find if URL exists

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel VBA: Sub to find if URL exists

Read other 10 answers
RELEVANCY SCORE 56.4

Hi,

I have an Asus S200E and I had been messing with linux and trying to install it alongside windows 8.1 with no joy.

After a while I gave up but i've had a few issues with my laptop and wanted to either refresh or reset it.

When I try to refresh I get a message saying that the drive is locked and when I try to reset I am told the recovery partition is missing. I guess I must have done something when attempting to install linux that has caused this problem however when I open up the partition manager the recovery partitions are all still there.

Any help would be greatly appreciated, Thanks.

A:Won't find recovery partition even though it exists

Did your machine come with 8.1 or did you you do the store upgrade from 8.0 ?

The store upgrade breaks the recovery feature.

Read other 4 answers
RELEVANCY SCORE 55.2

Hello.. I use search and fast-search (in the start menu) to fast-execute programs that I don't need to add shortcuts for...
but strangely some programs that I have installed and exist and working don't show up in the results.............

A:Windows search malfunctioning (can't find file that exists)

How long ago did you install the program? It takes windows a little while to add things to the index. Also not everything is indexing by default, however I recommend indexing your entire disk! It takes a while to do but makes search SOOO much more powerful.

click start
type INDEXING
open INDEXING OPTIONS
MODIFY
tick the disk you wish to index
wait a while

Read other 4 answers
RELEVANCY SCORE 54

Good Afternoon,

I'm quite stuck trying to fix my code. I've scoured the internet looking for similar questions, but to no avail. I am trying to have excel create appointments in the outlook calendar and be able to run the macro multiple times without have duplicate appointments.

I could run my macro and create an appointment, which worked fine, but there was no routine to check if the appointment already existed. So I would have multiple appointment alerts for the same appointment if I ran the macro more than once. (If I were to add something and run the macro again to keep everything up to date).

So I tried to add a loop checking first the date of the appointment then the title (subject). However, now, I am getting the "Object doesn't support this property or method" error when I run the following code.

If anyone could help me with what the error refers to specifically in my code or any code I need to add or take out to make my loop work I would really appreciate it. Thank you very much in advance.
Code:

Sub ExportAppointmentsToOutlook()
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

Dim olCalendarFolder As Outlook.MAPIFolder 'use MAPI to loop through folder
Dim olMessage As Object 'items in calendar/inbox are messages
Dim olInboxMessages As Object
Dim olAppSession As Outlook.Namespace
Dim strSubject As String
Dim myDate As Date

Applic... Read more

Read other answers
RELEVANCY SCORE 41.6

I just got a new computer, and cannot find excel anywhere. I have tried a search, using "excel" as the word to find. I am running XP pro. My Tech guy at work says it should be on here, but he hasn't been able to come and look for it himself. can you help?
 

A:trying to find excel in XP

Read other 9 answers
RELEVANCY SCORE 41.2

 

Hi,
 
When I punch in a DOD number in my stats sheet Excel can’t find it even though it’s there.
 
When I looked at the drop down menu it was adding on 128077078 even though it isn’t showing in the search box.
 
Please advise?
 
Thanks,
 
Kevin

A:Excel 'find' being strange

I have a screen dump of the issue but can't seem to attach it.

Read other 1 answers
RELEVANCY SCORE 41.2

I have Office 10 and I go to "find" in my excel spreadsheet and I would like to find "shot", "hospital"". "doctor" without doing 3 searches. So can I imput those 3 words and do a search and it will show me each word as they come up?

A:Find two or more words in Excel?

As far as I know there is no way to do that without creating a macro. But even macro will return you cell numbers for those words in specially assigned "answer" cells.

Read other 1 answers
RELEVANCY SCORE 41.2

 

Hi,
 
When I punch in a DOD number in my stats sheet Excel can’t find it even though it’s there.
 
When I looked at the drop down menu it was adding on 128077078 even though it isn’t showing in the search box.
 
Please advise?
 
Thanks,
 
Kevin

A:Excel 'find' being strange

I have a screen dump of the issue but can't seem to attach it.

Read other 1 answers
RELEVANCY SCORE 41.2

In Excel 2003, the Find function works sporadically. This can be fixed by searching for and installing updates from Microsoft and doing a detect and repair.....correct?

thanks in advance!
 

A:Excel Find function

depends........but I would wonder first, why exactly it is misfiring......are you sure that you are asking it find the correct stuff? remember, computers are silly in that they always do preciesly what you tell htem to, not always what you want them to do....for instance, make sure you are not asking it to find bold text, or the 'match entire cell' is unticked....that one always gets me.....
 

Read other 2 answers
RELEVANCY SCORE 41.2

In an excel macro, i was wondering if this was possible:

You have a name in one of your worksheets. It is NOT separated by a comma. Example: "JOANNE PEREZ".

I want the macro to take that name (above) and look in another one of the excel sheets and see if it is in there. However, in the other sheet- the names are formatted as last name, first name. Example: "PEREZ, JOANNE".

Is it possible to have the macro return the name(either formatting) if found???
 

A:Excel Macro using Find

Read other 9 answers
RELEVANCY SCORE 41.2

Hello there,
I work with Excel 2007 and have a problem:
I have a spreadsheet with data scattered all over. I need the email adresses that are on this spreadsheet in a list. When I do the Find and Replace and search for the @ sign, it shows me all the search results in a new window. How do I copy that list and paste it in, say, another spreadsheet ? We are talking about 1944 email adresses! I am already done with my nerves at this point and I need help badly! Thank you in advance!
Susanne
 

A:Excel find and replace

Hi Susevienna. Welcome to the forum.

I think your best bet here would be to use Advanced filter.

Sort & Filter > Advanced

For your list range: Select your data
Criteria Range: Create heading(s), which matches that where your email addresses sit under. Multiple headings if required. Under which, put in "*@*" without the quotes.

You can select 'copy to new location' and select the new location to which you'd like your list to go.

Hope this makes sense.
 

Read other 3 answers
RELEVANCY SCORE 41.2

Hi,

I'm trying to use the Find function in Excel. If the value cannot be found, I'm trying to get it to give a message "Not here" but I can't seem to get it right. Appreciate some help on this. Thanks!

My code is:

Dim IActr As String

Sheets("Guide").Select
Range("e9").Select
If ActiveCell(0, 0).Value = "N" Then
IActr = ActiveCell(0, -1).Value
Sheets("tbl_a").Select
Columns("B:B").Select

Result = Cells.Find(What:=IActr, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate

End If
 

A:MS Excel - Find function

Add the code below after your existing code. I also recommend adding the letter v before all variables so that you do not end up using a reserved VB word. Instead of using the a variable called Result you should call it vResult. This is good coding practice and will save you headaches in the future.
Code:
If Result Is Nothing Then
Msgbox("Not Found")
Else
' Your Code If Found
End If

Regards,
Rollin
 

Read other 2 answers
RELEVANCY SCORE 41.2

I have a set of data, and what I need to do is find the top ten values out of the set of data and have excel display a chart with the top ten values that auto updates as new data is added to the range. Any ideas on how to do this? Thanks.
 

A:How Do I find the Top 10 in Excel 2003?

I have a pretty poor grasp on macros . However, I recorded this to cover cells A1:A100
Code:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 01-08-2011 by Peter
'

'
Range("A1:A13").Select

Selection.Sort Key1:=Range("A1"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("A1:A10").Select
Charts.Add
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:A10"), PlotBy _
:=xlColumns
ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"
With ActiveChart
.HasTitle = False
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).HasTitle = False
End With
End Sub
It needs to be run manually and needs some tidying up to put the details you need in chart.
I am sure one of the gurus will fix up the auto change part of your query
Anyway something to start on.

Pedro
 

Read other 3 answers
RELEVANCY SCORE 41.2

Hi

Can any one help me? All i want is a macro that searches the page for a specific character or number and tkes yu to the best match. like the one on excel but so i can incorporate it into my spread sheet so i don't have to do the old ctrl + F.

Yes i'm new to the macro game.

Help
 

A:Excel Find Macro

Chrishamar, you may have better luck getting an answer to your question in the Business Applications forum. Click on the red triangle and ask one of the MODs to move your inquiry there.
 

Read other 2 answers
RELEVANCY SCORE 41.2

I am wondering if anyone is a Live Mesh user who may have had the following problem: I was working with an Excel file which I "opened" from a Live Mesh Desktop folder. When I was finished with my work, I saved the file, and closed it. The program never gave me any message regarding the file save, but needless to say, I cannot find the file, and the file located on the Live Mesh Desktop folder is there, but was not updated with the new data. I believe that since the file was saved, and no error message was shown, that that version of the file must be somewhere, but where is my question?
Thanks.
 

A:Can't find Excel file

look in the 'last folder where you saved an excel file'

also launch Excel itself and the look in the Open list to see if it is present
 

Read other 5 answers
RELEVANCY SCORE 41.2

Hi all I want to find duplicates in a given column, selected by the user at run time, and then I want to copy the duplicates to a seperate sheet. For example:

Say I have a these columns:

1 100021
2 100031
3 100031
4 100041
5 100051
6 100071
7 100051

So the numbers 100031 and 100051 would be copied to a new sheet called duplicates.
The list of numbers can be of a varied length (between 100 and 1000 lines long).

I want to create a macro that performs this task. Could anyone provide me with any assistance?

Thanks

Greg
 

A:Find duplicates in excel.

Hi Greg,
You could record a macro to do that. Since you haven't mentioned which version of Excel you're using I can't tell you which menu option to choose.
In Excel 2003 you can use the Advanced filter option under the Data menu to create a list of unique numbers and then add a counter to this list to show which occur more than once.

I could put a simple macro together for you.
See if you can work it out using the advanced filter. first, and ... don't formte to mention which version of Excel you are using.
 

Read other 2 answers
RELEVANCY SCORE 41.2

Is there a function that will allow me to search an entire sheet for a given string? The LOOKUP functions seem to work on either a single column or row.

Thanks for your help.
 

A:EXCEL: Search/find

Read other 6 answers
RELEVANCY SCORE 41.2

Hi there,

I'm trying to wriet a macro that includes a find replace, but i need to increment part of what is being searched for.
ie:
Sheet called DAY2 references DAY1
Sheet called DAY3 references DAY2

I want to have a find replace that will do something like below:

-------------------------------
Sub FindReplace()

x = Sheets.Count
Sheets(x).Select
Cells.Replace What:="DAY(x-1)!", Replacement:="DAY(x)!", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True
End Sub
-------------------------------

Not sure of the right syntax to use,
Many thanks,
Riebe
 

A:Excel Find Replace

I'm definitely not an Excel expert, but I can tell you that if the answer is out there, then it can be found at www.MrExcel.com. The most complete Excel site I've seen. He's gotten a little commercial, but wade through that and you will find a great Excel reference.
 

Read other 2 answers
RELEVANCY SCORE 40.4

I was wondering if a user enters a order number into a form and if a column for example has various Order Numbers and the order number can appear more than once in the column, is there a way to code that lets you find the last duplicate order number that was enter in the column and then insert a row right after that row?

so basically if there was a column with 30 order numbers in it and the user enters say 09-009 in the text box (txtPONumber) on a form. If the PO Number entered matches the PO Numbers on the Invoice_Log tab then it will find the last occurrence of the PO Number and then inserts a line and enters the remaining fields that the user enters once the user clicks the add button. Below is the example spreadsheet.

The form that I am using is the frmInvoiceLog.
 

A:Excel Find Criteria Insert

Read other 7 answers
RELEVANCY SCORE 40.4

How do I find and sort alphabetically all 4 columns that I have.
When I do just one column sort by alpha the other columns get messed up and do not jive or line up correctly.
Help please?
Gary
 

A:Excel 2010 Find and Sort

Read other 15 answers
RELEVANCY SCORE 40.4

I have been trying to figure out a solution to my problem for two days and have had no luck. Attached is a spreadsheet with some sample data. What I am trying to do is count the number of priorities (2, 3, 4) for a calendar year (2001, 2002, 2003) and report it. Instead I get the same answer for each priority and each year.

I have included a small table that shows what it SHOULD report vs what is being reported. I know its me, but I can't figure it out.

Any and all help is appreciated!!

John
 

A:Excel Problem - Can't Find The Answer!

Disregard, I figured it out.
 

Read other 2 answers
RELEVANCY SCORE 40.4

Hi guys,

In my Excel 2010 workbook there is a cell with the value of "90" in type of number/general. When I go to find and replace dialog box and try to find the number "90" by typing it in Find what rectangle, then I want the program looks for it in formulas (look in: Formulas). But it shows that "90" as the result! Why? I said it to look for it in Formulas not in values.

A:Excel 2010, find & replace

If I understand you correctly, the 90 is a value computed from a formula in that cell.

You should search for 90 as a value if you want to find that cell.

Searching for 90 in a formula would mean that you are searching for the number "90" somewhere within a formula, not within a cell value.

If the formula in that cell was =110-90, I would expect that a search for 90 in formulas would find that cell.

If the formula in that cell was =110-20, I would not expect that a search for 90 in formulas would find that cell. A search for 90 in values would find it.

If the formula in that cell was =110-90+70, I'd expect that cell to be found by both searching for value or searching in formulas because 90 is the value of that cell and 90 is also found in the formula.

Read other 7 answers
RELEVANCY SCORE 40.4

Hi I am complete noob but need some help ASAP (not sure if this is correct forum)
Basically I have an xml file, which I need to edit, see below (the * are just editted data, so work dont complain )
<ORDERS> <ORDER> <ORDER_ID>**37597****</ORDER_ID> <ORDER_DATE>2011-10-26</ORDER_DATE> <ORDER_TYPE>STD</ORDER_TYPE> <CREDIT_CARD_NUMBER>5006</CREDIT_CARD_NUMBER> <DESPATCH_NOTE> <BRAND>GB</BRAND> </DESPATCH_NOTE> <RECIPIENT> <NAME><![CDATA[* *******]]></NAME> <EMAIL>********</EMAIL> <ADDRESS> <ADDRESS_LINE_1><![CDATA[The **** *****]]></ADDRESS_LINE_1> <ADDRESS_LINE_2><![CDATA[**** Head Yard]]></ADDRESS_LINE_2> <ADDRESS_LINE_3><![CDATA[]]></ADDRESS_LINE_3> <TOWN><![CDATA[FURNESS]]></TOWN> <COUNTY><![CDATA[******]]></COUNTY> <POSTCODE><![CDATA[**** *HF]]></POSTCODE> <COUNTRY>GB</COUNTRY> </ADDRESS> </RECIPIENT> <GIFT_MESSAGE> <GIFT_MESSAGE_LINE_1><![CDATA[5078]]></GIFT_MESSAGE_LINE_1> <GIFT_MESSAGE_LINE_2><![CDATA[20.00]]></GIFT_MESSAGE_LINE_2> <GIFT_MESSAGE_LINE_3><![CDATA[40.97]]></GIFT_MESSAGE_LINE_3> </GIFT_MESSAGE> <DELIVERY_LINE><ORDER_LINE_ID>1</ORDER_LINE_ID> <SKU>1365225</SKU> <QUANTITY>1</QUANTITY> <UNIT_PRICE ... Read more

A:Excel find and replace macro

Hi there, welcome to the board!

Do you have the xml file you can share/upload? I'm not really sure I understand why, but I think I understand how you want to do this. You just want a random number on the Item SKU, is that right? Then what, save it as a different file?
 

Read other 3 answers
RELEVANCY SCORE 40.4

Hi, this is probably very smple to fix but for the life of me I cannot find the setting to do so!
When I used to use Find & replace the search used to stop at the end of the spreadsheet and a message would come up saying "Excel has finished searching the document, would you like to continue from the beginning?" but now in my newer version of Excel it just continually searches through the document over and over. The document I'm working in has over 2 years worth of data but I only need to search the most recent month or so, so it's very irritating when I keep being sent back to 2009!

I really need it to stop searching at the end of the document,
any help would be much appreciated,
thanks in advance,
Lottie
 

A:Excel Find & Select problem

Read other 8 answers
RELEVANCY SCORE 40.4

I am trying to do a search of a worksheet, starting at my current position, looking for a substring in each field (the substring could be character or numeric). If the substring is found, that cell becomes the current cell and the user is asked if the search should continue. If the substring is not found, the user is asked if the search should continue at the top of the worksheet. I am sure I am going about this wrong and really could use some help. Below is the code I have so far.

Thanks in advance.

Sub Search()

Dim datatoFind
Dim sheetCount As Integer
Dim counter As Integer
Dim currentSheet As Integer

On Error Resume Next

currentSheet = ActiveSheet.Index
datatoFind = InputBox("Please enter the value to search for")

If datatoFind = "" Then Exit Sub
sheetCount = ActiveWorkbook.Sheets.Count

For counter = 1 To sheetCount
Sheets(counter).Activate
If IsError(Cells.Find(What:=datatoFind, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False).Activate) = False Then Exit For
Next counter

If ActiveCell.Value <> datatoFind Then
MsgBox ("Value found")
Sheets(currentSheet).Activate
End If
End Sub
 

A:In Excel find a substring in in a worksheet

Read other 11 answers
RELEVANCY SCORE 40.4

I have a row with following values in each cell: 15, 15, 15, 15, 17, 17, 17, 21, 21, 21, 21...

For each cell, I need the next different value, which for the four first cells would be 17, then for the following three would be 21.

The reference to the next different value must be unique for each of my cells, as I'm using the value for further calculation. I would assume that I thus cannot use one variable for all my cells.

I'm in dire straits over this issue.
 

A:Solved: Excel find next higher value

Read other 9 answers
RELEVANCY SCORE 40.4

okay here it comes. I need to find a way to find replace data on a big scale for excel 2003. I have a bunch of numbers(5m or so) that correspond to a different number. I don't know how to write a macro at all, and am currently find replacing, but this seems like it's going to take a life time.

Example:
Worksheet1
1____________ 10000
2____________ 93233
3____________ 43234

Worksheet 2 parenthesis is a cell
(1) (2) (2) (1) (3) (2)
(2) (1) (2) (3) (2) (3) etc.

I need to make worksheet 2 numbers change to represent the numbers corresponding to worksheet 1 so for every (1) that comes up it changes to 10000. I hope I explained this right. Please Help, I will continue find replacing while I hope for an answer.
 

A:Odd Find Replace Excel God Needed :)

The simplest and quickest way is to use built-in Excel functions.
You will need a 3rd worksheet for metadata. Not knowing the actual sheet names, I'll assume they are called

Sheet1
Sheet2
Sheet3
Also, let's say Sheet1 has the data in columns A & B, and data in Sheet2 begins at cell A1
So, in Sheet3, in cell A1 you will need this formula:

Code:
=VLOOKUP(Sheet2!A1,Sheet1!A:B,2,FALSE)
Extend the formula for as many cells as you have in Sheet2.
When ready, click on the upper left corner of Sheet3 to select all cells (i.e. the whole worksheet), press Ctrl+C, then from menu select Edit -> Paste Special -> Values.
As a result, you will have the desired numbers in Sheet3. You can then copy them to Sheet2, if you wish.

Jimmy

Edit:
I have assumed that 1____________ 10000 in your post means 1 in column A and 10000 in column B.
If 1____________ 10000 is in a single cell, then the above formula will not work, another one, a more complicated one will need to be used. I'll wait for you feedback before working it out.
 

Read other 1 answers
RELEVANCY SCORE 40.4

hi,

i have a Excel workbook that consist of 3 worksheets and there are some formulas in each of those sheets.

the problem is that each time I open the workbook there will be a "update link" message that appear (pls see the attachment). that's strange 'cause I have never inserted any links before.

is there a way to display all the links that are present in the worksheet and prevent this message from re-appearing?

thank you
 

A:Cannot Find the Links in Excel Workbook

Try Bill Manville's add-in -- http://www.oaltd.co.uk/MVP/MVPPage.asp
 

Read other 2 answers
RELEVANCY SCORE 40.4

I get this when trying to open Excel files generated by some code:
The document is corrupt and cannot be opened.

Microsoft Office Excel File Repair Log

Errors were detected in file 'C:\Users\User\Downloads\myfile (15).xls'
The following is a list of repairs:

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.Click to expand...

Now it's only 11 lines long and I need to find what [cell] is causing this error to occur. How do I do this?
 

A:Excel: find cause of document is corrupt

Oh and the log file is the quote I posted. You would think the log file actually explain what the cause was. -.-
 

Read other 3 answers
RELEVANCY SCORE 40.4

Hi

I wonder if anyone would know how to replace the last occurance of a character within a cell.

For example replace the last comma of the below with and

i.e. myString = String1, String2, String3, String4

myStringWouldThen = String1, String2, String3 and String 4

Thanks
 

A:Excel - Find and replace the right most comma

Hi MattMurphy

It shoul be for Excel, Word, or?...
 

Read other 2 answers
RELEVANCY SCORE 40.4

Hi all,

I found a topic that was already solved and closed. http://forums.techguy.org/business-applications/703238-solved-find-copy-text-excel.html#

This is the original code:

Sub FindBW()

'Change this to reflect your true starting row.
vStartRow = 1

For i = vStartRow To Cells(Rows.Count, "A").End(xlUp).Row

If InStr(1, Range("A" & i).Value, "BW") Then
Range("B" & i).Value = "BW"
End If
Next i

End Sub


However, I need to tweak the macro to fit my needs. I have to go through pages of phone numbers and I want to search for rows that contains a specific phone number. For example.
I want to search through columns A,B and C that contain number ")410) 234-0000". And then I want to copy all info from those rows into a new worksheet.

Thanks in advance for all of your professional help!

Joseph
 

A:Find and Copy text Excel

Read other 16 answers
RELEVANCY SCORE 40.4

When I open a spreadsheet, I get a warning message that says "this workbook contains links to one or more external sources....."

How can I find the cell in the workbook which has that link in it.

I've tried the search function in formulas using "[" but it finds nothing.

T

Read other answers
RELEVANCY SCORE 40.4

My daughter is studying away from home. Has a totally legal copy of Office but installation disks are at home. Excel has been working but suddenly does not and trys to install but can't find a file E22561412.cab. Other Office programs still work. Is it of any use if I email her a copy of the file - and if so what should she do with it? Thanks for the help.
 

A:Excel - can't find file on startup

Read other 7 answers
RELEVANCY SCORE 40.4

Geeks hey there,

I was just going through this forum and found that my problem can be solved here

I have 2 columns in excel A & B I want to find all my data of Column B in Column A and Replace it with "" nothing.

Please guide me accordingly will be very grateful for your help because they are more than 6000 rows and finding and replacing will just take hell of time. I have also attached a sample file.

I want to find all data of Column B in Column and want to replace with nothing ""

Thanks.
 

A:Multiple Find and Replace in Excel

Hi
Try this solution. In column C enter this formula;
=REPLACE(A1,FIND(B1,A1),LEN(B1)+1,"")
and copy it down the length of the data. If the result is as you want it you can then copy the entire column and pastespecial/values into column A if you want to overwrite that data. See the attached for how the formula works.
 

Read other 1 answers
RELEVANCY SCORE 40.4

I'm trying to modernize a Wordpad inventory list to Excel 2013 with a problem.
Item description & quantity are now pasted into the same Excel cell.
It's written with item description followed by inventory account in ( ) Since the inventory is inaccurate we need to just delete all ( ) and numbers inside which vary from 1-6 digits.

I tried Find & Replace with wildcards. I also tried the =Left and =Right functions after reading about them.
It looks like this
2" Caps (98)
3" Caps (1257)
4" Caps (188)
6" Caps (89)
5' Wire (12500)
It should look like this
2" Caps
3" Caps
4" Caps
6" Caps
5' Wire

Thank you
Ron

A:Excel Find & Delete problem

Here's a formula that will do what you say you wanted but I don't think it's really want you want.

=CONCATENATE(LEFT(A1,FIND("(",A1,1)-1),RIGHT(A1,LEN(A1)-FIND(")",A1,1)))

If you have the data in column A and put that formula into B1, then copy and paste it into the rest of the cells in column B, then you will end up with the text in column B minus the (xxx). With your example data it will look like this:

Read other 7 answers
RELEVANCY SCORE 40.4

Hi Guys, here is the situation. I have a spreadsheet that has 6000+ rows, 3 columns. What I need to do is find the words "eric bailey" in the cells in column A and copy the rows to sheet number 2.

Below is a screenshot of the sheet. I need to copy the highlighted rows to sheet 2.

https://docs.google.com/open?id=0B4v5E8dwK2pxZDhjMV9VaTVWeE0
 

A:EXCEL 2010 Find and COPY

Hi, welcome to the forum.
It seems there are quiet a lot of find and copy posts these last two weeks.
I can suggest the following link where you can find quite a lot of information adn samples
http://www.cpearson.com/Excel/Topic.aspx

You may need to edit the sample to your needs but you will get the main idea of how it works.
If you need help with that you can find us here.
 

Read other 1 answers
RELEVANCY SCORE 40.4

Given:
I have a "Data" Sheet with Raw Data
Column A has item number, Column B has Qty
I Have a "Result" Sheet with cells i want to update
Column R has same item number, Column S has Qty(that needs to be updated)

Here is what I want to accomplish with VBA:

Select Sheet "Data"
X= Cell A1, Y= Cell B1
Select Sheet "Result"
Find X
Replace the next cell to the right with Y
Find Next Occurrence and replace again (if it exists), If not:
Select Sheet "Data"
X = Cell A2, Y=B2

(repeat the find and replace routine)
If Sheet "Data" Next item in the list (ex A1000) does not contain data, quit. ​
 

A:Solved: Excel VBA Find and Replace

Read other 16 answers
RELEVANCY SCORE 40.4

I need to compare the names of tables located on four sheets in workbook Tabledesign.xls in cell J4 to the names in workbook TableList.xls. I then need to export the Tablespace, Initial, and Next information seperate notepad document with the table name taken from Tabledesign.xls.

Tablelist.xls looks like this with the table names starting in cell c4.

TableName..................... TableSpace.................. Initial.............. Next
PS_NFS_JK_MAIN..............NFSPRJ ........................1M................. 1M
PS_NFS_JK_HITO..............NFSPRJ........................ 40K................ 20K
PS_NFS_JK_TAIJIN........... NFSPRJ........................ 2M................ 1M
PS_NFS_HOSPITAL_MS..... NFSPRJ........................ 40K............... 20K
PS_NFS_JK_TAIBUTSU...... NFSPRJ........................ 40K............... 20K
PS_NFS_JK_SHARYO......... NFSPRJ........................ 40K............... 20K
&#12288; &#12288; &#12288; &#12288; &#12288; &#12288; &#12288; &#12288; &#12288; &#12288; &#12288; &#12288; &#12288; &#12288; &#12288;
 

A:Solved: Excel VB Find Print

Read other 7 answers
RELEVANCY SCORE 40.4

I have an ecommerce store, we imported data from one platform to another and had to combine multiple fields from the old into the new platform. In doing that, we gained data but lost a tab function that allowed you to simply click on specs to see them.
Here is what I am trying to do:

I have exported all of the products:
in the product description field it lists multiple areas of information, ie company information, sku, upc, specs, features.

I want to run a macro that says look in cell c1, find the word specs and copy everything from the (s) to the word features which is in every product and that cell.

paste that smidgit of text in a different column.

then I can import this sheet back into the system and then have the individually made tab also show specs when clicked on.

The data cell is the product description the specs are there adn they need to copy to the product warranty tab cell and be able to copy this macro or formula down for 8000 products for a global change
 

A:Solved: Excel find and copy

Read other 14 answers
RELEVANCY SCORE 40.4

I've inherited a spreadsheet with text entered in the first column. Some of the names are followed by * or # to designate cross reference info. I want to take these out because the designations were good for 2004 but are not correct for 2005. When I do a search and replace, it deletes all the information in the column instead of just the * or the #. How do I do this without manually going into every entry?
 

A:Excel find and replace feature

Select your range of cells that you want to evaluate and run this macro:
Code:
Public Sub Replace()

vChar = InputBox("ENTER CHARACTER TO DELETE")

For Each vCell In Selection.Cells

If InStr(1, vCell, vChar) > 0 Then

vCell.Value = VBA.Replace(vCell, vChar, "")

End If

Next

End Sub
Rollin
 

Read other 1 answers
RELEVANCY SCORE 40.4

I need to match the list of numbers (left) to the table on the right and return the first number in the first column of the table. The problem is the number I need to match on the left is hidden in the table.. sometimes there is one extra number added to it, sometimes two extra numbers. I don't care about these extra numbers, just want to know if my number on the left is in the table ANYWHERE! Any suggestions??

Column A Column C Column D Column E Column F Column G
6012 1 96012 139099 59162 226248

So, for example.. I am trying to match 6012 with one of the columns in the table. I need it to return 1 (column C) is 6012 appears anywhere in the table, regardless of what number is appearing before the number.

Is this possible?
 

A:Excel; Find number within string

Read other 7 answers
RELEVANCY SCORE 40.4

Scenario: the spreadsheet is protected and the user can only delete a row by using a macro. The macro will unprotect the spreadsheet, delete the row, then protect it again. The spreadsheet has description and header rows at the top and summary rows at the bottom. The user may only delete data rows in the middle.

Task: the macro must determine the current row number and verify that it is legal to delete that row.

I am a newbie to VB and can't find a function which will do this for me. I thought that RW would help, but I can't get it to work. Any help will be much appreciated.

Here are related processes that don't trouble me: creating and editing macros, locking cells, protecting sheets, deleting current row, using the IF function.

Thanks. Alvin.
 

A:Excel macro must find row number

To find the current row you simply use Activecell.Row

Rollin
 

Read other 3 answers
RELEVANCY SCORE 40.4

Hi guys,

In my Excel 2010 workbook there is a cell with the value of "90" in type of number/general. When I go to find and replace dialog box and try to find the number "90" by typing it in Find what rectangle, then I want the program looks for it in formulas (look in: Formulas). But it shows that "90" as the result! Why? I said it to look for it in Formulas not in values.
 

Read other answers
RELEVANCY SCORE 40.4

This is my first post and i'm very new to macros so be gentle

I have an excel workbook that i would like to input a name in a cell and i would like the macro to search for that name in another sheet (within the same workbook) and copy and paste specific cells from that data sheet into specific spells on the original sheet.

Basically i want the macro to find the text thats entered into cell D2 of sheet 1, and i want it to look for that text in all of column C in sheet 2. If it finds a match for that text, i then want it to copy the data thats in column B and G of the same row. I then want that data to paste in cells D3 & D4 on sheet 1.

I hope that makes sense. Thank you for your help. i have been trying to find an answer for this for days and cant seem to find exactly what i'm looking for.
 

A:Excel - Find, Copy paste ??

Read other 9 answers
RELEVANCY SCORE 40.4

I am using Vista home premium and excel 2007. I wanted to download my football database which is an excel workbook more or less and when I try and unzip it with (winzip14) it gives me this error message "windows cannot find c:users\blah blah blah. Make sure you typed the name correctly and then try again."

I can open a new excel window and click on the excel files I have saved in the past and open them that way but when I click on this file I get another message which says "Text Import Wizard Step 1 of 3 Text Wizard has determined that your data is delimited if this is correct choose next or choose the data type that best describes your data".

The data shown in the excel sheet is all symbols and letters, not what is supposed to be in the file.

Any help would be greatly appreciated

thanks
 

A:Solved: Excel (Windows cannot find)

Looking in another forum I found the answer and I thought I would post it here since no one was able to help me.

In word or excel whichever you are having this type of problem go to options "advanced" and "uncheck other applications that use Dynamic Data Exchange (DDE)"
this corrected my problem!!!!!!!!!!!!!!!!!!
 

Read other 3 answers
RELEVANCY SCORE 40.4

Dear Techies,

A Very Happy New Year to you!

I need help in MS Excel. To tell you quickly the situation that I have got,

I have a list of 40-50 tasks, each having different time required for execution. E.g. task A requires 15 minutes, task b 20 and so on at random. There are some other attributes to those tasks like equipment required etc.

Now, I want to know a way by which I can fetch tasks matching certain given criteria, onto the other sheet. For example, If I input time available as 20, it should give me the tasks which can be completed in 20 minutes or less.

Can anyone assist me with that?

Kind Regards,
AJ
http://ajstates.blogspot.com
 

A:Excel Help Reqd - (Find Next Item)

Hi AJ,
The quickest way is a pivot table then you can filetr time value and you have your results
 

Read other 1 answers