The discussions

Forget my phone password

 Solved

Hello, sir i forget my phone password please help me

2 replies Last reply on 4 Jun 2010 by
Ambucias

Excel formula

 Solved

Hello, I am looking for a formula or script that can help me with the following. I am doing a spreadsheet for 19 different offices (on seperate...

4 replies Last reply on 4 Jun 2010 by
djb

Matching columns

 Solved

Hello, I have to an issue with matching columns. Column A Column B Column C Column D Column A: This has 300 lines with account #'s Column...

2 replies Last reply on 3 Jun 2010 by
KJFin

If statement required please

 Solved

Hello, Date 1 Date 2 Days varience Status 04/05/2010 29/04/2010 -5 On Time 04/05/2010 06/05/2010...

8 replies Last reply on 2 Jun 2010 by
Ant

Macro that takes multiple csv files and puts

 Solved

Hello, I need a macro that takes multiple csv files and puts them all in 1 worksheet. The csv files all have header info that i do not want copied ...

3 replies Last reply on 1 Jun 2010 by
jrog

Ms office 2007 opens files as read only

 Solved

Hello, I installed Office 2007. Each time I open a file in Excel, it opens it as Read Only and won't let me save with the same file name and thus...

2 replies Last reply on 1 Jun 2010 by
AVISUR

Excel 2007 "if....then select row and move&qu

 Solved

Hi all! I have what would appear to be a basic question, but can't seem to put my brain around the solution. I have a spreadsheet on Sheet 1. O...

11 replies Last reply on 1 Jun 2010 by
rizvisa1

Copying data in a dfrnt sheet w/ condition

 Solved

Hello, Greetings everyone... I want to copy data from one sheet to different sheet but only if a condition is true. For example, 1st Shee...

5 replies Last reply on 29 May 2010 by
fairooz

Label name protected

 Solved

Hello, I was wondering if someone can help me. I want to know in this file at this address: https://authentification.site/files/22686748/Mac...

6 replies Last reply on 29 May 2010 by
Clara

5130c forgot my mbl memory card password

 Solved

Hello, Im Using 5130c.... I forgot my password.... i Cant able to enter in My Memory Card plz tel hw to solve this problem.... Configurati...

1 reply Last reply on 29 May 2010 by
ash_perez01

Excel: find & offset

 Solved

Hi can someone help me to get a macro code to make following: I have a file in which some cells having data as 10000, > 10000 and some others 10000...

3 replies Last reply on 28 May 2010 by
rizvisa1

Code for copying whole data in auto filter

 Solved

Hello, Configuration: Windows 2003 / Internet Explorer 6.0 i am using excel 2007. i recorded a macro to copy segregate the data from data t...

6 replies Last reply on 28 May 2010 by
Jitu

Autofilter tp leave out #n/a in macro

 Solved

Hello, I have a project id in column C , which iam checking from another source data which is there in a differenr tab .So ihave a vlookup fprmula...

6 replies Last reply on 28 May 2010 by
Lavanya

Formula reads only till 12th on month

 Solved

Hello, If I run the following formulae it gives the result only from 1st to 12 of the month. Is there any thing wrong with the formula or with my Ex...

3 replies Last reply on 26 May 2010 by
rizvisa1

Writing a macro

 Solved

Hello, I am trying to get data whcih has been inoutted into one workksheet to copy into another worksheets when it meets a command in one of the c...

28 replies Last reply on 26 May 2010 by
rizvisa1

Excel, if fuction with cell text values?

 Solved

Hello, I would like to include the text value of a cell in the statement I have for one of the IF options. So far my formula is -: =IF((B1...

2 replies Last reply on 26 May 2010 by
jen

Deleting cells based on cell value of samerow

 Solved

Hello, When I delete cell D4 (it's contents turn to ""), I would like cells C4, E4, F4, G4 to be deleted as well. The row must still exist, so on...

8 replies Last reply on 25 May 2010 by
trowa

If

 Solved

Hello, If A1 = 80 then B1 = 100 or if A1 = 50 then B1 = 90 both these formules are in the same cell, Thanks Configuration: Windows XP / Interne...

2 replies Last reply on 25 May 2010 by
Stormdronk

List 2 columns into one

 Solved

Hello, I hoping that someone can help me fix this. I have two columns with possible duplicate vendor name, example VendorName ...

1 reply Last reply on 24 May 2010 by
venkat1926

Highlighting dates conditional formating

 Solved

Hello, How to highlight dates in "EXCEL" i mean Less than Today = RED Today = YELLOW Greater than Today = Green Please help me i've been...

4 replies Last reply on 24 May 2010 by
rizvisa1

I need a formula for excel

 Solved

Hello, Here is what I need and cant find anywhere: IF A12="text1 (anywhere in text)",then b2="text2" please help provide a formula that ca...

1 reply Last reply on 23 May 2010 by
rizvisa1

Excel formula file linked

 Solved

http://wikisend.com/download/466894/Check1.xlsx Their is a description on the file about what i am trying to do. besicly check one value to a list,...

3 replies Last reply on 22 May 2010 by
rizvisa1

Macro to compare and delete rows

 Solved

Hello, I'm a new b when it comes to macros. I'm looking for the best way to compare data in 2 sheets. If data in column A matches on both sheets...

2 replies Last reply on 21 May 2010 by
Clare

Calendar control 10.

 Solved

https://authentification.site/files/22400897/Book1.xls Please view the attached link to see what i would like done. Thanks Configuration: Windo...

15 replies Last reply on 21 May 2010 by
Jake

Problem formatting date

 Solved

Hello, I'm trying to use "date" to format cells in Excel 2003. I've selected number>date>mm/dd/yy. So, for example I enter today's date as 05201...

6 replies Last reply on 20 May 2010 by
dp

Contract dates due to expire within 3 months

 Solved

Hello, In Excel 2003, I have a list of all contracts with expiry dates. I need to add a colum entitled Due to run out in next 3 months. How do I ...

9 replies Last reply on 20 May 2010 by
rizvisa1

Macro to send email from vlookup cell value

 Solved

Hello, I am trying to create a macro that will among other things send an email to each address in a cell. The only problem is that the cell with ...

5 replies Last reply on 19 May 2010 by
rizvisa1

Adding of the int values based on condition

 Solved

Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in column D. I...

4 replies Last reply on 19 May 2010 by
Sumit

Addition of the int values based on condition

 Solved

Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in column ...

1 reply Last reply on 19 May 2010 by
rizvisa1

Add up the values of duplicate cells

 Solved

Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in ...

2 replies Last reply on 19 May 2010 by
rizvisa1

Column match

 Solved

Hello, I have two columns in excel 2007. Both columns show menu items from another computer system. So, as an example different roles in our com...

9 replies Last reply on 18 May 2010 by
Ross

Getting values from other xls file

 Solved

Hello, I have 2 xls files (book1.xls and book2.xls). In book1.xls the first column (A1) has certain names in first 10 rows (say x1, x2, x3, x4, .....

1 reply Last reply on 18 May 2010 by
venkat1926

Micro sd memory card password is forget

 Solved/Closed

Hello, i use NOKIA 3110c mobile. MY micro SD memory card password is forget. how can it find give me any solution. my id is : ...

Last reply on 18 May 2010 by
madhu

Micro sd 1gb password forget

 Solved

Hello, . now i am using nokia 6085 mobile .. i forget my possword in micro sd 1 GB memory card.. plz tell me the solution what are the steps to fo...

1 reply Last reply on 18 May 2010 by
ash_perez01

Excel - macro copy date for "n" month

 Solved

Hello, Would you please help me to create a macro for generate Date schedule to Sheet2 It just like an installment schedule. Sheet1 Col ...

3 replies Last reply on 18 May 2010 by
rizvisa1

Lookup last name in a range

 Solved

Hello, = LOOKUP(1E+30,Sheet3!E118:E141) I jused this formula to look up the last date of a range, but now want to change it to names but it won...

10 replies Last reply on 17 May 2010 by
rizvisa1

Counting values in multiple combobox's

 Solved

Hello, I'm looking for some assistance with excel VBA, it would be great to gain your assistance. I've created a UserForm with 4 x ComboBox's, ...

1 reply Last reply on 17 May 2010 by
rizvisa1

What funtion/s should do i need

 Solved

I'm working on tool for a user to input a qty of items, then calulate the number of cartons required. The cartons come in 1, 5 & 20 unit packs. ...

2 replies Last reply on 17 May 2010 by
BJ

Multipul equations resulting in 1 answer?

 Solved

Hi all, Recently I asked the question below: https://ccm.net/forum/affich-348337-value-error-when-sourcing-data-from That solved the pr...

3 replies Last reply on 17 May 2010 by
rizvisa1

If cell a1 have data in copy date in b2

 Solved

Hello, please can you help on how the following works in excel. In excel 2007: If cell a1 are 1,2 or 3 then the current date displays in b2, or if da...

2 replies Last reply on 16 May 2010 by
StormDronk

#value error when sourcing data from...

 Solved

....Negative conditional formatted cell In MS Excel. Hi guys, I haven't been very busy at work lately and the boss has told me do try and do 's...

3 replies Last reply on 14 May 2010 by
Klis

Excel - copy rows "n" times with calculation

 Solved

I need to have a macro that will copy rows from sheet1 to sheet 2 . The catch is from sheet 1 col C for e.g. C2 may have the number 5 in it. I need to...

3 replies Last reply on 14 May 2010 by
rizvisa1

Excel

 Solved

hi i always make our employee salary in excel. this file is very big. every month I have to put only OVER TIME,WORKING DAY and ABSENT...and i make all...

5 replies Last reply on 13 May 2010 by
rizvisa1

Can a macro add a number?

 Solved

I am working on a excel project where I will be able to click a button and the result would be a number added on another cell. For example, counting a...

7 replies Last reply on 13 May 2010 by
rizvisa1

Copy columns one below another

 Solved

Configuration: Windows XP / Internet Explorer 7.0 hi i have data in the following form a b c d 1 6 11 16 2 7 12 17 3 8 13 18 4 9 14 19 5 10 1...

7 replies Last reply on 13 May 2010 by
rizvisa1

Combining 2 cells to 1

 Solved

Hi, I have data like below in two column of excel sheet: 1-Jan | 2004 23-Jul| 2004 12-Feb|2003 ................ ......... Out out require...

2 replies Last reply on 13 May 2010 by
Shashi

Help excel: click & automatically copy paste

 Solved

I need some help Let's say I have 5 different tabs named London, Paris,... Each tab contains different kind of information about the cities: popula...

1 reply Last reply on 12 May 2010 by
rizvisa1

Search and replace macro for microsoft excel

 Solved

I have two workbooks with identical setup. item name address 1 address 2 address 3 x 12 34...

3 replies Last reply on 11 May 2010 by
rizvisa1

Click a cell and insert a wingding

 Solved

In excel I am wanting to be able to click a cell to insert a Selected wingding from a list. But to also beable to click the cell a second time to cha...

1 reply Last reply on 11 May 2010 by
rizvisa1

Add cells with other identical attributes

 Solved

I'm looking to create a formula which can be copied into other cells that will add numbers in one column, where their attributes in another column are...

2 replies Last reply on 11 May 2010 by
armatt
Results 2201 - 2250 out of a total of 2,608