The discussions

Looping for a specific time

 Solved

Hello, I'm using Excel 2007 I have the following code: Sub Macro1() With Selection.Interior .Color = 255 End With Appli...

2 replies Last reply on 9 Mar 2010 by
selflearner

What about mail account deleted?

 Solved

Hello, i had sent a email to a friend and after sending the message came that the mail has been sent but he says that he has deleted his account . so...

2 replies Last reply on 7 Mar 2010 by
rachel

Copy/paste values on the specific column

 Solved

Hello, I want to, copy/paste values on the specific column based on cell A2. i.e. if cell A2= 1 then copy/paste values for the January column (range...

1 reply Last reply on 7 Mar 2010 by
rizvisa1

Delete certain cells of active row

 Solved

Hello, I would like a code for the following: Check which row is active/selected and then delete the data which is in the 5th and 7th column of ...

6 replies Last reply on 5 Mar 2010 by
tatosgr

Insert rows based on count of row in another

 Solved

Hello, I have a excel where I create few dummy accounts and the next sheet (sheet2) has details of these accounts. I need the sheet 2 to have certai...

12 replies Last reply on 5 Mar 2010 by
rizvisa1

Last value in a row with diff. 25% on rel val

 Solved

This is tough to even state, but I'll try with an example Example: find the first value that changed 50% in relation to the last time when there wa...

3 replies Last reply on 5 Mar 2010 by
rizvisa1

Colour

 Solved

Hello, Hi and thanks for previous help. Last one for a while (I hope) I am using the below formulae you gave me and it is fine. However these res...

1 reply Last reply on 5 Mar 2010 by
rizvisa1

Excel macro - dynamic column selection

 Solved

Hello, I am just beginning to learn Excel macros. I was working on a sheet wherein I have to select a column dynamically, based on just the column ...

3 replies Last reply on 4 Mar 2010 by
maggie

Text box linked to cell value

 Solved

Hello, I have a text box placed in a chart that links to another sheet/cell for its content. The value is a percentage. I can format the source text ...

3 replies Last reply on 4 Mar 2010 by
mblair

Dates

 Solved

Hello, Crazy question.... I have a row full of different dates. I would like to create a formula to display in a separate cell, the earliest date fr...

5 replies Last reply on 4 Mar 2010 by
rizvisa1

Separate required records from a file, mak

 Solved

Hello, I am using following macro to separate required records from a file contain several worksheets and each worksheet contain thousands of rec...

5 replies Last reply on 4 Mar 2010 by
rizvisa1

Excel conditional formatting row color

 Solved

Hello, I am trying to get Excel to automatically change the color of a row depending on the entry in column H. I've got some VBA code written up, but...

17 replies Last reply on 2 Mar 2010 by
AM14

Match formula with external lookup_array data

 Solved

Hello, I am trying to write a formula using the MATCH function =MATCH("x",r1:r10,0) to find the first instance of x in a column. Howev...

1 reply Last reply on 2 Mar 2010 by
rizvisa1

Copy data one sheet to another

 Solved

Hello, dear friend i have two work sheet.first sheet has a data.using subtotal function I'm daily taking summary of that data.that summarized data da...

2 replies Last reply on 2 Mar 2010 by
kaluputha

Macro to compare two sheet with both sheets h

 Solved

Hello, I have a 2 excel sheet which has all the column having same. This has D$C Comment, OMS comments, Planned Resoluiton date & Sub account in bo...

1 reply Last reply on 2 Mar 2010 by
venkat1926

Lookup,count and pie chart excel2007

 Solved

Hello, Can anyone give advice? I got a form on sheet1 thats got a savebutton to save the input data of the form to the database on sheet2.On sheet2 ...

4 replies Last reply on 1 Mar 2010 by
Gouws

Scores

 Solved

Hello, Hi I will sonn get a sheet of student exam outputs listing there choice of answer from a to p for each question. I have a space st the top of...

6 replies Last reply on 1 Mar 2010 by
rizvisa1

How to match value with table

 Solved

Hello, I have a problem to match the value from sheet 2 with another sheet name table. I want to compare if the value near with the value in the tab...

3 replies Last reply on 1 Mar 2010 by
venkat1926

Countif based on two criteria

 Solved

Hello, I'm tinkering with a spreadsheet I use for my business and would like to create a count of the number of products dispatched on a date. I ha...

4 replies Last reply on 28 Feb 2010 by
ShootingFish

Changing color of a cell in a table...

 Solved

Hello, I'm afraid that this post rather fits into the "free help" section of things here, I am a person with a basic knowledge of coding and i...

10 replies Last reply on 28 Feb 2010 by
ShootingFish

How to fill selected cells with given data?

 Solved

Hello, I often need to fill cells with a date of production. What kind of a macro would be usefull in this situation so that I could just select the...

13 replies Last reply on 27 Feb 2010 by
hockey50

Selectively transfer data topre defined range

 Solved

Hello, I am new to Excel VB. I'd like to compare a set of data from worksheet1 by meeting a set of multiple conditions/criterias and then transfer ...

3 replies Last reply on 26 Feb 2010 by
venkat1926

Find a string in excel and remove all cells

 Solved

Hello, I need to find a string (for example: abc) in a large worksheet then remove all cells containing this string. I have tried different functions...

3 replies Last reply on 25 Feb 2010 by
Ex-Q??

Cut-paste row to sheet2 if columnvalue is met

 Solved

Hello, I have got 2 sheets. Sheet1 contains a list of assignments, in which column B contains the status of those assignments. Sheet2 contains comp...

3 replies Last reply on 25 Feb 2010 by
rizvisa1

Converting a number in words into a number

 Solved

Hello, i want to convert wrods into a number.Let me say more clearly... if i take " one thousand five hundred six " it should be converted into ...

9 replies Last reply on 25 Feb 2010 by
rizvisa1

Column comparison

 Solved

Hello, i have two columns to confirm the name , I want 2 identitfy; do the first column name is same person in the weccond column for example...

2 replies Last reply on 24 Feb 2010 by
venkat1926

Excel help

 Solved

Hello, I am having trouble with an excel calculation, i'd be grateful for any help: I have menu items listed along the top, with a space for th...

11 replies Last reply on 24 Feb 2010 by
donkeyoaty

Getting perfomance of each vendor using excel

 Solved

Hello, What I want is to get an evaluation of every supplier. Let say I have 20 list of supplier and list of product I'd ordered, including quantity...

5 replies Last reply on 24 Feb 2010 by
zmarlz04

Find a text in a sentence inside a cell

 Solved

Hello, I have a column which has addresses of different Companies, eg. SHRUTIVEER,23/2/1/1 BHAGBAN CHATTERJEE LANE,HOWRAH 711101 2nd Floor, Eas...

5 replies Last reply on 24 Feb 2010 by
rizvisa1

Adminstrater password problems

 Solved

Hello, my 10 year old daughter changed her password on laptop on the admin user she cant remember her password .

1 reply Last reply on 23 Feb 2010 by
xpcman

Copy a "comment text" in to "cell t

 Solved

Hello, my Self Deepak Kumar, I can't find the fomula how do Copy a "Comment Text" in to "Cell Text" in another sheet. Regards Deepak Kuma...

2 replies Last reply on 23 Feb 2010 by
aquarelle

Date format today

 Solved

Hello, I have an invoice with a date format "TODAY". If I create an invoice today, it assigns today's date. If I open the invoice tomorrow, it as...

4 replies Last reply on 23 Feb 2010 by
rizvisa1

Excel forumla help (if formula)

 Solved

Hello, I need some help, I just can't figure the IF formula out. On my Excel 2007 spreadsheet, I am trying to figure out if I put the letter grad...

2 replies Last reply on 22 Feb 2010 by
pleasehelp1101

Formatting with more than 3 colors

 Solved

Hello, I need your help guys, i wanted to apply the formatting with more than 3 colors in my worksheet. The worksheet im working on has a lot o...

2 replies Last reply on 21 Feb 2010 by
rubster

Conditional formulat with #ous condiitions

 Solved

Hello, I have to write a formula to account for 6 conditions from 6 different columns. Originally, I thought it could be done by a simple nested I...

4 replies Last reply on 19 Feb 2010 by
Trowa

Law school acceptance chances

 Solved

Hello, I want to compare possible GPA and LSAT scores to Minimum Acceptance GPA and LSAT scores. I've tried using IF and AND functions, but I can't s...

1 reply Last reply on 19 Feb 2010 by
rizvisa1

Counting

 Solved

Hello, I am trying to count the number of cell's from I4:I304 that have "no access" in it, but in those cells not only do some of them have "no acces...

1 reply Last reply on 18 Feb 2010 by
rizvisa1

Excel macro loop to insert pics into more cel

 Solved

Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...

1 reply Last reply on 18 Feb 2010 by
rizvisa1

Excel help combining info from2 sheets

 Solved

Hello, Hello, How can I match and combine records across two excel sheets. I have two excel sheets containing record information, about 6 columns f...

2 replies Last reply on 18 Feb 2010 by
coupen66

Forget password & secret question

 Solved

Hello, i have forget password & secret question .please help me.please reset my passwrd . kamal nautiyaljubl@yahoo.co.in

1 reply Last reply on 17 Feb 2010 by
suff954

Forgot password of memorycard

 Solved

Hello, i forgot my password of my memorycard of nokia 3110c.. pl help me to change password.. thank u

1 reply Last reply on 17 Feb 2010 by
suff954

Excel if function over a range of dates

 Solved

Hello, Can anyone help please? I am trying to add a divisions column, which are taken from a date range in another column. i.e. I would like to add "...

8 replies Last reply on 16 Feb 2010 by
Useful

Insert and order the column

 Solved

Hello, It has A, B, C, D, E Columns and less then 6500 rows as per given example. A and the B column are fixed. I want to reorder compare "C" co...

9 replies Last reply on 16 Feb 2010 by
rizvisa1

Add cells, div by cells with value (excel2007

 Solved

Hello,can any help!(excel 2007) A B C ...

1 reply Last reply on 16 Feb 2010 by
rizvisa1

Excel formula to show zero

 Solved

Hello, I'm using the formula =A2/(A2+A3) in A4, same in B to AF, i need the A4 line to show a zeros when A2-AF2 and A3-AF3 do not have values in. ...

2 replies Last reply on 15 Feb 2010 by
Gouws

Compairing two columns a&b

 Solved

Hello, column A column B 5000 4001 5001 4080 5002 4445 5003 4493 5004 4...

1 reply Last reply on 15 Feb 2010 by
rizvisa1

Network days

 Solved

Hello, I need some help if any one can assist, please... I have a date in a Excel S/S so i.e. 15/02/2010 and under this i have a number of days ...

4 replies Last reply on 15 Feb 2010 by
jay

Excel formula converting time difference

 Solved

Hello, i want to know the excel formula...below iam giving the details, In table A is my starting time e.g.10.49 and in table B is my reaching time...

1 reply Last reply on 14 Feb 2010 by
venkat1926

Deleting alternae rows

 Solved

Hello, I want to delete every alternate rows from my work sheet. I tried recording macro, but it only deletes a particular row as shown in macro bel...

3 replies Last reply on 14 Feb 2010 by
rizvisa1

Linking spreadsheets

 Solved

Hello, I'm trying to set up a cell that will draw information from another spreadsheet using excel 2007 The spreadsheet I'm pulling the info fro...

1 reply Last reply on 13 Feb 2010 by
rizvisa1
Results 2401 - 2450 out of a total of 2,608