I have two ODBC queries returning data on one worksheet. A user places "Static" info in a cell (column) next to the query results...these are our notes about...

I need to copy a sheet from one workbook to an existing workbook (not a new one). I've tried the right click on the tab for the sheet to copy, then Move or...

Hi All, I have a bunch of data that I am matching by month. To make my formula work, I need all the dates to be exactly the same, but for example, for...

hi according to the below link method, how can i use the picture again for another cell range? can some kind soul tell me how to write the programming....

I have written info in caps and lower case. I need it to be all caps. Is the a command to get it to change?

Hi all, I have a large list of numbers in column A, about 60k. Scattered throughout that list are numbers that Excel read as formulas since the fields were...

Earlier today I opened Excel on my computer programs, found a template and prepared an itemized account of my deceased mother's bank account from April 2007...

Hi all In this Formula how would one add the exact cell you would want to open...

The level buttons have disappeared from my excel when using subtotal. Have I turned them off? Or is this an re-install issue? I am currently using Excel 2003...

When I right - click on a spreadsheet it is giving me the shortcut options for page setup, page break, print area, reset print area etc. Where before it was...

Hi I know I can perform a manual line break in a cell by pressing ALT+ENTER, but is there a way to do this automatically after a space or a specific...

Good morning, I am working with a spreadsheet on a monthly basis which is copied and pasted from a scheduling program. The data is input by month and...

Instead of opening directly by clicking on it, I get a blank blue screen headed Microsoft Excel and Ready in the bottom left. I then have to go to file, Open...

I am currently getting the following error message when closing a workbook in Excel 2003: Cannot find 'C:\Program Files\Microsoft...

I have a client with Excel 2007. When he tries to bring up a document, the gray screen comes up. If he clicks on the document again- his data shows. He has...

"Jack Sons" wrote: Ron, Once I got this from Alan Beban: =OFFSET($A$1,COUNTA(A:A)-ROW(),0) will work if your data always starts in $a$1 if it...

I need to compare 2 columns in 2 sheets but the cells in 1 contains ranges of acceptability (i,.e 2 5). Long story short here's what I'm doing. Sheet 1...

Hello again all- I need to put my data I have in excel in order of zip code, not name. I know how to push the button to put in order alphabetical order by...

Hi and thanks in advance for your help! I have a workbook where I have a listing of "client codes". On another sheet I have a listing of data that could...

Hi, I have spreadsheet with following. The "Details" tab contains almost 200 customers names & acct number along with information for four different...