Search results for query: *

Does anyone know if it is possible to create a Search Box in Excel that will return the rows where a searchterm has been found and is capable of finding text within a string? The Search I am using at the moment just works if the complete cell content has been submitted. The code I am using at...

I am trying to add a Search Box in excel and I have got some code off the web. The code says: 'Get the string to search for! strMySearch = InputBox("Enter what to search for, below:" & vbLf & vbLf & _ "Note: The search is case sensitive!", _ Space(3) & "Find All", _ "") but how do I add an...

I have a word document with about 700 hyperlinks to various documents within a WSS site and now they have changed the address of the WSS site. I have tried doing a "Show Field Codes" and doing a Find and Replace but when I undo Show Field Codes and hover over the links they are still showing the...

I have created a query in Access 2003 to count the number of times an article appears in a field. My problem is that I would like to show "0" if nothing is found and not a blank query. Any help would be appreciated.

Can anyone give me the formula for counting Years in Excel 2007? I have a spreadsheet with thousands of entries over the last 10 years and I need to count how many there are per year.

I am currently working with Excel 2003 and I have a spreadsheet that I have added some code to to change the cell and font colours. If I change the colours to something different from original, I then have to go over all the cells to get them to change to the new colour. Is there any way of...

We have a sharepoint survey in place to supply feedback. My question is, can you Close the window when someone clicks "finish". Our IM are saying it is not possible but I don't believe them.

I am trying to count dates in 1 Column and put the result in another. When I try =COUNTIF(!$V$2:$V$500,"") I get a rediculous number. Can anyone tell me what I need to put in place of "".

I have been given an Excel spreadsheet that contains thousands of entries. In one column there is a load of text that contains a Serial No. I need to extract the Serial No. to Column A. The Serial No. is always in the same place within the Cell (#15:#21). Does anyone know how to do this?

I have a spreadsheet and I need to create a Graph. In column J I have cells containing number and text in the format "1.1 Discussion Group", in column K & L I have numbers and I need to sum the total when 3 criteria are met. I have tried this formula...

I have a word document and Excel spreadsheet in a folder in MOSS and I need to create a mail merge from the Word document to the excel spreadsheet. I check out the Word document but when I try and select the Excel spreadsheet as the source for the mail merge I just get a message saying: "The...

I am trying to create an Update Query that pulls the information from one table and if the criteria is found in the second table deletes it. tblFind_Data is a one field table fed from a Search box on a form and tblBMS_Docs_From has 42 fields containing numbers in the format BS BP.0001 or 3.1.2...

I am trying to set up an Update Query to update records in tblBMS_Docs_From. I need it to update the field "Status" from the master data which is in a table named Raw_Data. The Status field has all set to "Published" but if one is changed to "Withdrawn" then I need tblBMS_Docs_From to update. My...

I have an Access DB in which I am trying to construct a Query. In the first field there is the Document number followed by a number of fields 01 to 09. I want the query to take the results from a table (simple lookup with only one field "Find")then find all the corresponding fields (01 to...

I have a spreadsheet with a column containing several numbers separated by a comma. Is there any way to split them out into individual columns. Numbers are in the format 12345,45678,

I have a spreadsheet with various columns and I want the number in column A to incement if data is input to other columns. What I have tried so far is: =IF(B5:K5="",A4+1,0)where columns B to K have data and column a has the number. Any help would be appreciated.

In Excel 2003, is there any way to get a count of cells that contain the letters PLC (cell contains PLC 1234 for instance). I would like to do it to obtain metrics from a spreadsheet containing document numbers.

Does anyone know if there is a way to undo any set filters in an Excel spreadsheet? I have a large spreadsheet used by several people and someone always leaves a filter on and unless you have good eyes it's hard to spot the Blue arrow from the Black.

I have an excel workbook that contains several worksheets and I would like it to always open with a specific worksheet that contains instructions on how to complete the spreadsheets. Does anyone know if this is possible?

I have been given a Spreadsheet with hundreds of rows of data and multiple columns. My problem is that they have put multiple entries in a cell. i.e. D2, S1 C5, R4. is there any way I can split these out to separate columns easily?