The discussions

How to copy informations from excel to ees

 Solved

Hello, 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...

6 replies Last reply on 22 Apr 2012 by
mimolaah

Removing apostrophe (') from the beginning

 Solved

Hello, 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...

2 replies Last reply on 22 Apr 2012 by
Duffy

Excel 2007 activex option button default?

 Solved

Hello, 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...

2 replies Last reply on 20 Apr 2012 by
Josh

Convert indian currency numeric to words

 Solved/Closed

Hello, 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...

1 reply Last reply on 19 Apr 2012 by
Josh

How to create a count down formula

 Solved

Hello 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...

3 replies Last reply on 18 Apr 2012 by
Rogue

Can not read pdf file

 Solved

i can not read pdf file plz help

1 reply Last reply on 17 Apr 2012 by
bluenose

Copy entire data immediately when entered

 Solved

Hello, 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...

6 replies Last reply on 17 Apr 2012 by
Chaaru

Excel date formatting into another column

 Solved

Hello, 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....

1 reply Last reply on 16 Apr 2012 by
rizvisa1

Excel - transfer information from file

 Solved

Hi 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...

2 replies Last reply on 13 Apr 2012 by
Andy

Add when multiple criteria is met in rows

 Solved

Hello, 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...

15 replies Last reply on 13 Apr 2012 by
Gouws

Forget my password of n2690

 Solved

Hello, i forget my password of n2690. Plz suggest some ideas quickly. Configuration: / Opera 9.80

1 reply Last reply on 12 Apr 2012 by
Ambucias

If fuction

 Solved

Hello, I would like to right this formula =IF(d5677="Maromix","RESIN-1925",IF(D5677="Marble" or "onyx" or "matamix" or "decoration","RESIN-1600","...

3 replies Last reply on 11 Apr 2012 by
rizvisa1

Sumifs in excel 2003

 Solved

Sir 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...

7 replies Last reply on 10 Apr 2012 by
rizvisa1

Cannot access all office 2003 file

 Solved

Hello, 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. ...

1 reply Last reply on 10 Apr 2012 by
jp26198926

Create new worksheet & copy the based on date

 Solved

Hello, 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...

17 replies Last reply on 9 Apr 2012 by
Raja

Copy worksheet to another workbook (unopened)

 Solved

Hello, 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 ...

6 replies Last reply on 5 Apr 2012 by
Josh

Create inquiry for quotation

 Solved

Hello, 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...

17 replies Last reply on 3 Apr 2012 by
rizvisa1

Copy & paste data upon click

 Solved

Hello, 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...

7 replies Last reply on 2 Apr 2012 by
wliang

Converting & then copying date format

 Solved

Hello, 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...

3 replies Last reply on 2 Apr 2012 by
Joe

Address of searched element

 Solved

Hello, 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...

9 replies Last reply on 31 Mar 2012 by
SoleilDeWindows1333333

Using text in 2 fields in a formula

 Solved

Hello, 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...

5 replies Last reply on 30 Mar 2012 by
rizvisa1

Excel macro help needed to name ranges

 Solved

Hello, 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...

5 replies Last reply on 23 Mar 2012 by
...

Conditional display of existing data

 Solved

Hello, Configuration: Windows XP / Firefox 11.0 I am trying to find a way to perform the following without Macro but met with much difficul...

2 replies Last reply on 22 Mar 2012 by
DeathByExcel

Excel related

 Solved

Hello, 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...

2 replies Last reply on 22 Mar 2012 by
DG83

Macro to create worksheets

 Solved

Hello, 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...

2 replies Last reply on 21 Mar 2012 by
Mike

How to make 2 vba codes to work correctly

 Solved

Hello, 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)?...

6 replies Last reply on 20 Mar 2012 by
Issa

Password forgot plz reset my password

 Solved

Hello, 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...

1 reply Last reply on 19 Mar 2012 by
Ambucias

Auto-copy of select rows to another worksheet

 Solved

Hello, 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...

8 replies Last reply on 18 Mar 2012 by
Big.Moe

I forgot my password (samsung e1120)

 Solved

Hello, i for my password I wish you could help me Configuration: Windows XP / Firefox 10.0.2

1 reply Last reply on 17 Mar 2012 by
Ambucias

Correcting vba code in excel

 Solved

Hello dears, I have the following VBA code : Private Sub Worksheet_Change(ByVal Target As Range) Dim cRow As Integer If Intersect(Target, Ra...

10 replies Last reply on 15 Mar 2012 by
TrowaD

Highlight unique or duplicate on 2 sheets

 Solved

Hello, 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...

2 replies Last reply on 12 Mar 2012 by
liton

Mircosoft office help

 Solved

Hello, 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...

10 replies Last reply on 10 Mar 2012 by
Ambucias

Excel dynamically fill cell with data

 Solved

Hello, 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 ...

6 replies Last reply on 9 Mar 2012 by
liton

Copy text frm a cell n append it thru macro

 Solved

Hello, 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...

2 replies Last reply on 9 Mar 2012 by
abhi

Column comparation in different datasheet

 Solved

Hello, 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...

2 replies Last reply on 6 Mar 2012 by
Ruben

Vba copy/paste cells then drop 1 row for next

 Solved

Hello, 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...

2 replies Last reply on 29 Feb 2012 by
shannon

Conditional formatting question

 Solved

Hello, 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...

2 replies Last reply on 24 Feb 2012 by
ALkoLiq

How to determine cell value in excel column

 Solved

Hello, 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...

4 replies Last reply on 20 Feb 2012 by
Nick

Excel macro

 Solved

Hello, 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...

4 replies Last reply on 16 Feb 2012 by
MacroNewbie

Open pdf file using command buttong in excel

 Solved

Hello, 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...

3 replies Last reply on 14 Feb 2012 by
IAN

Compare cell a1 to entire a col in sheet2

 Solved

Hello, 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 ...

7 replies Last reply on 9 Feb 2012 by
Guest

Excel problem

 Solved

Hello, Hello, I am hoping that someone can help with the following problem, I have a list of numbers, golf staplford scores, located in cell...

2 replies Last reply on 9 Feb 2012 by
ptkdave

Excel - copy data macro

 Solved

Hello, I am currently learning the tricks in excel but have become stuck. I have created an expenses sheet where employees record various expenses...

6 replies Last reply on 9 Feb 2012 by
fazster

How to move data in rows to columns

 Solved

The 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 ...

2 replies Last reply on 4 Feb 2012 by
Ema

If, then statement in excel

 Solved

Hello, 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...

4 replies Last reply on 3 Feb 2012 by
Fergie

Count days excluding weekends

 Solved

Hello, 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...

5 replies Last reply on 3 Feb 2012 by
Akshu

Show value of row 1, where row 2 is greatest

 Solved

Hello, 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...

2 replies Last reply on 2 Feb 2012 by
Matt275

Remove watermark/objects in pdf

 Solved

Hello, 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...

4 replies Last reply on 2 Feb 2012 by
mreccentric

Excel: populate data based on criteria

 Solved

Hello, 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...

12 replies Last reply on 31 Jan 2012 by
venkat1926

Excel comparision

 Solved

hello, can any one help me solve the following comparison problem.. a(reference data) b(raw data) c(status) ab ...

10 replies Last reply on 31 Jan 2012 by
Nitesh
Results 1451 - 1500 out of a total of 2,603