I have text in rows that are in separate cells that I’m trying to convert into columns; which I figure out how to do by copying the rows click on the cell...

I thought i had formatted each cell but if i type in the cell directly the formatting is lost but if I type the text in the upper area the formatting is...

ok i have a 3 column table column 1is the title column 2 is the genre and column 3 is a persons name bassicaly this is how i want the formula to work: IF Cx...

Hi, I have been given a 2003 Excel worksheet containing just one column of data. This column contains dates (dd/mm/yyyy) and values. I have been asked to...

The background color I've chosen for all my cells (green) won't stay put. When I move a cell and its text contents to an empty green cell adjacent to it, the...

I am creating a dummy site for college but have run into a few problems, Firstly i am trying to publish the site with frontpage 2003, I am hosting it with a...

Hi, I need to conditional format a table with 3 rotating colors of yellow, green and blue. The condition to change the color is when the code...

Hi, I need to know how many days there are between the beginning of this year (01/01/09) and today without the weekends? Any idea Thanks

Need a dropdown list with reference to another cell My problem A1 : with data validation to select from a range named “list’ B1 :...

I need to extract info from a dropdown list with reference to another cell but cannot figure out how . A1 : with data vadilation to select from a range list...

I have a spreadsheet in excel 2003. In cell a1 I have a name for example:Smith,Lisa In cell B2 I have an address and a phone number for example 1234 Anywhere...

Hi Hopefull this will be a simple task for somebody to help this simple Excel user out :-) In Cell A1 I have a set date (12 Apr 09). In Cell B1 I would...

I have a query that refers to a web page. Everything works great except every time I open the file Excel asks if it's ok to update the query. I think I've...

I have a spreadsheet in excel 2003. In cell a1 I have a name for example:Smith,Lisa In cell B2 I have an address and a phone number for example 1234 Anywhere...

I have the following formula =CEILING(Sheet4!BY6, 25) How I get it to round negative numbers too It works with positive numbers but when I insert ie -360, it...

Hello All, I am looking some following solution : Sheet1 Table : Col_A (Date) Col_B (Name) Col_C (Amt) 01-Jan-2009 Japan 1500 02-Jan-2009 ...

Any help would be appreciated. -- Joe D

Using a macro how can I check a worksheet to see if an autofilter is in place and then show all data.

Hi, i have a database, and the data begins from "B5". I need to go from cell to cell with enter, but after "F5" i need the selected cell to be "B6". I need...

I have several related sets of data. Any idea how to arrange the macro in filter following? Now I have a validation list to select value from Row 1 to 3. Let...