Search results for query: *

Hi excel gods :) I am searching for an value in column C of a worksheet. If the exact value is found (it will be a unique value on each row), I need to check the whole row and return the column header name for each cell which has the value "Y". For example, if I searched for and located 123...

I have the code below that searches the entire workbook for a value entered in C3 of sheet LOOKUP and returns the results specified in row 6 of the same sheet. What I need it to do, is to search for a value only on specific sheets in the workbook (and preferably in the column I specify) and then...

Here is a screenshot of the problem: The row I circled is how I need it to look, however if the search value appears on several pages, I get a new row for each page instead of just 1 row with all the results. Here is the code: Sub Lookup() Dim rng As Range, Cel, ms As Worksheet, ws As...

I am trying to do a search for a value across several sheets in a workbook. If the search value is found, it returns 2 of the columns on the sheets along with the sheet names. I have modified some code from another project I worked on, but I can seem to get the search results to display...

Hi All, I am using some code to do conditional formattting (since I have more that three conditions and that's all condiitonal formatting will allow). The problem is that whenevr I try to paste multiple cells of data, the formatting does not work. Initially I had a problem deleting multiple...

I need to build a calculator similar to what insurance companies use. What I need to be able to do is, if the current date is 6 months or less from your last birthday, to display that age and date. If current date is 6 months + 1 day (or more) from your last birthday, to display your next...

I am using the vlookup function with wildcards to search column A to find the adjacent value in column B. This function works, but I need to expand it to return all the matches (for partial searches). Additionally, I would also like to include the value from column A in the same cell the...

I have a workbook with a sheet that company users need to be able to access for calculations. The problem is, I need the following to work: I cannot change the security settings on all computers to allow macros to run. I need to be able to open the workbook without a security prompt about...

This might be easier if I show what I am getting and what I need... What I am getting: Title 1 ,12 Title 1 ,15 Title 1 ,19 Title 2 ,20 Title 2 ,23 Title 2 ,28 Title 3 ,3 Title 3 ,7 Here is what I need: Title 1 ,12, 15, 19 Title 2 ,20, 23, 28 Title 3 ,3, 7 Here is the code. I have tried...

I need to be able to access different images for a bilingual website. I have stored the same named images into separate folders (en and fr) in order to change them based on the language the visitor selects. The code below allows me to switch the value from the default en to fr and then back to...

I tried to do something which I initially thought would not be very difficult, but silly me... Here's the formula: $a = $_GET['a']; $b = $a+15; $c = $b+14; $d = $c+17; $e = $d+11; $f = $e+17; What I want is to put in 6 input fields. By filling in any of the 6, the others will calculate...

I need to be able to show the date for the third Saturday of each month. Anyone have any idea how to do this fairly simply?

OK... It's bee ahwile, but I have a problem with an undefined variable. Whenever I declare a variable on a page to be included on another, the variable comes up as an undefined variable. For example, if I was working on index.php, here is the code I would use: <? include("test.php"); echo...

Can someone tell me why a variable I pass in the URL (someurl.com/page.php?a=$b) works if I use it in the top part of the code of the next page, yet will not work further down in my code in the same page. (The value of $b is correct at the top of the code, but does not exist anymore in the code...

I need to select all the entries for a 7 day period based on 1 date being supplied. In other words, if 2006-01-01 is selected, all entries from (and including) 2006-01-01 to(and including) 2006-01-07 would be returned. I am using a MySQL database. Any ideas?

I am trying to write a loop that will write 10 rows with 6 cells in each row. I want to assign an id for each cell in increments of 1. I have been able to do so for 1 row, but am unsure how to proceed with the subsequent rows. Basically, I need the first row of 6 cells to be assigned ids 1...

I have installed MySQL on my Win 2K server. Everything seems to be OK, but I get the following error (in MySQL Administrator) everytime I reboot. [Warning] 'db' entry 'DBNAME USER@localhost' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It...

The formula below tells excel to assign a value of PRO to anything with the value H-Nov-030-01. How would I get the formula below to search for anything like H-(whatever)-(value less than 5)-(whatever)? =IF(OR(A3="H-Nov-030-01"),"PRO",IF(A3="ZFC","COM","PGR"))

I have a javascript which allows me to select items from one (select) menu and add them to another (which is later added to my database). The problem is I have to select the items one at a time. How can I modify this function (below) to allow me to add multiple selections at a time? The drop...