The discussions

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

Excell delete row where column a = column b

Hello, This should be simple but I can't find the solution. I need to delete rows from a spreadsheet where column A = column B. Please help. ...

3 replies Last reply on 24 Feb 2012 by
aquarelle

Password problem

 Closed

Hello, I have a problem with my hotmail password. When I put it in on most computers and my laptop and press enter or login/sign in, it backspaces or ...

Last reply on 24 Feb 2012 by
pcsces

New workbook

Hello, I would like to know if it is possible (and if it is, how) to do the following: Data is entered into a excel workbook like a database. A...

1 reply Last reply on 23 Feb 2012 by
TrowaD

Excel formula

Hello, I am working on log spreadsheet. The concept is to keep a log of all of our near miss activities at work like a broken chair that needs to ...

1 reply Last reply on 23 Feb 2012 by
TrowaD

Excel help

Hello, I'm trying to set a formula in below way, but it doesn't work, why?ould u plzz help? =IF(J10="Safari 4.5",650,IF(J10="Safari 7",850,IF...

4 replies Last reply on 23 Feb 2012 by
TrowaD

Formula needed

Hello, Hi - needing some help with a formula - I have several columns taken from sage data. I have in one column employees hours and another employ...

5 replies Last reply on 23 Feb 2012 by
TrowaD

Formula challenge for the excel wizzards. please help

Hello, This might be a long explanation, but only because I want to be clear about the problem. I have 3 different Workbooks and the names are ...

1 reply Last reply on 23 Feb 2012 by
RWomanizer

Excel 2010 formula/macro help

Hello, I'm hoping some of you excel wiz's can help me, I've been off the tools too long. Worksheet 1 Column A contains dates Column B contain...

1 reply Last reply on 23 Feb 2012 by
RWomanizer

Excel logic

Hello, I am trying to create a worksheet in excel that will allow me to add a certain amount if 2 conditions are met. So far I can only get it to a...

1 reply Last reply on 23 Feb 2012 by
RWomanizer

Date format

Hello, please advise me in Changing the date format eg. from 10-02-2012 to 10th February, 2012 Configuration: Windows XP / Internet Explorer...

1 reply Last reply on 23 Feb 2012 by
RWomanizer

Insert row in excel by criteria

 Closed

Hello, Configuration: Windows XP / Firefox 10.0.2 I want to insert row in excel using formula because i have dates in the and there is da...

Last reply on 22 Feb 2012 by
pcsces

Copying value to another worksheet

 Closed

Hello, I am trying to copy a value for from one worksheet, do some math --> say I have three values that I want to subtract separately from cell i...

Last reply on 22 Feb 2012 by
pcsces

Pdf reader for samsung gt-b3410

Hello, I use samsung gt-b3410 . I want to download pdf reader for my phone.. from where shall I get??.. pls help me with this... Configuration...

1 reply Last reply on 22 Feb 2012 by
Ambucias

Excel conditional formatting row color

 Closed

Hello, Column A indicates what type of transaction I've made (ie POS/ATM/CASH/Bill Pay) Column D is the date the transaction has cleared my bank. ...

Last reply on 21 Feb 2012 by
pcsces

Excel macro - create new files from ranges

Hi. I am trying to create a macro that will create new excel files for ranges of rows in a worksheet. I want to copy the range F5:S61 and paste i...

3 replies Last reply on 20 Feb 2012 by
Jiminie.Glick

Enter sheet update other worksheet with text

Hello, Can anyone help me with this problem. I am updating leave availability , As soon as I enter the name in one worksheet the other workshee...

3 replies Last reply on 20 Feb 2012 by
TrowaD

Instant auto filter

Hello, I am using Excel 2010, and I would like to write some codes that does the following: I have a data sheet of many entries, in rows 9~6000+ ...

3 replies Last reply on 20 Feb 2012 by
TrowaD

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

Forget the password

Hello, sir i am using sony ericsson w890i. and i need to format my memory card but i forgot the password. plz sir tell me what should i do ? and sir...

1 reply Last reply on 19 Feb 2012 by
Ambucias

Computer just keep asking for password

Hello, Hi, I am having trouble with my hoshiba labtop. It keeps asking for my password. and behind it is a black screen. It will not allow me to do ...

2 replies Last reply on 19 Feb 2012 by
heklaire

Read first two characters

Hello, I am new at VB and cannot complete a macro so your help will be appreciated. If I have this data on a worksheet: A ...

1 reply Last reply on 18 Feb 2012 by
venkat1926

Admin. password

Hello, My Daughter cant remember what she changed the owner password to on her laptop. She has windows 7 home pre. Is there anyway to resolve this? ...

1 reply Last reply on 17 Feb 2012 by
kakashi1111

Macro - sort range error

 Closed

Hello, I've created a Macro within Excel that is supposed to Delete, Formulate and Sort data.. I've managed to get the Macro to the point where it...

Last reply on 17 Feb 2012 by
pcsces

Worksheet_change from a data validation list

Hello, I want my pivots to rebuilt when a value in range("Book_Select") is changed. This range is a drop down data valiation list. What is wrong w...

1 reply Last reply on 16 Feb 2012 by
aquarelle

Comparing values of 1 excel cell with column

Hello, Please can you assist me with this excel formula? In sheet 1 I have business rules specified in column A and all the requirements that exe...

1 reply Last reply on 16 Feb 2012 by
TrowaD

When value appears adjacent cell acknowledges

Hello, I am looking for some VBA code that looks at a column in my worksheet called "Database" and when a value appears in this column, I would li...

1 reply Last reply on 16 Feb 2012 by
TrowaD

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

Pull data from one tab/sheet to another

Hello, Configuration: Windows Vista / Internet Explorer 9.0 Reading all of these posts I get a lot of ideas, but since I am a novice at this ...

1 reply Last reply on 15 Feb 2012 by
venkat1926

Hide rows without conditional formatting

 Closed

Hello, I'm creating an Excel spreadsheet and want to give it a cleaner look by hiding the contents of a row based on the value of a cell in that ro...

Last reply on 15 Feb 2012 by
Beverley

Macro help

Hello, I am new to VB and Excel. I've got the following code: I've got everything working fine, but need the entire row to change colors...

1 reply Last reply on 15 Feb 2012 by
venkat1926

Sum a range only if certain text in another

 Closed

Hello, I need a formula to sum the values in a range of cells but only for the cells that have a specific text in a completely different range of ce...

Last reply on 14 Feb 2012 by
RR

Excel search and save problem

Hello, I'm a total Excel noobie so I hope you can help me, I will try and be as brief as posible. Each week I will be getting an Excel CSV of 4...

1 reply Last reply on 14 Feb 2012 by
TrowaD

How to make secondary cells color of primary

Hello, Is there a way to make cells automaticaly change to the color I chose for another? Example: I decide to make cell A1 red. When I do this ...

1 reply Last reply on 14 Feb 2012 by
TrowaD

Filter-cut-paste to other sheet

Hello, Could you please help me on this one, i have a data sheet and i want to filter then cut the data if the criteria is met (Adhoc,Chaser,Excep...

1 reply Last reply on 14 Feb 2012 by
TrowaD

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

Import from list to table

Hello, I have a list of user ID's, Users & roles allowed on an application. I now need to make a table with users & user names and a place an x u...

1 reply Last reply on 12 Feb 2012 by
venkat1926

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

Macros and histograms

Hello, I want to create a histogram on sheet2 while the data required is on sheet1 using a macro. everytime I try, it either says no data availabl...

1 reply Last reply on 9 Feb 2012 by
TrowaD

Conditional formating on more than one cell

Hello, I have 50 columns. Each column represents a different department. Row 2 shows numerical targets for each department. Row 3 shows curren...

1 reply Last reply on 9 Feb 2012 by
TrowaD

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

Absolute column but reference current row

Hello, Here is my formula i need it to auto fill for a column which stays that same but changes depending which row. Column T is time spent C...

3 replies Last reply on 9 Feb 2012 by
TrowaD

Transfer value between cells

 Closed

Hello, i am maintaining attendance on daily basis per day per sheet. but sheet 1 contains only number of present on that day. how to auto up...

Last reply on 9 Feb 2012 by
pcsces

Excel question

 Closed

Hello, I am trying to find out how to get the following working, I have a list of numbers located in cells D-AN, these random numbers are loaded we...

Last reply on 8 Feb 2012 by
pcsces

How to calculate all the difference alphabet

 Closed

Hello, Can I calculate all the difference alphabet in 1 column ? Example : in 1 column have A,B,C.... Have any formulue can help me direct c...

Last reply on 8 Feb 2012 by
pcsces

Cut and paste row containing certain keywords

Hello, I am wanting to be able to run a macro that will cut and paste into a new sheet any rows that contain certain keywords Is it possible, ...

2 replies Last reply on 8 Feb 2012 by
stocks100

Excel macro-pasting on next available row

Hello, I am having issues with my macro, I hope someone can help. I have a list, where I would like the macro to see if the value in Column J "Paid...

1 reply Last reply on 7 Feb 2012 by
TrowaD

Read data from one excel and write to other

Hello, I am a newbie. I am trying to find out if we can achieve the below scenario using macros. We have 2 excels in our case. Excel1 contain...

1 reply Last reply on 7 Feb 2012 by
TrowaD

Copy the data from this sheet to other sheet

Hello, I have a problem about macro excel as: I have the data in file excel: Exam: Vendor account Date Invoice Due date Amount c...

1 reply Last reply on 7 Feb 2012 by
msweli
Results 5501 - 5550 out of a total of 12,266