The discussions
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 ...
If, then statement in excel
SolvedHello, This formula sounds easy to come up with, but I cannot figure it out. I'm trying to figure out how to add a certain amount of days to a dat...
Count days excluding weekends
SolvedHello, I want to do a monthly report and I have four colums: "issue date" "pick date" "pack date" "Ship date", each cell have dates, I need a form...
Show value of row 1, where row 2 is greatest
SolvedHello, 0 1 2 3 4 5 6 7 8 9 10 0 2 5 6 5 1 3 1 0 0 0 1 4 2 4 5 4 2 1 0 0 0 0 4 6 5 1 5 0 1 0 0 1 1 0 5 8 5 3 1 0 0 0 0 in the t...
Remove watermark/objects in pdf
SolvedHello, I wanted to remove watermark/image like objects at particular portion of every page of a pdf. Can anyone please tell me which software app t...
Excel: populate data based on criteria
SolvedHello, Good day. I would like to populate data from 1 sheet to another sheet based on certain criterias. With reference to the sample data provide...
Excel comparision
Solvedhello, can any one help me solve the following comparison problem.. a(reference data) b(raw data) c(status) ab ...
Vba code in excel for 200 sheets
SolvedDear all who can help me. I have salary excel file. This file includes 200 sheets which are for each employee. I have the following VBA code. P...
Copy row if a range of column matches a value
SolvedCould you please help me with the following macro. The following macro basically copies the entire row if the column B contains the value "1". But ...
Excel help
SolvedHello, If possible, can you help me in coding this: Collumn J will have the drop down menu of Open, In Progress, Complete [Open as default] ...
How to create a row list according with dates
SolvedHello, I'm trying to create a list of dates according with the time periods shown bellow on each row, i.e. for entry 1991001, I need to replicate ...
