Hi, I deleted large amount of records from the data source, but the corresponding items still show up in the drop-down list box of the row field in the pivot...

I need help on how to create the following: 20 Account names across the top 30-50 Product line down the left All Accounts & Product Line for the following...

I am using CopyFile and CopyFolder in a macro to copy from C: to a CD. Is there some way in VBA to force the computer to write what is in the CD write buffer?...

I use excel 2002 to convert tab delimited text files to .xls. I would like a macro to save these file in .xls format. I open a read only file = filename.txt,...

In excel, how can I change the column titles from numbers back to the usual letter?

Everytime I enter "1996" in an excell cell, and it doesn't mater if there are other characters around it ie. *1996* as soon as I tab out or "enter" the 1996...

I am trying to extract SSN's from a free form text field where the SSN may appear in any portion of the field (beginning, end or middle of the field). The SSN...

Is there a way to create conditional workbook and worksheet views based on the value of a particular cell? Below is what I'm trying to accomplish: I'm...

How do I protect a document, so that when I email somebody an invoice for example, they cannot change any of the information on it? Also, I have a column of...

Hello, I have 150 .xls files each containing over 500 rows of reports. I need to copy about 30 rows from the middle of each file and combine into one file. ...

If I zip up an Excel file of 7,115,716 bytes, the resulting zip file is 1,206,499 bytes, a reduction of 83%. If I do the same with an Excel file of 25,063,936...

Hello everyone, I have two columns of numbers in excess of 35,000 lines. I need to do a look up from to the other. The problem I'm running into is that...

I have a column containing 4/21/2004 10/7/2003 5/5/2004 Which I need to convert to UK dates. because of the variables(4/, 10/) I am unable to use mid etc in...

Thanks for the quick reply, Unfortunately, whatever technique is used has to be explained to all users that need it. I can't identify the columns beforehand,...

I am using Excel 2003. I have a spreadsheet full of data open; I find and select the cell or row containing the data I need and that cell or row is...

I have been saving filtered criteria using 'custom views', icon on the toolbar, however, as this list grows, I would like to sort the assigned names in...

Is there any easy way I can achieve the following without a very laborious route of manually copying and pasting loads of data? I have a large spreadsheet of...

-- mn

I am stuck on a text - Column issue. This feature is wonderful and has saved me hours of work, but i was wondering if there was a way to just seperate the...

Hello, In Column A I have a list of unique case Numbers. (around 3000) A1 123456 A2 234567 A3 345678 In Colums B I have a list of unique case Numbers...