Hi, I would like to key in data which duplicate before, I notice that some will be auto complete but some not, I already check the autocomplete function in...

Hi.. I would like to know if there is a way to detail pivot tale data without creating a new table, or in other terms, without the need to convert it to a...

Hello Everyone, I want some questions on EXCEL-2007 for checking competency level of the user. Please help. -- Ananta Gupta

Good mornig, pls help me, i want insert 3 rows when the data changed Colum A Row 1 920 Row 2 920 Row 3 920 Row 4 ...

I have Excel 2000 so these problems are more than 7 levels is there a way to make them shorter. I did make a vlookup for them but if I have to move the cell...

I have a colum with full names ie John but I only want the first initital - is there anyway to cut and paste or whatever so I only get the first letter from...

I have a range of dates that I want to conditionally format. Eg, todays date is the 5 May 2010. I want to highlight all of the dates in the range D14 to...

I have a spreadsheet with two tabs. The first tab(A) is manually linked to the information on tab (B). Tab (B) is subtotaled and whenever I change the...

I am using excel 2007. I have a spreadsheet that contains data: Acct no Date PPT Paid Sales Tax Amount 1000 4/30/10 60.46 4.54 ...

I am trying to limit the number of hours that my employees can log. How do I prevent the total of 3 cells from exceeding 80 hours. I tried to limit it...

I have a heavy excel workbook with lots of formulas, every time I did something it was calculating literally for 20mins, so I changed it to Manual Calculate....

Hi, I've been successfully using Ron de Bruins Mail An Active sheet macro. I however now need to modify the macro so it either: 1. copys Macro Functions...

Is there a way to format imported data to always have 5 digits or characters... no matter where the decimal point...

I am using excel 2007 and am trying to share a workbook. review/share workbook Then I get the message that the file is no longer shared. How can I share the...

Hi.. I would like to know if there is a way to detail pivot tale data without creating a new table, or in other terms, without the need to convert it to a...

Excel 2007 Advanced Filter With optional macro. http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_04_10.xlsm Pdf preview (2...

I have a worksheet with a lot of rows. I'd like to see all the rows in the worksheet that match a particular "query", like "column A = 'foo' || column B =...

"GARY" wrote in message ... COL A has 800,000 cells COL...

How can I search thru an entire workbook for a keyword and return the row? I would like it to behave just like filtering just on the whole workbook.

I am using a macro and at the end of the process I am deleting a worksheet. When this performs a pop up appears waiting to accept clicking on the delete...