## The discussions

### Copy cell if>0 to another cell

Solved

Hello, I'm trying to find the best way to do the following: A63 cell =if(C12>0,C12&" "&A12," ") A64 cell =if(C13>0,C13&" "&A13," ") etc.... thi...

2 replies Last reply on 19 Oct 2010 by
startbuck

### Macro/vba help.

Solved

Hello, i need help to do solve the following problem: Sheet1 contains a value for today. e.g £1000.00 (Cell A10) Sheet3 contains every date ...

4 replies Last reply on 19 Oct 2010 by

### Colouring a ms excel cell

Solved

Hello, I need some help. How could I fill a cell in MS Excel in red if a condition has been met. For example: If the number in Cell A1 is mo...

3 replies Last reply on 18 Oct 2010 by
venkat1926

### Compare mutliple excel columns

Solved

Hello, I'm working on an excel sheet and comparing multiple columns to determine if a site to be eligible or not eligible for the program, the sit...

2 replies Last reply on 18 Oct 2010 by
Sonja

### Need to write a formula based on color of cel

Solved

Hello, I need help on creating formula in excel 2007. Situatiion is .... Say cell A1 is coloured as Red. I need to put a formula in cell B1, where...

3 replies Last reply on 17 Oct 2010 by
rizvisa1

### Excel summing up values of scattered data

Solved

Hello, I am looking for how to make a cell in excel that tells me how many of a certain item I have. In column b I have values (numerical) of cer...

2 replies Last reply on 16 Oct 2010 by
Brian

Solved

Hello, I am in computer nightmare, I have been doing my best to try and find the solutions, every time I solve one problem another occus. I cant af...

7 replies Last reply on 14 Oct 2010 by
Andre V

### Using vb code to copy formulae

Solved

Hi I am using the following code to insert 'x' number of new rows dependant on value 'y' and it does this just how I want, however, I also want the...

2 replies Last reply on 13 Oct 2010 by
aquarelle

### Ms excel: value from a range

Solved

Hello, HDI get a numerical value (in C2) that is assigned to a word within a range(G2:H8)? Thank you in advance!

2 replies Last reply on 11 Oct 2010 by
GrnSpdr

### Excel how to change a value automatically

Solved

This is my first question on the forum so I would first like to start by saying hello to all members and moderators :) My question today which I'm ho...

6 replies Last reply on 11 Oct 2010 by

### Comparing two excel sheets

Solved

Hello, i have two excel sheets, one sheet has 100 email ids, the other have 200 email ids, the scenario is I want to know the common email ids from...

14 replies Last reply on 10 Oct 2010 by
Mathews

### How i apply password for my memory card

Solved

Hello, how i apply password for my memory card i am using nnasaki mobile made by china

4 replies Last reply on 9 Oct 2010 by
rahul

### Excel custom function

Solved

Hello, i have created a custom excel function which works fine. the only problem being, you need to press F2 on the custom formula cell and give en...

13 replies Last reply on 7 Oct 2010 by
AG

### Music playerz

Solved

Hello, Whats the best Music Player that i can get installed on my computer, please help, thanks. Configuration: Windows 7 / Firefox 3.6.10

2 replies Last reply on 7 Oct 2010 by
realiser

### Pls help - excel - highlight cell if no data

Solved/Closed

Hello, Please could somebody help me with a problem. I have a spreadheet and I would like make some cells in a row go yellow if they have no data in...

Last reply on 5 Oct 2010 by
joe random

### Count rows from sheet2 and place on sheet1

Solved

Hello, Windows XP / Internet Explorer 8.0, Excel 2007 I need help with a formula. On Sheet1, I am trying to get the total # of records for ea...

8 replies Last reply on 5 Oct 2010 by
Sam

### Copy from one workbook and paste in another

Solved

Hello, I need to copy the new record from one workbook and paste it in another workbook. from the first work book this new record is always the ...

12 replies Last reply on 5 Oct 2010 by
Raghuraman

Solved

Hello, sir, I forgt my security password.....is there any method dat i can get password without any paying?? i search whole site nd i got many ...

jack4rall

Solved

Hello, pls heip me Configuration: Windows XP / Internet Explorer 7.0

2 replies Last reply on 4 Oct 2010 by
Ambucias

Solved

Hello, I am working on my pc with winxp sp2..i have forgot my password.i have lot of information on my pc.what can i do for opening my ...

Ambucias

### Browsing the web with a sansung phone

Solved

how to make a phone to browse

closeup22

### Microsoft word

Solved

Hello, Need help! Have Windows Vista on my laptop. Am getting ready to start taking college classes online but, they have advised me that I need t...

5 replies Last reply on 30 Sep 2010 by
Talkman

### Using find within macro

Solved

Hello, I have a list of first and last names of employees (Sheet1). Some of these employees have adjusted work schedules which are listed in a dif...

9 replies Last reply on 29 Sep 2010 by
aquarelle

### Problem to check and compose my mail

Solved

Hello, why from last evening untill now I can not check and compose mail. tks Configuration: Windows Vista / Internet Explorer 8.0

2 replies Last reply on 27 Sep 2010 by
cha_mps

### Product key for microsoft word

Solved

Hello, How do I find out what my product key is? Configuration: Windows 7 / Internet Explorer 8.0

xpcman

### Excel vba help

Solved

Hello, I am needing some help with this vba code. What I am trying to do is first verify if cell A4 is not empty, if it is not empty then I need it t...

2 replies Last reply on 25 Sep 2010 by
Maja WL

### Word aplication

Solved

Hello, How do i have some words highlighted? Thx. Configuration: Windows XP / Firefox 3.6.8

3 replies Last reply on 25 Sep 2010 by
phOshOrOfik

### Ms word files do not open

Solved

Hi! I was using Microsoft word before and it was working correctly. Now I am facing a great trouble for my word files are not opening anymore on t...

2 replies Last reply on 25 Sep 2010 by
phOshOrOfik

### Copy rows from sheet 1 to sheet 2

Solved

I need to have a macro that will copy rows from sheet1 to sheet 2 . The catch is from sheet 1 col A for eg A3 may have the number 10 in it. I need to ...

14 replies Last reply on 24 Sep 2010 by
venkat1926

### Open office fonts

Solved

Hi experts around, I just wanted to know whether all the fonts on open office are compatible to windows word fonts, thanks. Configuration: Wi...

closeup22

### To prepare attendence report with excel sheet

Solved/Closed

Hello, I will describe what I want to do . I have 60 residents working in our department. They attend morning report everyday. So I have prepared ...

Last reply on 23 Sep 2010 by
akshay

### Report value of cell based on search

Solved

Hello, in Excel I can use a Sumifs to search a column for a value and return the total of cells that match that value (how many "calls" did "Sally tak...

2 replies Last reply on 21 Sep 2010 by
Pamela

### Producing a list if a column has a value y

Solved

Hello, I wish to produce a list only when one of the columns has a Y in it. For example; A B 1 Y Bread 2 Milk 3 Y Bu...

2 replies Last reply on 21 Sep 2010 by
Russ

### New font on word

Solved

Hello, I want to install new fonts on MS word application, how do i do that? Thanks. Configuration: Windows Vista / Firefox 3.6.8

closeup22

### If sum>= 60, color cells red

Solved

Hello, I have excel 2007 and am trying to set conditional formatting for a series of 3 cells. If their total sum is greater than or equal to 60 I...

4 replies Last reply on 20 Sep 2010 by
mindy

### Find value between 2 column range excel macro

Solved

Hello, I have a 2 Columns of Data (A) and (B) that provides me with a specific range, and a third column C that provides a corresponding value f...

3 replies Last reply on 19 Sep 2010 by
Jenz

Solved

Hello, I have seen other threads that users are able to generate master passwords for Dell laptops. Mine is out of warranty, and I was hoping I co...

2 replies Last reply on 19 Sep 2010 by
jack4rall

### Date format error

Solved

Hello, In my excel sheet it is showing an error in the date format. Its like this - (-693593.770833333). I tired changing it through format cel...

rizvisa1

### Excel pdf format

Solved

Hello, I have been able to convert word files into PDF files but is it also possible with Excel file. Thanks for any information from your part. ...

2 replies Last reply on 19 Sep 2010 by
closeup22

### Unable to open winrar files

Solved

Hello, Please send me the software for opening winrar files, thanks. Configuration: Windows Vista / Firefox 3.6.8

closeup22

### I forgot my password for yahoo and my sercret

Solved

Hello, can somebody help me i need to figure out my password and my secrect question if somebody helped thanks please help :(

closeup22

Solved

Hello, i have a micro sd card for my phone 6300 and its password protected and i forgot password i cant open it from my phone or from my computer. M...

closeup22

### Need help with multiplying formula in excel

Solved

Hello, Inser formula in cell F4 that multiplies the amount on E4 by the amount in D4. Configuration: Windows Vista / Internet Explorer 8.0

2 replies Last reply on 18 Sep 2010 by
casey

### Recover memory card lost password

Solved

Hello, I HAVE A NOKIA 2700 CLASIC BUT HAVE NOT FOUND SETTING IN MY MOMORY CARD OPTION AS SUGGESTED TO RECOVER MY PASSWORD. AND THE CARD DOES NOT ...

brianwhitt77

Solved

Hello, my pc was locked..because i'm forgot my user name and password..please solve my problem Configuration: Windows Vista / Internet Explorer...

Ambucias

### Recover my deleted excel file

Solved/Closed

Hello, i need or recover my deleted excel file. by mistake i use shift delete.plz help me out. Configuration: Windows XP / Internet Exp...

Last reply on 16 Sep 2010 by
Ambucias

### Excel macro - multiple columns into one

Solved

Hello, I need a macro that combines multiple columns into one, but I'm terrible at creating macros! Essentially what I have is data that is sorted...

4 replies Last reply on 16 Sep 2010 by
Mani

### #n/a help

Solved

2 replies Last reply on 15 Sep 2010 by
PK

Solved

Hello, I forgot my password for micro sd memory card. I dont know how to open it. please kindly give tips to open that memory card. my mobile model i...

2 replies Last reply on 15 Sep 2010 by
Ambucias

### Changing a cell value based on the color of a

Solved

Hello, Is it possible to populate a cell in Excel 2003 with a number value that is based on the color of an adjecent cell? ie A2 = 0 if B1 is tr...

4 replies Last reply on 15 Sep 2010 by
Farzan
Results 1901 - 1950 out of a total of 2,608