Can this be done? I have about 500 store specific excel files, with 2 sheets each. I'd like a quick way to PDF all of them, not as one big file, but as...

I have a listing of over 2500 numbers that I exported from our financial system. Some of the cells have a CR after the number standing for credit balance...

I have been seeing this error with users that share workbooks between Excel 2000 and 2007. I what the error is... http://support.microsoft.com/kb/213904...

como imprimir varios formularios utilizando uma lista e procv

I have an excel workbook with something like 30 worksheet tabs, I need to get these tabs broken out to individual files. The name of the tabs is what I...

Our company logo is in the header of our word (2003) documents. It's not always visible when our in house COM-Addin is loaded. The Addin makes no calls to...

I'm attempting shade cells using the conditional formatting option. The conditions I am using are as follows... If cell X is greater than cell T then shade...

I'm helping a coworker on this one... We have an Excel workbook with multiple worksheets, each of which shows a summary of a different proposal. My coworker...

I have figured out how to change the font but the check box property is not listed. Is there any way anyone can think of that will allow me to change the...

Hello, I'm attempting to creating a tabbed delimited file from excel that is going to be used for entering sale orders in an Oracle based platform. The...

I have a spreadsheet that has 8 seperate fields that do a calculation. The result of the calculation will either be a value (ie. NUONT01) or 'FALSE'. Only...

I have an excell sheet with tables in it that I want to shift down the format one row when data is entered in the cell above. Below is an example of what I...

Hi, I am using Excel 2007 and trying to apply conditional formatting as follows: If number in column B is greater than number in column D, format text in...

how do i set up list validations placing the info for the drop down in one sheet and the drop sown boxes in other sheets in the same workbook? -- Thanks Mark

I am importing external data to a worksheet using a data base query. The query is a union query in sql, not the design grid. How can I use parameters as...

I want to split the text between " : "1:1 $B5/=i!$?@AOB$E7CO!#(B" into 2 columns (data - text to columns) at the first SPACE How to format "1:1" to...

I'm trying to get the value of one cell from a Data worksheet into an specific one. The formula is as...

Hi, I have a list of data contained in a series of files stored on a network. There is one file for every month, ( file name Jan, feb etc). Each file has...

In my spreadsheet, I sometimes enter a date format (11/04/2009) in some cells, but I often want to enter a simple number format in the cell below (12345). ...

Hi Hopefully someone can help. I'm ranking a list of 'scores' inversely but not quite getting the result I require. There are 12 'teams' they are to be...