The discussions
Conditional formatting issue
SolvedHello, I'm using Excel 2007 I want my cell in F2 to be formatted conditionally to A1 being >250 and
Find text string in one column and replace
SolvedHello, I need a macro to compare two columns, only if particular texts in column C, text in adjacent row of column D should be changed. Text in ot...
Exel run time error 13
SolvedHi All, Please can you trie and help, I have a error message in my code. The error message comes in at this line. If cell.Value = 4 And cell....
Formula: to count cells and then add number.
SolvedHello, All Hope you can help! I have a list of actions 1 Contacts 2 Appointments 3 Estimates 4 Sales contacts counts as 1 contact,...
Forgett password
SolvedHello, I forgot my phone lock code (password)* on my Samsung S3650 Corby, and now i can't enter my phone. *I changed the phone lock (passwor...
Needed a vba.
SolvedHello, I'm very new to progamming kind of stuff... i need to generate a report from a excel sheet. Coloumn Q of "data" sheet has only 0 or 1, whi...
I forgot my mobile password s3310i
SolvedHello, hi i have samsung 3310i mobile i forgot my password plz tell me the solution this my new mobile plz Configuration: Windows 7 / Safari 53...
Mobile password forgot
SolvedHello, i have nokia5130c2. i have forgot mobile password so i can't restore factory setting...plz solve my problem.
Excel "if" for letters to equal values
SolvedHello, I have a yes or no sheet, one column for yes and one column for no. I want the end column to calculate a 1 for yes, and 0 for no, and in s...
Conditional formula
SolvedHello, Hi everyone, Just want to seek for your help about some conditional formula about excel. I just want to create program about our inven...
Word settings
SolvedHello, I change some of my settings when I went to word options on my vista word document, now when i open a blank document it is full of grid square...
Text function does not change date format
SolvedHello, I'm using the CONCATENATE function to put together a sentence mixing text and date. The formula I'm using is: =CONCATENATE("Text part he...
Simple excel formula help
SolvedHello, Configuration: Windows 7 / Firefox 3.6.17 Hey guys I'm doing some project on Excel for a class. When it comes to entering and crea...
Forgot my admin password on my old dell 630c
SolvedHello, i forgot my admin password on my old dell 630c can you help me reset or delete the password so my laptop will boot up>? windows vista/os i...
Msgbox retry/cancel buttons are confusing me
SolvedHello, I can't figure out what's wrong with my code. Hopefully someone can enlighten me. Here is the code I'm using: Dim x As Integer Sub Adj...
Excel name match query
SolvedHi I have a column (A) in excel that lists all of the staff in an organisation, and in column B is their telephone number. In column C is a list o...
Split data into multiple sheets using macro
SolvedHello, Configuration: Windows Vista / Firefox 4.0 I have an excel sheet with the data in following manner. a b c d 1 1 1 1 2 2 2 2 3 ...
If function error !!!
SolvedHello, I have created a time tracker worksheet for my process. Am just stuck up with one function. I have used the below function which has 8 ...
How to calculate a alphabet
SolvedHello, for my workers I am mainaning attandance sheet and every month I have to send it to my head office. for their presents iam putting P and for ...
Memory card password
SolvedHello, Hello, i have a micro SD card for my phone2700 Classic NOKIA and its password protected and i forgot password i cant open it from my ...
Matching word phrases over different cells
SolvedHello, I receive batches of text and need to weed through the duplicates. I have figured out how to find exact matches like "Good Food"repeated t...
Excel macro help.
SolvedHi, I was wondering if someone could help me develop a macro that would reference a row in another worksheet. So for example if Column H = "x" in ...
Excel macro to identify/modify/combine cells
SolvedHello, I have a collection of survey results in Excel that are coded from another software that I need to prepare to put in SPSS, the results come...
Conditinal formattin
SolvedHello, If e1 cell is contains "closed" the entire row (or) a1:e1 should be highlighted in red color. Configuration: Windows XP / Internet Explo...
Multi criteria conditional formatting
SolvedHello, I am trying to work out how to reference to cells for an if statement using conditonally formatting (through VBA), I have come up with the ...
Formulae
SolvedHello sir, your forumlae working fine, i would like to convert lakhs to paises please send .. Configuration: Windows XP / Internet Explo...
Select the cell that a button is in
SolvedHello, I want to run a macro using a button in Excel 2010 without regard as to the location of the current cell. In other words, when I click a...
Password reset
SolvedHello, I can't recall the password on my Toshiba C660/C660D laptop. On entering what I thought it was several times, it is now asking for a remov...
Color column range based on content in cell
SolvedHello Sir, I want to know how to color the column based on content in fixed cell like. In Row No 6, If The Value Of Row 6 Is "Sun" Then Color T...
Outlook won't send emails
SolvedHello, This is not a question, it is a statement. Outlook 2003 would not send emails through my ISP's smtp server. I probably spent 25 hours t...
Hiding a different sheet in workbook
SolvedDear sir, I have one worksheet and there are 20 different sheet in that worksheet. I want to show 1 or 2 sheet and want to hide rest sheet. May i...
Report from excel data sheet
SolvedDear Sir, I am new in excel. I am trying to use excel for my work easier. I have one excel file where there are different sheet of monthly salary ...
Show a range off a drop down menu
SolvedHello, What I'm trying to do is make a drop down menu that when you pick an option from it, the column next to it changes to a list corresponding t...
Excel vb macro
SolvedHello, I am new to vb and excel. I am trying to create a Macro that will look through all the worksheets in a workbook and find the column named "...
Codes for reminder creation in excel vba
Solved/ClosedHello, I want to get Reminder message box automatically, according to the date and time in Excel worksheet. What are the VBA codings & procedures?...
Can not run macro
Solvedhello sir, I am trying to put macro in any excel sheet then "can not run the macro" the macro may not be available or all macros may be disabled. ...
How to create shortcut keys to xl 2007macros
SolvedHi, I created few Macros in excel 2007,these working fine but how to assign short cut keys to these macros.In macros window in options property is ...
Ignoring rows with zero value
SolvedHello, A couple weeks ago ya'll helped me with some code to compare two sheets and create a new worksheet with all of the values that were identic...
Highlighting the values entered in an excel
SolvedHello, Dear All, I have a question to ask, Actually i am working with an Excel File which has so many sheets under one file, and this file ...
Copying data to another worksheet
SolvedHello, I have the following data in worksheet named "Auto Entry" Cell A1= X Cell A2 =Y Cell A3 =Z Cell A4=Input Value(1,2,or 3) In Cell A4 is...
Forgotten password
SolvedHello, i changed my password on my samsung S8300 today, i then turned my phone off, when i turn my phone on it asks for a phone lock, it doesnt except...
Excel: matching and sorting
Solved/ClosedHello, Ok, how sould a computer dummy to this (the dummy is me): I have a list of 300 bike racers. In the columns next to the racer is items such a...
Can someone please write me a macro for excel
SolvedI want to be able to input a number into a cell and have that number recorded in a list elsewhere within the same sheet. Then be able to replace tha...
Copy selected cells to new sheet in a row
SolvedHello, dear all, I have an invoice template in the range b6:f57 in one sheet.. I want to select only some cell contents like c17, f17, f 19 , f 32, ...
To recover a forgotten password of a mobile p
SolvedHello, I have a Samsung GT-S5603 mobile phone. I have forgotten a user password, so I can't open it, now. Please, tell me how to crack this passwo...
Find value between characters in one cell
SolvedHello, I get this report-list of personal information, in text format (TXT) Each area is separated by | Name|Experience|Age|Sex|Location|Contac...
Macros help
SolvedDear Friend i want to convert number to text in excel programme Example : ( 055555 : Zero five Five Five Five Five ) As This Format ...
Transfering data to a new sheet
SolvedI'm running excel 2007 on windows 7, if that's important. I'm trying to find a way to transfer data from a master sheet (or basically sheet 1) to...
Format data in excel for db transaction
SolvedHello, I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and end...
Formula for every 200hrs cycle
SolvedHello, now i'm trying to do a schedule maintenance for one part.the hours for the parts will increase everyday.e.g today 240 hrs,tomorrow 256 hrs....
