The discussions
General inquiry
Hello, How do I create a hyperlink on a button in excel ? Thanks Configuration: Windows XP / Internet Explorer 6.0
Formula reads only till 12th on month
SolvedHello, If I run the following formulae it gives the result only from 1st to 12 of the month. Is there any thing wrong with the formula or with my Ex...
Writing a macro
SolvedHello, I am trying to get data whcih has been inoutted into one workksheet to copy into another worksheets when it meets a command in one of the c...
Lookup for word in company name
Hello, I want to do a "Match" or "Lookup" for a word in a cell. For example I have 1,000 company names. I want to label them into type of compan...
Dates formatting in excel
Hi All, Thanks in advance for your help. I am autoformatting my dates in Excel 2007 to read as mmm-dd-yyy (i.e. Jan-01-2010) which is working per...
Help! please my interner browser wont open
Hello, My name is Edgar I have a problem with my laptop. the internet browser wont start when i open the internet explorer it closes down by itself....
Excel, if fuction with cell text values?
SolvedHello, I would like to include the text value of a cell in the statement I have for one of the IF options. So far my formula is -: =IF((B1...
Forget password
Hello, Hi! I put security lock in my contacts and I forgot the password. How I can open it again? My mobile is Samsung C5212
Req: 'if' formula in excel
Hello, In one of my excel formate below mentioned row/coloums are there, Disp. Month IPO # IPO Dt Customer Details Job Name PO No. PO DT Inv N...
Excel formula display in cell
Hello, I hope someone can help me. I need to print the step by step values of a formula in a cell for example ilets say: cells(A,3)= Cells...
How to copy and paste
Hello, I want to copy something from the 1st worksheet and paste to 2nd worksheet. I have already the code but did not work. What's wrong with t...
Excel:conditional formatting stops working
Hello, First of all i am using 3 rules in conditional formatting and those are =AND(c1"",c1today() Green it works perfectly but ...
Auto email when cells in range are edited
Hello, Heres my problem: The company I work for currently uses an excel spreadsheet for scheduling. Its annoying and cumbersome. Once updated...
Can you look into it ivan?
Hello, I have two excel sheets which have one column "name" in common. In one sheet, the values respective to that column are multiple and in anot...
Help me i have lost myy password
pls i have forgotten my password can you give me that back my id is starterfire111@yahoo.com
Setting up criteria for vba macros in excel
Hello, I need to set up a loop function that will only output the data of the cheapest house, with a pool. Here is what I have so far, but my...
Highlighting cells within a loop
Hello, I am trying to set my vb code to highlight columns C through G in a light blue color after each step of the loop. So for instance my for st...
Help with mailing list
Hello, Thank you in adavance for your assistance.. I am wondering how to create a spread sheet using Excel. I want to be able to have one master s...
Conditional formatting
Hello, I need to have a row change colors based on multiple cells in a row. For instance if a date (1/1/10) ise, etc.entered in cell A1, then the...
How to automatically copy data from excel?
Hello, I am running a data entry office and I need some help with present project. here is the exact scenario 1. I have data ready in ex...
Return digit that does not exist in a cell
Good Day all, Cell A2 is 012 in text format. Cell B2 is 0821 in text format too. Is there a function that can check value in cell B2 against ce...
Excel convert number to letters
Pls let me know how to convert numbers into letters in excel
Using if statement to check cell contents.
Hello, I have two sets of data one in a new spreadsheet with a suffix added and the the second in a master file with both (standard part numbers and s...
Server address
Hello, I have a dell 531S systerm, how can I find my server for email
Hyperlinks
Hello, I have a sheet with 200 clients listed at the top and 200 sheets (on same excel spread sheet) at the bottom with my clients spesific detail...
Web design
Hello, I need an excel formula that will count the number of cells that are highlighted black and contain data. Example - 5 cells highlighted blac...
Copy data from one worksheet to another
Hello, Configuration: Windows 7 / Internet Explorer 8.0 I am looking for a way where i can copy data from one worksheet to the another. Th...
Excel-formula
Hello, Configuration: Windows XP / Internet Explorer 7.0 I have 3 columns K, L and M that 2 of the fields are n/a and 1 of the fields will ha...
If & vlookup
Hello, My Msg Was deleted, why?
Deleting cells based on cell value of samerow
SolvedHello, When I delete cell D4 (it's contents turn to ""), I would like cells C4, E4, F4, G4 to be deleted as well. The row must still exist, so on...
Cmos password needed for insp 9300
Hello, Service tag info is: 6tcp671-595b. Please help. Thank you. Configuration: Windows XP / Internet Explorer 7.0
If
SolvedHello, If A1 = 80 then B1 = 100 or if A1 = 50 then B1 = 90 both these formules are in the same cell, Thanks Configuration: Windows XP / Interne...
Excel leading zero format
Hello, I would like some advice on formatting cells to have leading zeroes. I do know about using ="0####", but my problem is somewhat more comple...
Find partial match in a cell
Hello, I want to do a "Match" or "Lookup" for a word in a cell. For example I have 1,000 company names. I want to label them into type of compan...
I need the product key fast
Hello, I lost my product key and i need the powerpoint to do my homework! Configuration: Windows Vista / Internet Explorer 7.0
Assign macro to button on a multi-page tab
Hello, This seems easy but I am really stuck. I need to have a floating set of commands in a spreadsheet and I can't use attached custom toolbars (IT...
List 2 columns into one
SolvedHello, I hoping that someone can help me fix this. I have two columns with possible duplicate vendor name, example VendorName ...
Highlighting dates conditional formating
SolvedHello, How to highlight dates in "EXCEL" i mean Less than Today = RED Today = YELLOW Greater than Today = Green Please help me i've been...
How to make macros in excel
Salam All Dear any one help me to make macro inexcel I m very new in this field and i m copying some data from any web sit (i-e www.192.com) a...
I forget my key word to login in ti yahoo msn
Hello, Configuration: Windows 7 / Internet Explorer 8.0
Excel sheet
Hello, If you have data stored in an Excel sheet, describe the steps to import the excel sheet into MS-Access and to convert the data into a datab...
Need an advanced option i can't find
Hello, Looking for advanced excel options to change page to only copy what it displays in cells without the formulas, I only remember it was hold...
I need a formula for excel
SolvedHello, Here is what I need and cant find anywhere: IF A12="text1 (anywhere in text)",then b2="text2" please help provide a formula that ca...
Auto pop up before 15 of due date
=IF((B4-TODAY())
Pop up for formula
Hello, =IF((B4-TODAY())
Mmm
Where I live?
Password
Hello, lephone A1 i need security password kindly help to this message. Configuration: Windows 7 / Safari 532.5
Excel formula file linked
Solvedhttp://wikisend.com/download/466894/Check1.xlsx Their is a description on the file about what i am trying to do. besicly check one value to a list,...
Excel formula to pull data between dates
Hello, I have a worksheet from a payroll program that is exported into Excel. In column A it prints the date and then names, the next date and t...
Adjacent cell conditional format problem
Hello, I have a large-ish sheet (14000 rows) where I need to quickly validate whether or not values are missing based on adjacent cells. Each r...
