The discussions
Retrive value to empty cell
SolvedHello, Hope you can help me... The user select a value from a list (in Column B), then Excel need to find this value from a column (Column D) o...
Pdf file convewrsion
SolvedI am having a similar problem to the one I have copied into the e mail below. It seems all of my adobe acrobat files have been converted word documen...
How to concanate two cells "line by line"
SolvedHello, I have one cell that has names separated with alt + enter. On the other cell, I have additional information on those names (also separate...
Text to n rows + copy row and insert n times
SolvedHello, I would appreciate your help with a macro I am trying to create in Excel 2007. My data is as follows: Column1 Column2 Column3 Column4 D...
Excel macro - set and autofill a range?
SolvedHello, I recorded a macro for excel and part of the code is to create an index column that fills the cell with a row count (i.e. A2=1, A3=2, etc.)...
Cherry mobile q3tv phonelock lost password
SolvedHow Can I Recover my Password Please Really Need Replies
How to copy informations from excel to ees
SolvedHello, I wanna know if anybody can help me to copy 2 columns (supply) from Excel to EES (another program if anyone used it before) and then copy the...
Removing apostrophe (') from the beginning
SolvedHello, I have an excel sheet where I have formulas with an apostrophe in the beginning. Example: '+34+54+56+22 '+34+222+224+556 '+92+922...
Excel 2007 activex option button default?
SolvedHello, I have two activex option buttons, Yes and No. How do I get it to display "No" as marked as a default? I have created a process that c...
Convert indian currency numeric to words
Solved/ClosedHello, I have one requirement where I need to convert Indian currency numeric to words. Like 100.90 it should convert to Hundred rupees and Ninety...
How to create a count down formula
SolvedHello all I'd be grateful if anyone could advise on a formula to highlight a cell which would change colour 30 days before the expiry date. I belie...
Copy entire data immediately when entered
SolvedHello, I have a spreadsheet in which I maintain sale records of a no. of polymers. For every polymer (For eg. Adflex Q 100 F), I have a table show...
Excel date formatting into another column
SolvedHello, I want to check using IF function in one column and change the date format to another column from MM/DD/YYYY to has DD/MM/YYYY in excel 2010....
Excel - transfer information from file
SolvedHi there! I have run into some problems when transferring information from one Excel file to another. I have a big Excel file with a lot of informa...
Add when multiple criteria is met in rows
SolvedHello, I'm trying to add numebrs when multiple criteria is met! I want to add numbers in B115:BF115, but only the ones that have an "A" in row B8...
Forget my password of n2690
SolvedHello, i forget my password of n2690. Plz suggest some ideas quickly. Configuration: / Opera 9.80
If fuction
SolvedHello, I would like to right this formula =IF(d5677="Maromix","RESIN-1925",IF(D5677="Marble" or "onyx" or "matamix" or "decoration","RESIN-1600","...
Sumifs in excel 2003
SolvedSir I was using System with office 2010 and deriving some values by using "Sumifs" function. Now i am using Office 2003 system. When i copied the wo...
Cannot access all office 2003 file
SolvedHello, after i scanned my computer with eset nod32 i cant open/copy/move the encrypted(green font color) ms office file such as excel and word. ...
Create new worksheet & copy the based on date
SolvedHello, Can any one help me to copy the excel sheet data from one sheet to another sheet? -> I have one excel sheet (name: Test.xls, sheet name: S...
Copy worksheet to another workbook (unopened)
SolvedHello, I want to copy a portion (A1:F54) of my current worksheet that I am working on, over to another workbook, that is not open. I want to use ...
Create inquiry for quotation
SolvedHello, I'm Mike, I'm a mechanical engineer, in my company we send inquiries for quotations. I have two Excel file the first is a table where all t...
Copy & paste data upon click
SolvedHello, Good day. I need some advices on how to copy and paste data upon mouse click. I have a set of data on A2 to A10. When I hit cell B1 wh...
Converting & then copying date format
SolvedHello, I wonder if anyone can help? I have a spreadsheet with over 40k records which have the date format & time format like this: 02/01/2003 09...
Address of searched element
SolvedHello, hi help me pls... my question is --- A----- B---- c 1 as 2 ad 3 sd 4 dg 5 ki 6 we 7 rt 8 ty 9 ru my questio...
Using text in 2 fields in a formula
SolvedHello, Those who read and attempt to think about the following, I definately do appreciate you taking your valuable time to help me out. I want...
Excel macro help needed to name ranges
SolvedHello, I have a 10 column x 500 row spreadsheet A1:J500 I would like to name ranges as follows: Range A1:J1 should be named with the content of...
Conditional display of existing data
SolvedHello, Configuration: Windows XP / Firefox 11.0 I am trying to find a way to perform the following without Macro but met with much difficul...
Excel related
SolvedHello, could you please tell me how I get excel to automatically use a color in a cell that I write something into? The blank ones can remain colo...
Macro to create worksheets
SolvedHello, I'm Mike, I'm new to Macro excel I need a Macro that read from a table the name of projects and create for each project a sheet named th...
How to make 2 vba codes to work correctly
SolvedHello, How can I correct the following 2 codes (which written in the same sheet) in order to work correctly, other wise it gives me Error (debug)?...
Password forgot plz reset my password
SolvedHello, i have nokia 5130.my brother change password of my memory card.now he don't know password.now my memory card is locked.what i have to do...
Auto-copy of select rows to another worksheet
SolvedHello, This is my first time asking a question, so I will do my absolute best to follow and respect the forum guidelines and it's contributors. I...
I forgot my password (samsung e1120)
SolvedHello, i for my password I wish you could help me Configuration: Windows XP / Firefox 10.0.2
Correcting vba code in excel
SolvedHello dears, I have the following VBA code : Private Sub Worksheet_Change(ByVal Target As Range) Dim cRow As Integer If Intersect(Target, Ra...
Highlight unique or duplicate on 2 sheets
SolvedHello, I have a Excel file of 2 worksheets and have a list of Usernames on column B of both worksheets. Few of the usernames appear on both sheets...
Mircosoft office help
SolvedHello, i would like to ask , if i change my gmail pw will my microsoft outlook still be able to recieve mails and sent them or they are not able to re...
Excel dynamically fill cell with data
SolvedHello, I have worksheet ( AllUsers ) with two column A ( user id ) and B ( date ). Column A is a long list of user names and B is a list of dates ...
Copy text frm a cell n append it thru macro
SolvedHello, I am trying to create a macro where I want to copy a cell content from one worksheet and append it to a cell in another worksheet of the...
Column comparation in different datasheet
SolvedHello, Hello, I have one excel column A in datasheet 1 which has a list of names. In Column A of datasheet 2 I have a much longer list of n...
Vba copy/paste cells then drop 1 row for next
SolvedHello, I am making a questionaire. When the questionaire is complete I want to copy the answers to another worksheet then reset the answers to zero...
Conditional formatting question
SolvedHello, I am trying to create a formula for the following: If there is any text in cell A1, there is a border around cell B3. I know I need...
How to determine cell value in excel column
SolvedHello, Sorry the title is really vague, it's hard to describe with a limited number of characters. I have a column (C) which contains a full li...
Excel macro
SolvedHello, I wonder if anyone can help me with a small (I think) problem, please? I'm trying to write a macro to manipulate a spreadsheet sent to m...
Open pdf file using command buttong in excel
SolvedHello, i have a form in excel which retrieves details of a user from one of the worksheet. against tht user row, there is a pdf file name which basic...
Compare cell a1 to entire a col in sheet2
SolvedHello, I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to ...
Excel problem
SolvedHello, Hello, I am hoping that someone can help with the following problem, I have a list of numbers, golf staplford scores, located in cell...
Excel - copy data macro
SolvedHello, I am currently learning the tricks in excel but have become stuck. I have created an expenses sheet where employees record various expenses...
How to move data in rows to columns
SolvedThe data now is in the below format 1 2 3 9 15 16 20 25 1 This has to come in this format 1 2 3 9 15 16 20 25 1 ...
