Search results for query: *

Good Afternoon: I have a problem with our database software that has stopped us from working for the last week. I know nothing abobout Access either. So here goes... We have 3 parts to our software. 1. is the application that controls our data 2. is the actual database (the data) and 3. is...

Anyone have a better way around this mess? If I put a "=IF(ISNA" in the formula I get "too many arguments" =INDEX(Sheet1!$A$1:$B$21, MATCH(H23,Sheet1!$A$1:$A$21,), MATCH("Price",Sheet1!$A$1:$B$1,)) Thanks in advance Carl

Sheet1 cell a1 has a data from a list on sheet2 column A. I need sheet1 a2 to look at sheet1 A1 then match that with the list on sheet2 column a and place the data that is in the cell to the right of the matched data (column B) I know ther's an offset and match, but it's over my head. Here's the...

I have a list of manufacturers. Sheet2, cell A1 has the name of the manufacturer. A2 has the Street # and name. B2 has the state, B3 has the zip. Sheet1 A1, has the list of names in a dropdown box, I need the appropriate cells below to populate apon selection of the manufacturer. I know I...

I have a date in column (A1), a date out column (A2). Some date in cells are blank, some date out are blank. I need a formula that looks to see if the date in cell is blank then "", but if the date in has a date value and the date out does not, then it must =DAYS360(A1,TODAY()). But...

Hi all! Try again with correcter speeling :) I have (for now) 2 issues. !. I get "#N/A" (without the ")so I tried putting the IF(ISNA at the begining but now I have too amny arguments (it tells me). Is there a way to get rid of the #N/A . Here's the formula at question...

My sheet is... A1=Truck or Car A2=1 or 2 So I need the if, and or deal to figure all the variables in A3. So the combination could be A1=Truck and A2=2 or A1=Truck and A2=1 or A1=Car and A2=1 .... I know this can't be that difficult, but I can't seem to get all together. I have it...

So, thanks for all the help. Everything is done and working. I now am being a little anal. The module saves my workbook in a folder "C:\Projects\Pyramid Docs" _& "\BOLLA04- " & Sheet2.Cells(3, 13).Value & ".xls" A little cumbersome, but it works. The only probem is, that the folder actually has...

So I have it almost all working. All I need now is either: 1. When the SaveAs dialogue box opens is have a suggested name in the "File Name" text box. Right now (as always) it uses the name of the workbook (book1 or whatever it maybe). or 2. ActiveWorkbook.SaveCopyAs "C:\Projects\Lists"...

So I have it almost all working. All I need now is either: 1. When the SaveAs dialogue box opens is have a suggested name in the "File Name" text box. Right now (as always) it uses the name of the workbook (book1 or whatever it maybe). or 2. ActiveWorkbook.SaveCopyAs "C:\Projects\Lists"...

So I have. Sub SaveThis() ActiveWorkbook.SaveCopyAs "C:\Projects\LIST" & "\List-" & Sheet2.Cells(11, 16) The value in Sheet2.Cells(11, 16) is a date. The cell is formatted to date, but when the file is save instead of it reading 8-11-04 it reads 36748 Also, it doesn't save the Excel icon, it...

I am just trying to have the print area to the last cell that has either data or any format or style or border etc. and back up to cell A1. Any clues?? I tried: ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Activate and then setting the range from cells(A1:activecell) but obviously that...

So in other words, I need to nock off the first 2 characters in a cell. I think I have done this before in the formatting of a cell but can't remember for the life of me. Thanks for any suggestions Carl

I need a macro or something, that would look down an intire row, find cells in that row that are balnk or 0 (zero) value and then hide those intire rows. Is it possible?? thanks in advance Carl

So, I need to convert minutes, to hours and minutes. I know it's an easy formula, I just don't know/remember it. HELP!!!

Hi again, I am trying to save my workbook in 2 places at the same time. Right now I do it manually, no big deal, but.... I have acommand button right now and it works to save it in a specific place, there are 2 plrobelms though. 1. it only saves it in one place 2. it won allow me to save it...

If the active cell is in A4, I would like a macro to add a complet row to row4. If next time the active cell is P451 then I need a whole row added to Row451. Any ideas?? Thanks in advance Carl

I have cell A1 formatted to time like this 12:00am. I have cell A2 with minutes, like 00:26. I need a formula to add the minutes to the time in A1 and come up with the new time ie 12:26 or if the minutes are 61 or 01:01 the the time in A1 should read 01:01pm. I thought I had a grip on Excel...

I would like a compass in excel. It should have degrees every 5. If anyone has one pre-formatted, I would love to use it. Thanks in advance Carl

Can I run a macro when a cells value meets a certain criteria? Thanks again to all