Changed worksheet file (Excel 2003)
Is there any indicator that can be displayed to alert the user that un-saved changes have been made to a worksheet? (In some other applications, an asterisk ( * ) is displayed next to the file-name in the Title Bar). ... 10 Mar 2006 22:41
Compile error in hidden module
I have a Windows XP laptop with Office 2003 installed. When you launch Excel a Visual Basic error comes up and says "Compile error in hidden module: AutoExecNew" Can anyone tell me how to fix this problem? I looked at the knowledgebase and it says it has to do with an Adobe update. I tried updating Adobe, I... 10 Mar 2006 14:25
Program for assigning work shift hours
Hi I'm new I was wondering if there is a template or example I could get from the net for a excel project I am using. My wife has 7 operators that work various shifts thru 7 days and 24 hours. The shifts are constantly being changed. And being juggled around. I was thinking if I could make a program where whe jus... 9 Mar 2006 22:15
How do I sum color filled cells in Excel with no values or text?
I'm creating a shift schedule for 12 employees using an existing template that has rows of different colors that indicate hours each person is in the office. The company needs a minimum number of employees working during core business hours. I don't want to manually add all the colored cells per half an hour ... 9 Mar 2006 13:26
Time Weighted Return Function
I have a series of returns (%ages) in rows E1208:E1297 and am trying to link them up to a time weighted return. The formula I'm trying to create is as follow: [(1+r1)*(1+r2)*(1+r3)*.....(1+rN)]-1. r1 = E1208 r2 = E1209 ....Etc until I get to E1297 Does someone know how I can do this with a formula? Please ... 9 Mar 2006 12:23
Can Excel create an amortization schedule?
I know that Excel will calculate payments, but is there a way to create an amortization schedule? ... 9 Mar 2006 09:47
I am looking for Template for a sale of Land
I am looking for a bill of sale and deed template for sale of land. can this be found in word or excel ... 8 Mar 2006 15:01
lookup on named formula
I have 2 columns: col A contains unique codes col B contains the names of named formulas TTT name1 TTF name2 TFT name3 TFF name4 Is there a way to do a lookup or index/match or whatever to find the appropriate code in column A and perform the corresponding named formula in column B? -- ViMuTo -------... 9 Mar 2006 00:23
formula to convert decimal feet to feet inch sixteenths
I would like to write a formula in excel, without using macros, to convert decimal feet to feet-inch-sixteenths. Can someone help me ? ... 7 Mar 2006 17:09
calendar template
I am looking for a template for the 2006-2007 academic year ... 5 Mar 2006 19:52