Over 1 million tech questions and answers.

Solved: Excel search does not work Excel 2013

Q: Solved: Excel search does not work Excel 2013

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.

Preferred Solution: Solved: Excel search does not work Excel 2013

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: Solved: Excel search does not work Excel 2013

Read other 7 answers

Hi there
I have some EXCEL addins mainly for getting stock data in real time (or almost real time) from places like CBOE (chicgago board of options Exchange etc). Use a lot for Options trading etc.

When I try and install I get message : EXCEL IS NOT INSTALLED.

Major Showstopper for me this one although if you don't use addins it probably won't matter to you. Sounds just a small problem but this is actually a GO-NOGO type of situation -- it's NOGO.

(Same prob with on both W7 X-64 and W8 RP x-64).

Quick roll back to Office 2010 before the Markets open on Monday !!!! -- always take backups when doing this type of testing -- fortunately I have the "Before" images.


A:OFFICE 2013 X-64 some EXCEL addins don't work

That doesn't really surprises me. The addin is probably looking for a specific version number on Excel and doesn't recognizes anything outside a very particular range and simply ignores newer versions. Or it may be that the new Office is simply incompatible with existing addins.

Similar issues happens with most addins in most programs too. I particularly suffer it with every new version of Thunderbird breaking all existing plugins (reason for which I almost never update it).

Read other 4 answers


I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"

Read other 1 answers

Hi community
I try to save an excel sheet with comma, but I always receive semicolon. I know that I have to change Format in Region to English USA, but it still remains semicolon. Can somebody tell me what I could do ?
I am using windows 10 and office 2013 on a HP Pavillon g7 and a few weeks ago this has worked.

A:Excel 2013 saving of csv file comma instead of semicolon doesn't work

Have you seen this Microsoft page?

Read other 2 answers

I’m in the process to make an Excel (2013) contacts address workbook and have all my contacts in Excel now. I would also like to have some kind of a V-card to be able to input new contacts and view existing ones. A typical V-card could be like the one I downloaded from here


I can make my own V-card but the problem I have is how to integrate the V-card to interact with the contacts database I now have.

Anyone can give me some help or perhaps provide an existing template?

A:Solved: Excel 2013 Contacts DB

Read other 16 answers

I bought a new pc with Win7 pro, 64bit. It came with a intro version of Office which I added the full version mth ago.
All of sudden I can't run Excel or Word. I get a popup saying the file not compatible with the ver of Win I am running.

Anyone see this issue before ?? Could this be a virus ??
I was thinking of running system restore to back a few days ago. I started to have some redirect issues on Firefox as well after downloading a Media Player Codec Pak from CNET. I always say no to the add-ons - but I get them anyway. It's irritating.


A:[SOLVED] Excel 2013 doesn't open

Re-install Office; choose "repair" option.

Read other 3 answers

I have been using Excel 2011 (Mac), but when I try to save or copy worksheets over to Excel 2013 onto my PC the sheet layout changes. Not only do I need to adjust the row height and column widths afterwards, but the zoom level too. All this I find time consuming when I have a number of worksheets.

I understand you can save to an older Excel version, but how do I save from 2011 to the latest 2013.


A:Solved: Saving from Excel 2011 to 2013

Hi, I'm not MAC man but besides the format and zoom issues maybe this link can help you along the way

Another link:


Read other 2 answers

Hopefully this can be done easily.

Column D is my bank balance and I don't want everyone seeing it. Especially my wife who tends to spend more at the store if she sees it while I check it
How can I keep only the last 4 digits visible?
549.67 would only show
549.67 until I highlight it with mouse.
My wife only has one allergy. Money !

A:Solved: Excel 2013 Help needed with Conditional Format

Read other 11 answers

I have a large number of graphs and charts that have been created which need to be updated every year (linked to five-years reporting). Is there anyway to do a global change of the legends so, for example, every legend entry for 2007-08 becomes 2008-09, 2008-09 becomes 2009-10 etc. rather than having to go into each chart, clicking select data and then edit each individual one? I'm using Excel 2013.

Many thanks in advance for any advice!

A:Solved: Global Change of Legend Entries in Excel 2013?

Well, if you're going to use the same template from now on, you could just create a cell with the name in and link to it as the chart label ...

Read other 3 answers

Here is part of my code where it errors out in 2013 for the sort .apply but not 2010 and can't figure out why. Help appreciated. I have recorded same in 2013 with same results.

Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\Temp Data\mydata.csv"
Selection.Delete Shift:=xlUp
ActiveSheet.Range("$A:$AM").AutoFilter Field:=33, Criteria1:="<>"
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Range("$A:$AM").AutoFilter Field:=33, Criteria1:="="
Application.CutCopyMode = False
Sheets.Add After:=Sheets(Sheets.Count)
Application.CutCopyMode = False
ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Add Key:=Range( _
"Q:Q"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
With ActiveWorkbook.Worksheets("Sheet2").Sort
.SetRange Range("A:AM")
.Header = xlYes
.MatchCase = F... Read more

A:Solved: Excel 2013 Sort Macro errors out at .Apply but not in 2010

Read other 13 answers

Hi there,

I have a spreadsheet of 700+ zip codes. I have another spreadsheet that has 500,000+ e-mails and zip codes. I need to search for the 700+ zip codes within the 500,000+ e-mails and zip codes and copy those e-mails in another Excel spreadsheet.

Basically, I need to find the e-mails of the people who live in particular zip codes. Using the autofilter isn't enough, because there are so many zip codes.

Thanks in advance!

A:Solved: Excel Search

Read other 8 answers

I'm pretty new to this stuff, please be patient. I was able to find vba code to create a search box, and it works great! My search input box will look for the data in another worksheet and copy and paste the entire row on the sheet that the search box orginated on. It is exactly what I want. Except for when it comes to cancelling the search. If you select the cancel button in the input box, it does cancel the search but it takes you to the worksheet that has the data. Can someone help me so it will leave you on the original worksheet instead of taking you to the worksheet with the data?

I think its doing this b/c the search box is going to that sheet to begin the search, then once you click on that cancel it stops everything and leaves you on that worksheet that it was going to search?

A:Solved: Excel VBA search box help

Read other 8 answers


Need assistance on the below Excel issue.

When we open excel file, other minimised excel files get maximised, help me with the resolution.

Read other answers

Is anyone good at using excel? I need help with making an input box that will allow me to enter numbers, And these numbers will automatically register with my other work sheets in my work book.

A:Excel 2013

Read other 8 answers

I need a macro that will prompt the user for a number, then will search a column of data and give the user a green light if the number is already entered or a red light if the number is not already in the data base. Preferably I would like the data base as a separate workbook so it could be updated remotely while the program is running at an operator station. I am new to excel and was wondering if there is a clean simple way to do this.


A:Solved: Excel Search Macro

Read other 16 answers

I have:
A worksheet with 11 columns, about 400 rows, with mostly text data.

I want:
To create a "Search" button on the spreadsheet that opens a form with a text box to enter search criteria, with a "Search" button and a "Cancel" button. When the user enters criteria and clicks "Search," rows with cells matching the data return in a different worksheet.

The problems:
Say the user wants to search for "Texas." Texas could be in several cells within the same rows - B7=Texas, C7=Texas Study, D7=Go Texas, E7=Texas, Texas, Texas, etc. So I don't want it to return the same row 6 times since it has 6 different instances of "Texas."

As shown above, the specific keyword they're looking for may be buried in other text within the same cell, so the search function needs to sort through and find all the instances.

I'm a beginner to this macro stuff, but I have the basics down. I just need help with a code for the search function. Any help would be appreciated!

A:Solved: Excel Search Macro

Read other 12 answers

Dear All,

I hope this e-mail finds you well. I am trying to set up a macro for a search in excel.

I have a column of locations I am interested in searching in column C. I then have a list of search string (villages in Nigeria) in column A. I would like a macro to choose the first search string (village name) and then search through all the locations in column C. I would like it to then report the text and row number of the cells that contain the village name in any part of the string in a separate worksheet. I then want the macro to choose the next village in column A and do the same thing over again. And so on.

I attach a shortened version of the spreadsheet I am working with.

I have tried searching the forum and doing this myself but I was unsuccessful. Thank you very much for your help in advance.

With best wishes,


A:Solved: Search macro for Excel

Read other 13 answers

Hi guys

I was searching through the forum and found this post:

I was looking to use the same code for the search function.

Sub test()
If ActiveSheet.Name <> "Sheet1" Then Exit Sub
LastRow = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row
SearchTerm = Application.InputBox("What are you looking for?")
Application.ScreenUpdating = False
Range("L1") = SearchTerm
Range("L2:L" & LastRow).FormulaR1C1 = _
If WorksheetFunction.CountIf(Columns(12), 1) = 0 Then
Application.ScreenUpdating = True
MsgBox "None found."
For Each Cell In Range("A2:A" & LastRow)
If Cell.Offset(, 11) = 1 Then
Cell.Resize(, 11).Copy Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
x = x + 1
End If
Next Cell
Application.ScreenUpdating = True
If x = 1 Then
MsgBox "1 matching record was copied to Sheet2."
MsgBox x & " matching records were copied to Sheet2."
End If
End If
End Sub

Can anyone please help me to extend this search function over 24 columns of data instead of the 11 as above?
I have very little knowledge of VBA.

Thanks ... Read more

A:Solved: Excel Search Macro

Read other 6 answers


I'm trying to add a search macro to the search button in the 'search' sheet in the attached. I'd like it to search all the other sheets (minus the 'index' sheet) and then display the results within that sheet.

Thought the easiest way to show this would be through putting in entries in all of the sheets and showing how I would like them displayed (example results in the red text). The corresponding search to these results would be 'bread'.

Would be grateful for any suggestions on how this could be done.

Mnay thanks in advance.

A:Solved: Search button excel

Read other 10 answers

Running Windows Vista Premium Home Edition.

I have an Excel 2003 spreadsheet.that I originally created on Excel Office Professional Edition 2003. Also, have Excel 2007 Home and Student Edition installed. I uninstalled the Excel 2003 software, but now when I clik on this created Excel 2003 spreadsheet with Excel 2003 it will not open. It says there is an invalid path. I reinstalled Excel 2003 and it opens. I tried to save this as an .xlsx extension and then uninstalled Excel 2003. It wouldn't open. So something is occurring here. On other Excel 2003 created spreadsheets, they open without issue.

Then I have a program with an .exe extension. It needs to open using Excel 2007. With both Excel 2003 and Excel 2007, it will not open. It freezes and then I get an error message saying it cannot open with another Excel other than 2007. If I right clik on the .exe program, there is no "Open with". I even tried opening a blank Excel 2007 spreadsheet and then cliking on "Open". but it is a bunch of gibberish. My IT person says you can't open the program that way, You have to launch it as an .exe program using Excel 2007.

Any ideas on what is going on? By the way, I have both Excel versions on my laptop running Windows XP and I do not have these issues at all.

A:Solved: Some Excel 2003 & Excel 2007 applications won't open on Windows Vista

Hi there,

If I said I was confused that'd be an understatement I think. You cannot open executable files (*.exe) with Excel. Recognized file types are things like .xls, .xla, (for 2007) .xlsx, .xlsb, .xlsm, etc. I don't know what your exe file is and I'm not sure I wanna know, but it certainly doesn't open in Excel. What is it exactly? If you don't know I wouldn't open it. Or if someone told you to open it with Excel then it's probably a virus. Unless I'm missing something here.

With the file in question which won't open, assuming it's not this strange and unknown exe file you're talking about, sounds like the file may have been corrupted. Does it open on any other machine? And if you uninstall Excel 2003, did you re-install 2007? It seems strange. I would try cleaning out your application and reinstalling 2007 fresh. You can't install 2003, then 2007, then take off 2003 and put it back on, you're gonna get things screwed up. I bet your registry doesn't know which way to turn here. Some good info on it can be found here...


Also, I would highly recommend you completely uninstall all versions, and I'm talking a deep cleaning, then reinstall. For that deep cleaning, take a look at this article (which I'd highly recommend you do) and then reinstall...

http://officearticles.com/misc/remove_microsoft_office_from_your_pc... Read more

Read other 2 answers

I am trying to create a code that will autofilter data on an Excel worksheet. The code works fine to filter the data, but it does not hide the AutoFilter Arrows.

Below is the code I am using. What (if anything) is wrong with the code below?

ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>", Visibledropdown:=False

A:Solved: Excel 2007 Macro -> Hide Excel AutoFilter Arrows

I noticed that the code above (in Post #1) that the AutoFilter Arrows were beinf truned off on Field 2, but none of the others.

I have played around, and done some research to come up with the code below:

Dim c As Range

For Each c In ActiveSheet.Range("A1:D1")
ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>"
c.AutoFilter Field:=c.Column, Visibledropdown:=False

Does anyone have a better solution?

Read other 1 answers

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help

A:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

Read other 6 answers

Problem in Excel 2010 [but revives a Closed TSG thread for Excel 2007]

The "Personal Macro Workbook" is a file called Personal.XLSB
The Personal.XLSB file is in the correct location /XLSTART/
The file properties option "Opens with Excel" is selected.
The file contains a (freshly re-made) macro.
(It also contained the same steps macro before it was deleted
and re-recorded during troubleshooting for this problem.)

When Excel is opened, the Personal.XLSB DOES NOT OPEN WITH it.

Because the Personal Macro Workbook does not open,
- existing macros do not function,
- nor can new macros be recorded

Same not-opening result, whether opened by clicking on
- Excel, in the Programs list or
- a desktop shortcut to a specific Excel file

However, the Personal.XLSB file can be opened and the macro made functional
by manually opening that file where it is stored in /XLSTART/

An unexplained workaround was identified in the closed thread.

*rename the Personal.XLSB to Personal.XLSA

I find this workaround effective.
The Personal.XLSA file opens with Excel and the macros are available.
But the file seems to be grayed out when viewed with Explorer in /XLSTART/

However, I do not like using workarounds, as they can cause trouble later.
I find that the "open with" setting was changed when the extension was changed
The setting is now "Opens with: Windows Shell Common"

I would appreciate an explanation how to make Personal.XLSB open as it should.
... Read more

A:Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

Read other 16 answers

I’m using Windows 7 and I used a macro which worked totally fine under Excel 2003. Now, under Excel 2007 it does not run anymore but displays the following error message:

"Run-time error '445':
Object doesn't support this action.

The function of the macro is to open up all other Excel spreadsheets located in the same folder and copy data out of them into the spreadsheet in which the macro is stored.

When I click on "Debug" the Visual Basic Editor highlights the row which says: Set FilSrch = Application.FileSearch

Can you help me with this? I've searched for a solution for a long time but could not find anything which worked.

The following is the start of the macro code:

Sub UpdateTable()
Dim X As Range, I As Integer, J As Integer, RecNo As Integer, CopyVal As Variant
Dim SourceBk As Worksheet, DestBk As Worksheet, StartRow As Integer, IndRange As Range
Dim ServRange As Range, SrcOpen As Boolean, SourceName As String
Dim FilSrch As Object, MyFilArray() As String

'MsgBox "This function not available in this version.", vbInformation, "Function Not Available"
'Exit Sub
'Sheets("LookUp").[a12] = Now
With Application
.ScreenUpdating = False
.StatusBar = "Counting source files ..."
End With
Set FilSrch = Application.FileSearch
With FilSrch
.LookIn = ActiveWorkbook.Path
.FileType = msoFileTypeExcelWorkbooks
If .Execute > 0 Then
ReDim MyFilArray(.FoundFiles.Count)
For I = 1 ... Read more

A:Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested

Read other 7 answers

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you

A:Solved: Excel macro to extract Word form data into Excel

Read other 7 answers

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.

A:Solved: Excel 2010 v Excel 2003 Error Valid Range

Read other 14 answers

I just installed Windows 10 on everyone's laptop here and now I have a bunch of users that their Excel will ocassionally not save or will have graphics issues.  I have tried several suggestions, such as checking their .com add-ins, updating their DisplayLink, and trying to use it in safe mode.  Nothing has been able to fully fix it.  Has anyone else experienced this?  I have heard that Microsoft knows about the issue but has no fixes for it, but I have heard/read that so much that I just don't want to fully believe it.  If anyone has seen this and found a fix can you please help?  Thanks in advance!

Read other answers

I'm trying to open an add in in excel 2013 and I keep getting this message
Compile error
The code in this project must be updated for use on 64 bit systems
Please review and update Declare statements and then mark them with the PtrSafe attribute
I have no clue what to do

A:Excel 2013 error

Most likely you have Office 2013 64 bits installed and the add-in only works on Office 2013 32 bits!

Read other 7 answers

That?s new to me and can?t find any answers on the web. The attached snip is from a workbook I made a few months back and all was ok but now as you can see the first row looks like its missing because there are labels on that row which I can?t see.

In addition, the heavy vertical black lines are not mine (when I click on them it says ?Oval Object #...? and there are 2 vertical rectangles which are not mine either.

The only explanation I can give is perhaps an update from MS change all that

If I copy this workbook as an Excel.xls and view it on my other laptop which has Excel 2000 all is normal and copying this normal workbook and open it with my Excel 2013 the same strange things happen again

Any idea how I can recover my original

Read other answers

Hi, I have a desktop win7 32 bit OS and installed MS Office 2013. I can print from ms word and other word application accept for excel. Every time I press print a message pops up saying "no printer found". I also cannot set the brother mfc 8910 printer to default printer, it displays a message "operation terminated"

How can I get excel to print and have the printer set as default?
Also I want to know where I can go to see the details / specs of ms office suit that indicates 64 / 32 bit?

A:ms excel 2013 not printing.

Read other 8 answers

Hi Guys,

Let me start off by stating that I'm still trying to learn all the juicy functions you can do with Excel, and I've just gotten myself a little project where I think I can learn but I need some kind of help from you guys.

Basically what I'm trying to do is somehow automate a creation of a report via excel, first method I thought of was to use macros, but since the data that'll be included in the report will be on a different cell each time, macro might not work as I imagined it to be, then I thought of the IF function, I have not yet tried doing that, but would that work? Can you please share your thoughts? Ask me any additional info and i'll try to explain it as simple as I can.


A:[HELP] Programming in Excel 2013

Your description is entirely too vague in order for anyone to offer any kind of help. Can you be more specific as to what kind of a report you want to generate and what data you will be using?

Perhaps you could post a sample of the worksheet with the data and a sample of what you want the report to look like.

Read other 2 answers

Excel 2013 can't be opened on my Windows 8.1 laptop, can any Microsoft specialist help me?

Read other answers

I have a series of sequential dates in column A
In column B I have numerical data
In column C I would like to look at the previous year as determined by column A and the result would be the highest number in that range from column B.

The period in column A I'm looking at constantly changes as I move down the spreadsheet because the dates change. I think I may use the LOOKUP OR VLOOKUP function to get my result after defining the range.

Can you help me define the range for the lookup as a formula. (i.e A255:A255- one year)

Thanks! I hope this is clear.

A:Solved: excel 2013 "conditional range"

Read other 10 answers

I am looking for a macro that will find every every
instance of the word SATIN (or any other word in Col B)and return it with the associated
item key # with search results starting in Row E12.
When I do a new search I would need all the old search results cleared out.
There are 3000 rows in the actual list.

A:Solved: Excel search Macro needed

Read other 12 answers

Hello. This must be a simple one!! In the attached workbook, I have 2 sheets. In sheet 1 “System data”, I want to populate a name in each cell. That name is dependent on who owns the system number. The owners of all the various system numbers are in sheet 2 “System owners”. So basically, for each row in column D of “System Data”, I need to search for the number in the corresponding row of column A in that sheet, against all of the numbers in “System owners”. Then, when it finds the number, I need to return a the name at the top of the column into the cell. I am sure its easier to do, then explain!!

A:Solved: Number search and return in Excel

Read other 8 answers

Hi all,

In the attachment i've added my example file.
I'm creating a file which has data in sheet 1, and in sheet 2 this data needs to be outputted.

In sheet 1, each row has a client name and some extra information. Behind these values I have weeknumbers.
Each customer gets his products delivered on a date, but some get products twice a week. These dates and data (date of delivery (leverdatum), weight (gewicht) and Dry matter (droge stof) are filed in under the correct weeknumber (maximum twice deliverd a week).

In the second sheet, me as user, should be able to select the name of the client, the weeknumber, and if necessary the delivered date (if delivered twice).
Depending on this selection, the Dry matter ("droge stof") should be shown.

How can I do this?
I really need a solution on short term.
I don't know if I explaned it clear enough.

Thanks in advance.


A:Solved: Excel search vLookup and hLookup

Read other 10 answers

Hello Everyone,

I'm new to this forum. I'm trying to add search button in my excel sheet to find the data from database.
Eg. There are 10 stores and am looking for a particular product I just need to enter the Unique Code and click on Search and it will provide the Store Name which has it along with Quantity. If more than one store has the same product then all stores names should appear with quantity.

I have attached sample file. Thanks in advance!

A:Solved: Add Search Button In Excel 2007

Hi, welcome to the forum.
Have you tried recording a macro? You can then edit it if needs more functionality and the either add it to the QAT bar or assign the macro to button you can place on that particular sheet.

BTW you could also use AutoFilter

Read other 2 answers

Hey Everyone!

This is the first time I have posted on here. I am working on a tracking device with excel. It is a data base of retailer information. Each has a unique retailer ID number in column A and I have a total of about 2100 retailers listed each in their own row. I have built this for multiple users so that I can compile each of their progress each week. The problem is that most of the people using this do not know much about quick searching or anything to help them to conveniently find the proper retailer without scrolling for 5 minutes. I have tried explaining the F5 search and using the namebox in corrolation with a vlookup function with no avail.

What I think I am needing is a Macro that can be activiated by clicking a hyperlink (i am new to working with macros and by new, I mean, I do not knwo how to write the code for them) that will bring up an entry box that will allow a number search in cloumn A and then travel to that cell if it is found.

Thanks for any help anyone can offer me.

Also, maybe a brief explanation of any problems I may have by sending a workbook with macros to multiple people. I do not know if they will need to allow them or do anything on their part.

Thanks Everyone!

A:Solved: Search and Goto Macro in Excel

Read other 9 answers

Hi there,

I have an excel sheet i use to conduct a search. Right now it works almost perfect for what i need. I enter in the search criteria, and it goes to another workbook finds the results and displays the entire row in the original workbook. I couldnt be more pleased with how it works, except for 1 thing.

The problem comes in when there are multiple results for the search. If there are multiple results in only pastes 1 result (and oddly it hides the next row) in the original workbook. This is a problem as i need it to paste all results fine.

Whats interesting is that it will paste all results if the data is within the same workbook (if the search and the data are in the same workbook it pastes all results just fine). But since they are on separate workbooks, it only pastes 1 result.

Here is the code i use, its attached to a button in the search workbook, this is where you enter the search criteria and where the results paste, it has the code. Hopefully you'll see the problem once you look at the code. I assume the problem is how the 2nd workbook (the data) is referenced because this issue happens when referencing an outside workbook. But this was the only way i could get it to work with another workbook.

Thanks for any help you can provide!


Sub Button1_Click()

'Find my data and list found rows in report!
Dim rngData As Object
Dim strDataShtNm$, strR... Read more

A:Solved: Excel - Display all search results

Read other 12 answers


I'm new to board and it's a pleasure to meet all of you. I have a small problem that I think some of you might be able to help me out. I don't know exactly if this could be done by formula but I would prefer it as such.

In the workbook provided, I have a list of names and their arrival and departure hours. I need to check the folowing:
• if the departure hour in cell C1 is bigger than 00:00
• if column B1 contains a time

If both are true then copy A1, B1 and C1 to E1, F1 AND G1. If not, then just use blank as a result.
Hope that I was clear enough and that it can be done with a formula.
Thanks for the support.

A:Solved: Excel formula search and copy

Read other 12 answers

Hi, I need help with a search macro for excel. I need to search coulmn B for a number (all types - integer, decimal) then if that is found check column A (in the same row) to see if it is blank. If it is blank I need to put an 'x' in that corresponding cell in column A. Here's an example:

col A col B
r1 ____ 3.25
r2 text 10
r3 ____ text
r4 ____ 8

It doesn't line up perfect but you get the point. So here the macro needs to put an 'x' in A1 & A4.

In addition, I have another macro I'm using to return a value for the last row called 'myLastRow'. I want to use this variable in a For statement to have the search & decide macro know when to stop looking in column B since the data changes from scenario to scenario.

Thanks for your help in advance!

A:Solved: Search & Decide excel macro

Try the macro below. Just change the portion highlighted in red to reflect the first cell in column B to check.
Sub FindNumbers()

For Each vCell In Range("[COLOR="Red"]B1[/COLOR]:B" & Cells(Rows.Count, "B").End(xlUp).Row).Cells

If Not IsEmpty(vCell) And IsNumeric(vCell) Then

If vCell.Offset(0,-1).Value = "" Then

vCell.Offset(0, -1).Value = "X"

End If

End If

Next vCell

End Sub


Read other 3 answers

I need to search for multiple names (20-50) in one sheet which contains thousands of words. Is there a macro I can use? It's a very simple sheet and I can do the search in 1 column only if needed.

A:Solved: Multiple search in one sheet EXCEL

Read other 6 answers

I have a 2 spread sheets which it has some employee information(Sample),
I need to compare those 2 sheets,
Sheet 1: data is taken from database and it has 12 columns where column A has unique values no repeatation (Employee ID)
and number of rows are 10 (Example there may be more than 10000)
Sheet 2: Data is taken from Application and it has 12 columns where again it has Employee ID as Unique key, but Number of rows are 12
If I compare excel Row cell to cell then I am getting wrong results as in sheet 2 it has 2 extra values and they are coming somewhere in between,

I want a solution to compare these 2 files,
Below is what i am thinking to do the macro,
Steps to do:
1: Open Sheet 2
2: Temp = Value(Sheet2.Cell(A2))
3: Open Sheet 1:
4; Search Temp in Sheet1.Column A
If Result is True Then temp1=Sheet1.Row Number
Compare Sheet2. Row 2 Value = Sheet1.Row(Temp1)
If all data matches highlight green color
If any data missmatches highlight in red color
If result found = False
Then copy Temp to Sheet3

Any one can help me,

A:Solved: Excel Macro Need help to search and compare

Read other 14 answers

Is anyone familiar with findreplaceexcel? I need to replace an email address in a few hundred workbooks. This looked like a good tool but these are work invoices.

Any other ideas?


A:Solved: Excel--Global Search & Replace

Read other 10 answers

I have just been upgraded to Excel 2007. I find that some of the macros that were recorded in Excel 2003 no longer work in Excel 2007. We use the Analysis Toolpak VBA add-in and I have added this in to 2007 ok, but when running a macro I get a run time 1004 error ATPVBAEN.XLA cannot be found. After some searching it would appear that some of these functions have been renamed in 2007 e.g. it is now a .XLAM file rather than .XLA which is why the macro code can't find it. I guess I could manually edit all the macros and change the fucntion names but there are other colleagues in my team that are still using 2003, so I don't want to break things for them. Is there any solution to this? Thanks

A:Solved: Problem with Excel 2003 macros in Excel 2007

Read other 8 answers

Firstly I am a beginner of beginners but I try to learn as much as I can.
I have put the following protection code into an Excel 2003 workbook and everything runs ok. I then opened the workbook in Excel 2007, and saved it as a .xlsm file. When I try to open the .xlsm file in Excel 2007, I get a vba Runtime error 13, "Type mismatch", and the code sticks at the first line below("If Worksheets...). I have tried everything that my limited knowledge allows, searched the web for 2 days, and still have no answers.
Any help would be greatly appreciated.

Private Sub Workbook_Open()
If Worksheets(28).[A51] > "" And Worksheets(28).[A50] = Worksheets(28).[A51] = False Then
MsgBox "Sorry, this program is not registered for this computer, please e-mail .......... for more info."
Application.DisplayAlerts = False
End If
End Sub
My system specs are shown below.

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i3 CPU M 380 @ 2.53GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2934 Mb
Graphics Card: Intel(R) HD Graphics, 1243 Mb
Hard Drives: C: Total - 290143 MB, Free - 172186 MB;
Motherboard: Dell Inc., 0WXY9J
Antivirus: avast! Antivirus, Updated and Enabled

A:Solved: Excel 2003 vba code not working in Excel 2007

Read other 16 answers