The discussions

Show date when amend excel sheet

Hello, How to set a formula, so that everytime I do a change in a cell or a cell range - todays date appear in a different cell. In other words...

1 reply Last reply on 26 Apr 2012 by
Mehedad

Excel macro - set and autofill a range?

 Closed

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

1 reply Last reply on 25 Apr 2012 by
pcsces

Request for default password - reg.

Hello, I am Vijay, I am using Samsung Metro gt-s3310i mobile, My SMS service is not working in my mobile. I would like to reset the the Master Set...

1 reply Last reply on 25 Apr 2012 by
jack4rall

Cherry mobile q3tv phonelock lost password

 Solved

How Can I Recover my Password Please Really Need Replies

1 reply Last reply on 24 Apr 2012 by
Ambucias

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

Need formula for unique pass/fail rate

Hello Experts, Can someone please help me with this? I need a formula that will allow me to find the unique pass/unique fail rate. (Sorry about...

8 replies Last reply on 22 Apr 2012 by
Tonya

Copy a1 cell and auto-fill into a column c

Hello, How can I copy A1 cell and auto fill into a column C until the last row same as column A? Thank you! Best Regards, YT Configurati...

1 reply Last reply on 21 Apr 2012 by
rizvisa1

Excel - join date and text

Hello, Below formula is returning date with numbers. can you please give me a solution where I can get date and text. =IF(F2="FIBSMSAPTREM"...

2 replies Last reply on 21 Apr 2012 by
rizvisa1

Copy the row and paste in a sheet w/ new col

Hello, I am using Excel 2007. I am trying to figure out how to copy a row from one worksheet (in workbookA) and paste to a new row in a differe...

4 replies Last reply on 20 Apr 2012 by
rizvisa1

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

Help please on excel search

Hello, Need your expert opinion on what formula i should use. Quite new using excel. Scenario: A | B | C | D ...

3 replies Last reply on 19 Apr 2012 by
Mehedad

Printing sequencial numbers in excel

Hello, I am wanting to print out purchase order forms with numbers on them in a order from 1-... If you know how i can do this please let me know as...

1 reply Last reply on 18 Apr 2012 by
xpcman

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

Moving one excel column to new excel column

Hello, I am a newbie in excel macro stuff. Would appreciate if someone plz help me to get a routine task automated. Let me explain what actually i...

1 reply Last reply on 16 Apr 2012 by
rizvisa1

Auto emailing from excell based on cell date

Hello, I have a new query here! I want to be able to send an email alert from to an email address based on date criteria: Example: Today's Da...

1 reply Last reply on 16 Apr 2012 by
rizvisa1

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

Count time entries between different hours

Hello, I am trying to count time entries between different hours. I've tried a couple of formulas but so far every formula i've tried does not see...

1 reply Last reply on 16 Apr 2012 by
Josh

Activation code difficulty - won't re-enter

 Closed

I have been running Office 7 pro for years. I have it on my Windows 7 computer, and I had a system crash, probably a downloaded virus. I needed to...

1 reply Last reply on 14 Apr 2012 by
pcsces

Excel

 Closed

Hello, GUYZ I NID HELP WITH THIS HUGE THING OVER HERE AS IT FOLLOWS 1. 1. Enter the following Data into the Spread sheet (marks 12) Aphache ...

1 reply Last reply on 14 Apr 2012 by
pcsces

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

How can copy data to bank cells only...

Hello, I need to copy column A to column B, but only copy contain from cells a on column A to cells on column B only when cells on B are blank and l...

1 reply Last reply on 13 Apr 2012 by
rizvisa1

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

Referencing data from a new worksheet

Hello, I am working with Excel 2007. I know how to fill in a worksheet based on information from another worksheet. This is a simple enough ta...

12 replies Last reply on 12 Apr 2012 by
Josh

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

If time take is equal to...

Hello, Here is the situation I would like a formula that will tell me if the truck left on time or not. If truck dose leave on time then it ...

9 replies Last reply on 11 Apr 2012 by
Josh

My browsers wont work

 Closed

Hello, my computer is a hp elitebook but is blocked by my school. the iternet works but when i pull up google chrome and internet expleror they come u...

1 reply Last reply on 11 Apr 2012 by
pcsces

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

Matching/copying data across worksheets

Hello, I hope someone can help me with a little Excel problem I'm struggling with regarding some reports I am trying to pull together, here is a b...

3 replies Last reply on 10 Apr 2012 by
jp26198926

Comparing/matching data across in excel works

 Closed

Hello, I have manually combined 4 separate reports into 1 workbook with 4 worksheets (1 for each report). Each row represents a separate job. T...

1 reply Last reply on 10 Apr 2012 by
pcsces

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

Macro for excel values to new sheet/new row

Hello, I have an Excel worksheet with drop down menus for selecting 10 colours which links to a source sheet to show the pigments needed for produ...

1 reply Last reply on 9 Apr 2012 by
rizvisa1

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

Save tab-delimited as semi-colon delimited

I see multiple postings on this issue all over the web with no solutions other than to write/use a macro... I am looking to save an excel workbook wit...

2 replies Last reply on 7 Apr 2012 by
rizvisa1

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

Custom number format including text

Hello, I'm really sorry if this is a 'silly' question, but I'd really appreciate any help that any of you great volunteers may be able to give me. ...

1 reply Last reply on 5 Apr 2012 by
aquarelle

Unable sending mails from outlook

Hello, I am suddenly unable to send mails from outlook. Can receive, however. It's urgent! Any help is appreciated! Thanks, Katerina Conf...

13 replies Last reply on 5 Apr 2012 by
kieferschild

Delete from first sheet and copying to other

Dear Friends, i have problem with excel sheet. i have two excel sheet that have lots of data. i want to delete from first excel sheet then nee...

1 reply Last reply on 5 Apr 2012 by
rizvisa1

Autorun a macro in excel based on sheet name

Hello, I use the personal.xls which has many macros incorporated into it with shortcut names. The application I use that opens Excel names the sh...

8 replies Last reply on 4 Apr 2012 by
rizvisa1

Pdf attachment cant open in outlook2007

Hello, i cant open pdf attachment throw my outlook2007 but i can open same pdf attachment throw my iphone plz help me give solution.. Confi...

1 reply Last reply on 4 Apr 2012 by
xpcman

Formulas not copying from worksheet to sheet

Hi There, my excel has been doing some funny things lately. 1. When I copy a formula from one worksheet to another, the actual formula does not ...

1 reply Last reply on 4 Apr 2012 by
venkat1926

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

Problem in my excel sheet please help me out

Hello, i hav poblem like... i hav code numbers for example.in coloum "B" if i enter dat code number i should get the name of the person or a deale...

1 reply Last reply on 2 Apr 2012 by
rizvisa1

Excel formula

Hello, I have a 2 colunm set of info on Sheet 3 in a spreadsheet (Column A numbers listed 1-600, and column B corresponding figures per number) wh...

3 replies Last reply on 2 Apr 2012 by
rizvisa1

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
Results 5351 - 5400 out of a total of 12,261