Hi, I want cell F55 in worksheet "January" to display what is typed in cell B6 of worksheet "Sheet 1". These two worksheets are in the same workbook. I've...

Excel Users, Thanks for the help. I would like to apply a conditional format to A1 if A2 meets a criteria. For example if A2 is 100%, I would like A1 to...

Is there a way to find average based on multiple conditions. I've been using Sumproduct formula to Sum all the cells but not sure how to use it find...

Why do I have to completely re-learn how to use Micro-Soft products every time there is a new release? I have become quite proficient at using Excel 2003, but...

I have a spreadsheet with 130,000 rows, and vba macro running several loops torugh it. The odd thing that I noticed is: The CPU usage stops at 50%. I am...

when I try to sort a spreadsheet by certain columns, why does it mix everything up?

I am using Office 2003. I have a folder with a large number of Excel files that all have hyperlinks to unique Word documents saved in another area of the...

I am trying to tally the life time hours of a piece of equipment taht the hour meter has quiy working on. I know the hours on it when new meter was...

This is a formula that I have in my spresdsheet at L6 to answer Y or N to certain criteria. I need additional criteria added. I need the same formula but if...

What do I need to do so that the &T in the company name AT&T doesn't turn into AT& ???

When I merge dollar amounts from Excel to Word they come up with numbers like $4,000.99999999999999999999. I would like them to come up with just places. ...

My company recently upgraded to 2007. I had a file that was protected and only certain cells could be modified, for data entry. I now need to manipulate the...

I have a worksheet_selection change macro, that I would like to skip if another Macro is running, is that possible? Is it possible to tell if a macro is...

To be exact, I want to be able to insert 8 blank rows after Row 30, Row 68, Row 106, Row 144, Row 182, and Row 220. Is there a macro to set up for that?

probably stupid question, but anyways... I want to manually copy the content of 1 text cell to the end of another text cell, on the same sheet. For that, I...

Hello, I am working on a very large spreadsheet and need to drag and drop large amounts of data. The problem is that when I do this is drags and drops my...

I want to be able to create a shortcut icon to each individual sheet inside of one workbook. Is this possible? I am aware that there are macros that you...

Does anyone have any suggestions on how to show chart only and hidden every cells within this worksheet? Thanks in advance for any suggestions Eric

I have a bunch of spreadsheets that have a sizable number of columns - usually about 128 columns. And I need to identify those columns that have leading zeros...

D/a, Is there any option like a function or a macro to extract the sheet names in a excel file. For Example: I have a Excel file with 10 Sheets names...