The discussions

Excel - run macro on cell change

 Solved

I am trying to have 1 of 8 different macro's run depending on the value of a specific cell. If I enter 1 in cell A3, I would like macro1 to run. If I...

1 reply Last reply on 20 Apr 2010 by
aquarelle

Vba code for excel ..........................

 Solved

Dear Expert, Below written VBA code is being used by me to insert jpg picture in the excel file against the code number and its working very well a...

2 replies Last reply on 20 Apr 2010 by
Santosh

Please help me!!!! if formula [solved]

 Solved

Correct -- Asked -- For Upload 0 -- 0 -- ...

6 replies Last reply on 20 Apr 2010 by
DCecil07

Validate

 Solved

Configuration: Windows XP / Firefox 3.5.9 Hey frnds I almost have a same problem: I need to validate columns for alphanumeric and email forma...

1 reply Last reply on 20 Apr 2010 by
rizvisa1

Helo data extrating

 Solved

Hello. I have a File which contains 3 colums Mobile No , Name And Address in Sheet one. Each file contains approx 500000 data. in sheet 2 i h...

3 replies Last reply on 20 Apr 2010 by
Sailesh

Macro to delete blank rows?

 Solved

I have a spreadsheet where I would like to 'record new macro' to delete all rows that are blank. If I filter on blank rows and delete....the macro wi...

4 replies Last reply on 19 Apr 2010 by
ap

Why won't this work?: update graph's year vba

 Solved

Hi, My graph has a timeline of one year. After that year the timeline needs to be updated. To get the current year I have used the functions TODAY...

4 replies Last reply on 19 Apr 2010 by
Trowa

Conditional formatting problem

 Solved

Ok I hope someone can help, I have a spreadsheet set up so that it flags up to me if two certain codes match by turning the cell yellow. I also have i...

43 replies Last reply on 19 Apr 2010 by
King_Of_Hearts13

Moving specific data into separate worksheets

 Solved

Hello, I have a list in a column as follows: DAY TYPE PHASE 1 ...

7 replies Last reply on 19 Apr 2010 by
Steve

Bios password

 Solved

i have dell inspiron i forget bios bassword i cant open it its end of 59b Configuration: Windows XP / Internet Explorer 8.0

1 reply Last reply on 18 Apr 2010 by
dave

Hyperlink macro

 Solved

Hi Have a customer profile sheet that has a new customer number each time it is opened. Details are filled in for the customer then a post button is...

2 replies Last reply on 18 Apr 2010 by
SLKG

Macro to copy and paste values

 Solved

Hi I am a complete novice when it comes to macros. What I am looking for is a macro that when run looks in Cell Q7 on Sheet 1 to see what number is...

8 replies Last reply on 17 Apr 2010 by
rizvisa1

Please help macro or formula excel

 Solved

I've 4 columns and 10000 rows like this : Month Plant Area Budget Jan ........ A1 ........01 ........ 1000 Jan ........ ...

2 replies Last reply on 16 Apr 2010 by
talkwutty

Multiple tabs set row count based on sheet 1

 Solved

Hi Sheet 1 contains > 1000 rows of populated data. I need to create x number of tabs each containg the next 25 rows from the sheet1 data. ie 1000...

6 replies Last reply on 16 Apr 2010 by
rizvisa1

Extract specific data and convert to a date

 Solved

Hello, I have a column full of cells that all have the same string with a few different numbers. Here is an example from cell K319: 53T044 11/...

2 replies Last reply on 16 Apr 2010 by
jk

Copy text from cell below based on condition

 Solved

Hi, I'm looking for a macro that will copy the text from the cell below to replace the cell above where the cell above meets a certain criteria. ...

2 replies Last reply on 15 Apr 2010 by
Paul

Vba inserting row and keep range membership

 Solved

In VBA, how do I copy/insert (in place) a row and ensure that if the source row intersected a column range, that the new row would also be in the rang...

3 replies Last reply on 15 Apr 2010 by
venkat1926

Count number of trips when duplicate entries

 Solved

I have list of all the prescriptions we got for the year. A new row is created for each medication. Col A shows the date, Col B shows Pharmacy Name...

4 replies Last reply on 14 Apr 2010 by
venkat1926

Sum searched criteria

 Solved

This code works great at searching based on the userform criteria and then in the message it states the count of the rows pasted into the spreadsheet....

2 replies Last reply on 14 Apr 2010 by
Jan

I need to get a sum from multiple 'if' cells

 Solved

I have a spreadsheet with the following formula: =IF(ISNUMBER(E5), "20.00","") If data is entered in cell E5, the cell below it will have 20.00....

1 reply Last reply on 13 Apr 2010 by
Hmmm....

One week color

 Solved

Hi, Is there any formula to make my one week date in to color red then next week in to color blue? I just want 2 colors interval each ever week of the...

2 replies Last reply on 12 Apr 2010 by
Camarlengo

Match with conditional format in excel 2003

 Solved

Hello Internet, I am in a bind here as I have exhausted my excel knowledge on this problem. I am looking for a way to highlight (in red) a cell wh...

11 replies Last reply on 12 Apr 2010 by
rizvisa1

Excel 2007: reading data from sheet to sheet

 Solved

I am trying to read data from sheet "a" cell to cell on sheet "b". I entered function "=sum('sheeta'!f20) in destination cell, but all I am getting ...

1 reply Last reply on 12 Apr 2010 by
rizvisa1

Images don't print when printing selected pag

 Solved

Hello, I am using Word 2008 for mac. Some images don't print when I print selected pages, although these same images appear when I print the entire...

3 replies Last reply on 11 Apr 2010 by
Yvette

Excel vlookup macro

 Solved

Hello, I am working on a project to create a simple VLOOKUP. I have created the macro and it works well, but now I am looking for some advise on ...

8 replies Last reply on 9 Apr 2010 by
froggy6703

How to romove 512 mb micro sd card password

 Solved

Hi i m using nokia 6300 mobile & 512mb micro sd memary card & this memary card is locked i forgot the password plz tell me how to unlock memary card p...

1 reply Last reply on 9 Apr 2010 by
suff954

Interesting question for excel champions

 Solved

Hello, Interesting Question Guys: Suppose Sheet 1 Is "Data" Sheet And There Are Too Many Rows... Like A3 Is S.No B3 Is Supplier Name C3 I...

25 replies Last reply on 9 Apr 2010 by
rizvisa1

Vlookup column number searching.

 Solved

Dear All, I'm currently using a VLOOKUP to populate an information table im creating however im still adding columns to the sheet which holds the i...

4 replies Last reply on 9 Apr 2010 by
bob2011

Coping rank for whole dataset in excel

 Solved

Hi i want to work out the ranks for my whole data set, if i type in the formula for the first line then drag it for the rest instead of working out ...

2 replies Last reply on 9 Apr 2010 by
hols

Automation of running excel macros

 Solved

Hello, I have a macro in excel which needs to be run once a day and i dont even want to open the excel sheet. How can i make this process automatic...

3 replies Last reply on 8 Apr 2010 by
rizvisa1

Formula help

 Solved

I'm trying to create a formula to look at the values in a complete row and if 3 of those values in a row are pass then it will fill in the cell with Y...

9 replies Last reply on 8 Apr 2010 by
Shaun

Growing list of chart data

 Solved

Hello, Column K contains dates, column L contains amounts. I want to create a chart out of this data. The issue is that the list of data is growin...

14 replies Last reply on 8 Apr 2010 by
rizvisa1

Creating if statement to filter and add.

 Solved

HI, i am trying to create an IF statement to filter a row and then add the numbers in another row on those filters. so for example AA ...

4 replies Last reply on 8 Apr 2010 by
saqib786

How to align all common list in excel?

 Solved

i have 4 columns. the first two (A & B) columns are list of cheques i issued. then the other two (C & D) columns are list of cheques encashed from Ban...

3 replies Last reply on 8 Apr 2010 by
rizvisa1

Copy filtered data and paste values

 Solved

Hi, I found this code in this forum. It selects data based on the filtered rows of data and then it pastes it in another sheet based under the name o...

2 replies Last reply on 7 Apr 2010 by
jan

Coping cells with a loop

 Solved

Hello, I am stumped on what should be a very simple macro. I am running a macro that is using a look-up table to compare the values in column G. ...

1 reply Last reply on 7 Apr 2010 by
venkat1926

Changing a value using a look-up table

 Solved

Hello, I am looking for help on writing a macro that will perform a VLOOKUP formula that will compare the value in G2 on Sheet1, to the value in A...

1 reply Last reply on 6 Apr 2010 by
rizvisa1

Copying % formula

 Solved

Hi, I regularly calculate a series of number as a percentage of a sum that remains constant (expense item as a percentage of total expenses, for eg.) ...

2 replies Last reply on 6 Apr 2010 by
revenue

Help on excel formula

 Solved

I need to create a formula to give me with value and not TRUE/FALSE information. I did use the IF function, but it results in TRUE/FALSE and I need a...

1 reply Last reply on 6 Apr 2010 by
venkat1926

Comparing column values

 Solved

I am trying to compare two columns to see if they carry the same values - column A has 556 values (starling at line 3), and column B has 69 values (st...

2 replies Last reply on 5 Apr 2010 by
rizvisa1

2+2=5

 Solved

can u prove it with littel mistake in mathematics.

1 reply Last reply on 5 Apr 2010 by
le hollandais volant

Identify two or more are same or not in excel

 Solved

Hi Everyone, I have an excel formula question that someone might can help me with. A B 1

1 reply Last reply on 2 Apr 2010 by
venkat1926

Count 2 values in one column and 1 val in oth

 Solved

Hello, I have two column lists (two values in first column and one value in the other) e.g. Column A has the following values: A B C B B A C ...

1 reply Last reply on 1 Apr 2010 by
venkat1926

Moving data

 Solved

Is there any one who can kindly come to my rescue!! I have been presented with date in the form: A B C D E F G H I J ? My aim is to pre...

4 replies Last reply on 1 Apr 2010 by
venkat1926

Match a string to a col & increment by 1

 Solved

I have two sheets with data as follows: Sheet 1 String, result A0101 Format of string in Sheet 1 column A: Axxxx (A - alphabet a to z, x num...

1 reply Last reply on 30 Mar 2010 by
venkat1926

How to convert a numberic valu in to english

 Solved

how to convert a numberic valu in to english

1 reply Last reply on 30 Mar 2010 by
ash_perez01

Merge rows of similar data

 Solved

Hi, I am trying to merge various rows of data with a common headin in Column A. For example I have the following data: A 1 0 0 0 1 B 1 1 0 0 ...

1 reply Last reply on 30 Mar 2010 by
rizvisa1

Excel pro

 Solved

hi , i have some data like gvn below M/C SR NO. total b4 a4 cl4 k92661400 18632 8544 544 9544 K81667500 21844 18948 1948 948 H25102020 6756 8...

6 replies Last reply on 30 Mar 2010 by
rizvisa1

Filter duplicate entry with condition w excel

 Solved

Hi, I've 2 columns of data. Column A are repeated Test sequence and Column B are Status (OK / Fail). I would like to extract those test sequence wi...

2 replies Last reply on 30 Mar 2010 by
rogersee

Someone has stolen my password

 Solved

hi, someone has stolen my email password.. and iam not able to get it back. how should i get it back?

1 reply Last reply on 29 Mar 2010 by
Ambucias
Results 2301 - 2350 out of a total of 2,606