Hi, I'd like to know how to set a formula in "value if true". I want to get sum of L5+e6-J56 when the value is true Thanks.

I would like to print all the active worksheets in one PDF file. When I try to print all the active worksheets, it will print a number of them in one PDF...

Is it possible to hyperlink a bitmap image in one cell in one workbook to open and/or highlight directly to a specific cell in a second workbook? These...

I am new to macros and I need to create a macro with an if statement. What is the correct format, including spacing to make this work? I know the wordin is...

I have a sets of data that goes: 000 820 2184 123 421 8952 and so on.. am i able to set a command/function that can prevent duplicate sets at columns and...

Hi, Is there any reason that a paste link would stop working, I have have cells from one sheet paste linked to another,and for some reason they have stoped...

Hi all I can use conditional formatting to highlight a entire row but is it possible to highlight more than one entire row at the same time. e.g. If cells...

I am trying to make all my subs private to minimize confusion for others using my excel spreadsheet. All of my subs/macro are on Module1, including a public...

Is there a function that will add the values of the same cell in several worksheets? Suppose I have 52 worskheets (one for each week in the year) and I want...

I am trying to work out the formula to populate. On Sheet 1 I have this Model Black Toner Yeild TEST TEST 2 On Sheet 2 I have this

I have a file with a data dump. It has seven worksheets, each about 30 columns by 21,000 rows. Most of the info is text, although I have about three columns...

In excel '03 there is a white box with a drop down menu similiar to the one that tells you the font type. I cant find that box in '07. Does anyone know where...

I have an Exel file with 2 columns. The 1st column has over 40,000 different values, the 2nd has only 5. I need to create ranges showing the Column A values...

Hello: Do you know how to eliminate hyperlinks, for all cells from within a column in Excel? I know how to do it by cell but not by column. childofthe1980s

I wrote a macro and assigned it Ctrl+b (lowercase b). After realizing that it was also the command for Bolding text, I removed the shortcut, and even the...

I have this formula: =LOOKUP("YES",D9:D32,A9:A32) that returns the number in the appropriate row in column A. This is not working on every sheet in the...

I use online banking and want to balance my checkbook without typing in every transaction. Is there a way to do that?

Is there word art like MS Excel 97-2003 in MS Excel 2007?"

I have a table with a column of data that has merged cells with a value in it, I would like to unmerge the cells, but retain the value of the cell in all of...

I need help on an IF function. Basically I want to do this: IF "," is not found in A1, then... I've left out the part of the IF function I know how to do so...