The discussions

Excel 2007 vba find last

 Solved

I have a mutipage workbook where I am coping information from three sheets and consolidating the information to another sheet so I can export into a c...

1 reply Last reply on 10 May 2010 by
rizvisa1

Macro to find a info in more than one column

 Solved

Hi, I need a help to match values in a column from other two columns. I have two columns with some values on them. I have another column [t...

13 replies Last reply on 10 May 2010 by
rizvisa1

Zeor to the end of 4 digit number

 Solved

Hello, Can someone tell me a formula or macro that will add a 0 Zero to the end of a 4 digit number in each cell. I get a excell file with the 4 di...

2 replies Last reply on 9 May 2010 by
billkirby

Excel frame a do while loop or macro

 Solved

Hi All, Could anyone help me to frame a Do While Loop or a suitable macro? I need a method to copy formulas present in Cells F10 to Q10 in She...

13 replies Last reply on 9 May 2010 by
madambath

Date formate

 Solved

Configuration: Windows XP / Internet Explorer 8.0 hi i have date formate in dd\mm\yyyy & dd-mm-yyyy. i need all the dates in same formate exp. ...

3 replies Last reply on 8 May 2010 by
rizvisa1

Formula for dropdown list

 Solved

Configuration: Windows XP / Safari 532.5 n excel i want to use a drop lown list and when enter specified text, then next cell should display my spe...

1 reply Last reply on 8 May 2010 by
rizvisa1

Problem in date format

 Solved

Hi EVERY one I have very Big Problem i am making one report where two type of date format is appearing like MM-DD-YY 03-08-2010 and DD--...

1 reply Last reply on 8 May 2010 by
rizvisa1

I want the installation cd key of cod 5

 Solved

i have the cd and i have lost the cd-cover and also lost the installation code,please help me.

1 reply Last reply on 8 May 2010 by
dist.urbd

Insert rows with data when criteria is met

 Solved

Hi, Thanks in advance for your help. I have two tables. If a field in table A is chosen, I want a macro which will insert rows of the data listed ...

1 reply Last reply on 8 May 2010 by
venkat1926

Input a range of cells

 Solved

If i want to highlight a row of cells in red to show a lead is dead say A1 to E1, buy inputting "lose" in E1 I now have the formula =$A$1="lose" whi...

9 replies Last reply on 7 May 2010 by
andy

Copy data next to a cell and paste it below

 Solved

Hi, everyone I am a newbie in here, and I hope some one can help me solve this: I having a data such as the following cell | A ...

5 replies Last reply on 7 May 2010 by
kent5244

Macro assistance

 Solved

I have a spreadsheet that has data ranging from C3:C263. Workbook is 'GSU CAS Transactional Upload', Sheet is called 'Alliance Upload' I need to...

4 replies Last reply on 7 May 2010 by
DCecil07

Convert a date figure into word in excel

 Solved/Closed

I want to know the formula, how can I convert a date figure into word in excel 2003

1 reply Last reply on 7 May 2010 by
rizvisa1

Excel macro to repeat and insert rows

 Solved

I am trying to write a macro that will insert rows as follows: Col 1 Col2 Col3 1 S 456 2 A 222 3 M ...

1 reply Last reply on 6 May 2010 by
rizvisa1

Link question

 Solved

Using Excel 2003 - I have two tabs one has detail info for unit cost; the second has summery info for each unit. What I'd like to do is if you are on ...

4 replies Last reply on 6 May 2010 by
rizvisa1

Macro for array vlookup to worksheet

 Solved

Looking for help with a quick macro please. I have four tabs in the workbook: Datadump - contains daily raw data to clean Central - Accou...

14 replies Last reply on 6 May 2010 by
rizvisa1

Need help with excel message pop up

 Solved

I need Excel VB help to show a message pop up box to display whenever the value is below 10 or greater then 50 that's also not a multiple of 5 Con...

6 replies Last reply on 6 May 2010 by
Trowa

Updating data in two+ worksheets

 Solved

I have a question, I just created a spreadsheet with 8 tables which contain a deferent data and with Autosum column on each table and I created als...

1 reply Last reply on 6 May 2010 by
rizvisa1

Conditional formatting with 3 cell

 Solved

Hi all I want to do conditional formatting a cell but based on the criteria set by 2 other sells in the row so if A1 = 0 and B1 > 0 i want C1...

5 replies Last reply on 6 May 2010 by
rizvisa1

Link data

 Solved

Dear Excel Expert, I need help. I need to manage my data with diffrent User different sheet & the data need to update every week in master sheet...

14 replies Last reply on 5 May 2010 by
YeohSeow

Range change colour

 Solved

Please help. If I have a range of Data in cells say A1 to E1 and I wish to change all to red when I enter the word "lose" in A1 only what do I need...

2 replies Last reply on 5 May 2010 by
Andy

Extract date from a series of numbers

 Solved

Hi, I need to extract date from a series of numbers like 250420102356478 where 25(date)04(month)2010(year)2056478(sequence number) and answer sh...

4 replies Last reply on 5 May 2010 by
rizvisa1

Pls help me with excel formula!

 Solved

Dear excel experts, I have a dataset of A1:A15. I want to make a formula stating that if 10 cells of the range A1:A15 are greater than or equal 2 ...

2 replies Last reply on 5 May 2010 by
xcel

Finding the last row dynamically

 Solved

Hi, I am using VBA in Excel 2007. I have a worksheet which has multiple columns. Each column has different number of rows. I want to find the la...

2 replies Last reply on 4 May 2010 by
J

Date formatting problem

 Solved

I have a date in a cell that is 23/10/2008, and shows up as this in the editing bar, but in the cell address it shows a figure, ie 39744. Why is this ...

2 replies Last reply on 3 May 2010 by
Kiwi

Vlookup formula

 Solved

Hi, Could you please anyone help me in this? (column headings : Roll No. , correction date , Type , code , rank , Marks , exam date , time ,...

11 replies Last reply on 3 May 2010 by
rizvisa1

Highlight a cell greater than the one above

 Solved

Hello, I am trying to use conditional formatting to highlight cells in a column (formatted as a table) that are greater than the number in the cell...

2 replies Last reply on 3 May 2010 by
Ryan

Xcel formula needed to return multiplication

 Solved

I need a formula that does the following: if b10 is => than 10.03 AND c10 is => than 6.69, then multiply b10 times 328 It seems simple, but I ...

1 reply Last reply on 3 May 2010 by
Trowa

Incentive calculation with few condition

 Solved

Hi, I need help... each month I need to calculate the incentive. manual calculation is wasting my time. i know excel can do it, but I am not ...

10 replies Last reply on 3 May 2010 by
YeohSeow

Product key

 Solved/Closed

Hello, I've trying to enter the product key so many times as behind my laptop. my lap is very new. i can't work with any software without this produc...

3 replies Last reply on 2 May 2010 by
tracy4trading

Sorting and deleting redundant value

 Solved

Hi, I have been trying to sort our patient data in our daily work-up in the lab as below: "sample external no" "barcode" "assay" 4 321456 amf ...

4 replies Last reply on 30 Apr 2010 by
rizvisa1

Conditional formatting

 Solved

can any one help me i have following situation and i drag the formula down , i do not want to show the result in c2 because there are no data in it(b...

2 replies Last reply on 30 Apr 2010 by
sandy

Excel formula!

 Solved

I would like to make an excel formula that if at least 7 out of 10 cell (i.e A1 to A10) are greater than 5, then return as " accepted", otherwise "...

2 replies Last reply on 29 Apr 2010 by
xcel

Selecting the required cells info from the co

 Solved

Hi, I have a data like below in one column in excel: SL#00000 Product: ABC Region Name: Name1 City :1 Country:1 User con: Id type SL#88888...

2 replies Last reply on 29 Apr 2010 by
Shashi

Conversion of values already present in cells

 Solved

Hi: I need to convert values already present in a range of cells to another currency. The current range changing causing headache. Any suggestions...

1 reply Last reply on 28 Apr 2010 by
rizvisa1

Copy paste - excel

 Solved

Hi I have a spreadsheet with a list of job titles in column A. there are a list of dates in columns G & I. there is information in all the ro...

1 reply Last reply on 28 Apr 2010 by
rizvisa1

Selecting a printer in an excel 2007 userform

 Solved

I am using the following code: Private Sub CommandButton1_Click() Application.Dialogs(xlDialogPrint).Show UserForm1.PrintForm End Sub I can...

3 replies Last reply on 28 Apr 2010 by
rizvisa1

Excel 2007 - change cell color using if

 Solved

I have a cell with a % in it. I would like that cell color to change to red if the percentage is below 60%, and change to yellow if it is between 60% ...

1 reply Last reply on 28 Apr 2010 by
rizvisa1

Lookup data on different worksheets

 Solved

I have 2 spreadsheets with the same town names in column A and different dates in column N. I have a third spreadsheet with the town name and have ...

2 replies Last reply on 28 Apr 2010 by
DCP

Excel find a value <>2#'s &get a value beside

 Solved/Closed

Hi All, I want to enter a number in cell A1 (Sheet 1) and have a formula which gets excel to go to sheet 2 column A finds the two numbers the e...

2 replies Last reply on 28 Apr 2010 by
g

Excel formula for finding percentage of

 Solved/Closed

Hello, I need a simple formaul for finding the percentage of Total number of members: answer in column A392 Total number of members who have prov...

2 replies Last reply on 27 Apr 2010 by
nancy0123

Unlock memory card password

 Solved

hey i forgot my memory card password n cudnt find ny file manager optin in my nikia 7210.pls help!!! Configuration: Windows 7 / Internet Explorer 8.0

1 reply Last reply on 26 Apr 2010 by
closeup22

If statement thats adds

 Solved

Dear All, I would like to create an If statement which returns a 1 if a cell is greater than 0, then look at the next cell and do the same. Then ad...

2 replies Last reply on 26 Apr 2010 by
bob2011

Conditional hide rows in multiple sheets

 Solved

It didn't solved yet. I have one excel file with multiple sheets, and all of them with the same columns and rows . I need to hide specific rows in ...

1 reply Last reply on 25 Apr 2010 by
rizvisa1

How to copy entire row (urgent)

 Solved

Hi people. i am doing on some assignment for school. I have created a userform with a search button embedded on one worksheet, lets call it SE...

9 replies Last reply on 25 Apr 2010 by
Starissm

How to display formula in excel?

 Solved

hi everyone, for example i have A1=H and A2=G, and A3=A1+A2 how do i make A3 show a final result of "H+G",display text instead of calculating the form...

2 replies Last reply on 24 Apr 2010 by
Daniel

Excel skipping a cell when calculating a tota

 Solved

i have a series of codes back and forth it seems a bit insane. but what im wanting is for cell b1 c1 d1 e1 and etc to add together wich i have the fo...

1 reply Last reply on 23 Apr 2010 by
rizvisa1

Pps attachments

 Solved

Hello, I tried finding the place under tool/options to untick but I didn't find it. I have OUTLOOK EXPRESS 6 and recently had to reformat computer. ...

21 replies Last reply on 23 Apr 2010 by
crazy

Tabs dont show

 Solved

Hiya, some of the tabs are missing from my microsoft word e.g. view, format, dunno what to do. HELP

3 replies Last reply on 22 Apr 2010 by
dist.urbd

Compare cell against multiple columns

 Solved

Configuration: Windows XP / Safari 532.5 Hopefully I can explain this as simply as possible. First here is what my spreadsheet looks like I have sepe...

8 replies Last reply on 21 Apr 2010 by
ExcelHelpless
Results 2251 - 2300 out of a total of 2,606