I am unable to work out how (if at all possible) I can create a drop down list that retains the format. The list I want to create has data in it and the cell...

How can I assign a function to a command button placed in Excel 2007 Worksheet? I need to use Goal Seek command (from Excel Menu/Data/What-If Analysis/Goal...

Wanted to know if there is a method to insert a table in the footer?

i am trying to have a criteria that one cell is greater than or equal to a date but i want the date to reference another cell. For instance =B3 (greater...

Hello, I am tryiing to edit prices on a massive spreadsheet and want to know how to just select numbers out of a cell. Eg: Cell has "Quantity: 66" and I only...

HELP! I am trying to count the number of times a number appears in a field, conditional upon it being a certain number in a different field. This is tracking...

I have a coulumn which contains somany dates in DD-MM-YY format. I want to count the number of cells which contain a range of dates like from 01.01.09 to...

i want to use sumif formual with a text. eg =sumif(A1:A100,"ACC*",F1:F100). is this possible

hi culoumn a is date column b is numbers c1 cell is a report as at today input how do i write a formula to sum the contents of column B based on there date...

Hello, I have a data source with several columns that may contain data I want. For example, there are multiple stakeholders for each project and the...

We want to be able to share an Excel workbook with users on a network drive. We want the Excel workbook to update automatically when edits are made, without...

I must have inadvertently locked something in 2003 excel as when I move cursor in ANY spreadsheet, I cannot move the cursor without hightlighting a blue box...

Used to be if I wanted to removed a drop-down selection I would just go to the macro design toolbar and select the appropriate buttons. Now microsoft has...

Hi, What i'm trying to do is use 1 Array as a lookup array and the other array which contains the values that i want to lookup. For example: Array 1 Col A...

I am working in Excel 2007 and I was wondering if it is possible to put a datasheet on sheet 1 to pull a part of the data I have entered on sheet 2 based on...

hello i'm new to excel but i have a task to creat a survey using muliply option, can someone show me how using baby steps? thanks -- yewande

In one worksheet document I have cells of data in a partial column I want to link to another worksheet but transpose them to a row (the sequence of data is...

How do you insert 3 or 4 lines of text that take up the width of the sheet. I read somewhere that it can be done but don't remember how. -- Janet A.

I'm setting up a second worksheet where in column A, I just want the appropriate information in column A on the previous worksheet to populate. (Information...