General

How to run a macro automatically when the file is opened?
Hi all, I often have to click a macro button after opening an Excel 2003 workbook... Is there a way to open the file and automatically run the macro immediately after opening the file without me sitting there and click and waiting? Thanks! ... 23 Apr 2010 21:42

Does anybody know why these two Excel files must be open in the same process?
Hi all, I am doing the following sequence of operations all the time: 1. Open up an Excel 2003 sheet A; 2. Click a button and run a macro in that Excel sheet; 3. After it finishes running, open up another Excel 2003 sheet B in the same Excel session/process; 4. Press F9 to do calculation/update the sheet, and... 23 Apr 2010 21:42

How do I change the links in Excel at one batch?
Hi all, Good day! Please help me with the following issue: How do I do the following in Excel? Suppose in an Excel sheet there are lots of links, linking the cell to other sheets, There are millions of such links, how do I change the links to another sheet name at one batch? I hope there is a "Fi... 23 Apr 2010 21:42

pet food bank needs template for organization of customers
I am looking for something to help a pet food bank keep track of their customers from month to month. We keep track of name, address, phone, email, up to 5 cats and 4 dogs, including pets name, species, breed, weight, age, and spayed/neutered, the amount of food given, any special needs, and what requirements t... 24 Apr 2010 19:27

skip 0 average
How do average a colum of numbers? I will ignore the $0 number. Thank you very much! ... 23 Apr 2010 21:42

Formula to show entire record on another sheet
I'm planning an event and have an invitation list with several types of invitations (i.e., complimentary, VIP, regular). This information (Name, address, type of invitation, etc.) is stored on Sheet 1. On Sheet 2, I want a list of just the complimentary invitations. Is there a formula that will automatically... 23 Apr 2010 21:42

Opening Excel 2007 in Excel 2000
HELP! My new Windows 7 computer came with a trial version of Office 2007. I did not want to buy 2007. When I opened my old Excel files they opened in XL2007 and I was asked to input product key. I did not , but proceeded to update my spreadsheets and saved them as compatible with 97-2003 XL. Now the trial peri... 23 Apr 2010 21:42

Pivot Tables - Difference From
When I display years and I would like to know the Difference From previous in either Excel 2003 or 2007, the values in the previous year do not display, only the resulting difference. Is it possible to display the previous year's values so the difference would make sense? Thanks for your assistance. -- I Te... 23 Apr 2010 18:11

columns
My columns are labeled with numbers. How do I change these to letters? ... 23 Apr 2010 16:11

Account aging formula using workdays M-F
I need a formula that calculates the working days (A) from start to todays date and (B) from start to completion. I also don't want a value displayed until at least one date is entered so it doesn't corrupt my avg formula. I'm currently using =IF(AND(D3="",C3=""),"",IF(D3="",TODAY()-C3,D3-C3)) in column C and i... 23 Apr 2010 18:11