General

pulling data
I'm not sure I am explaining this right I want the data from C21 on sheet 1 in a cell on sheet 2 if the A & B column data matches SHEET 1 row 21 A B C D E 4/21/2010 34287 74 3 4 SHEET 2 row 20 A B C D E 4... 27 Apr 2010 15:40

Conditional formatting using part of the cells contents
Hi, i'm doing some MPG calculations at the moment and using a formula from a seperate worksheet which then displays on the first worksheet (="You average "&Round(&Sheet2!A4,2)&" MPG") and i want to format that cell (that displays the "Your Average is xx.xx MPG) so that if, for example, my average MPG is <=10 t... 28 Apr 2010 06:09

Yet another macro question
This is what I get for trying this on my own. I just want a macro that will insert 2 blank rows at the current cursor position. Sub Insert2Rows() ' ' qrow = ActiveCell.Row Rows(qrow & ":" & grow + 1).Selection.Insert Shift:=xlDown End Sub Any ideas? Thanks! Amy ... 27 Apr 2010 14:30

not enough resources to display completely starting excel 2010
I have just performed a clean install of Office 2010, having totally removed my Office 2007. I have installed the 64 bit variant, running on my (fairly new) Sony Vaio with 250 Gb ssd and 6 Gb RAM. I am running windows 7 ultimate (64 bit). Imagine my surprise that, whenever I start Excel, I get the error message... 27 Apr 2010 14:30

Joining Two formulas with the Help of AND / OR / IF Functions to get the desired result
Hi, This is Akash Maheshwari. I am stuck with a formula and not able to break through since last few days: I require your help in this relates... I have two Formulas: =IF(D7="V Top 9702045619",AccountWiseReport!K5-F7+I7-J7+K7-G7-H7) =IF(D7="V Top 9702043906",AccountWiseReport!K40-F7+I7-J7+K7-G7-H7) What i ... 27 Apr 2010 13:21

display list selection in a different cell
I have a combo list which is allows multiple selection. I need to be able to display the selection in a different cell. For multiple selections, I'd like all values in one cell separated by commas. Example Combo list A B C D A & D have beeen selected. Displayed in another cell: A, D Please not... 27 Apr 2010 14:30

pulling from one sheet to another
I am having trouble pulling data from one sheet to another: SHEET 1 A B C D E 4/21/2010 34287 74 3 4 4/21/2010 39210 90 1 4 4/21/2010 13969 56 3 3 4/21/2010 33369 45 2 2 SHEET 2 A B C D E 04/16/10 139... 27 Apr 2010 19:06

How can I increase the amount of visible text in a cell?
... 27 Apr 2010 14:30

reference cells when looping
Using a loop like this For Each tcell In Range("A4:A17").Cells If tcell.Value = "Danny" Then 'Write a value into column 2 columns to the right End If Next I want to write a value into the column 2 columns to the right of the current column and on the same row but I am not sure how to refer... 29 Apr 2010 04:36

page numb. in margins?
Is it possible to print page numbers in the margin of printed pages. thanks Bruce ... 27 Apr 2010 13:21