General

Excel calendar?
I'm trying to create a calendar in Excel. I need one each for 7 salesmen in our organization. It must be set up like an appointment book. (I've found a template that I can modify to work.) Each salesman will maintain his own calendar on daily basis but our secretary needs access to all of the salesmens cale... 8 Jul 2008 16:11

Error occur while loading Sheet1811111111111111111" HELP!!
Hi I realize that the code below is the solution. But how can I make this code run everytime I open up excel. I am currently using excel through lotusscript to print documents out. But on several documents it gives me this error, so it kills waittime in the lotusscript program and freezes it untili I press Yes. ... 8 Jul 2008 16:11

excel: combine several spreadsheets into one workbook
I need to combine several spreadsheets into one workbook. Each spreadsheet has internally 2 worksheets that have links between the 2. If I copy each individual spreadsheet into the common workbook, won't the links be messed up? -- Confused... ... 10 Jul 2008 12:23

Pivot Tables
So I have written up some code in VBA that basically takes some sloppy input files (system reports) and formats them, adds in some new fields for more info and creates pivot tables. In each of the pivot tables year is the column field. My original problem was that "blank" would appear in this field. That was... 8 Jul 2008 15:10

Toggle between two workbooks via MACRO
I have two workbooks open, one I know the name and it is where I am running the macro from, the second one I only now that it is open but I may not know the name (as it could have been renamed). I need to go to the second workbook (and make it active) via a MACRO. Thank you in advanced Aligi ... 8 Jul 2008 16:11

Excel Formulas with multiple criteria
Can anyone help me write a formula which would produce the following result. I have three colums, two have criteria and the third has values in the cells that need to be added if the criteria in the other two columns matches. The worksheet is very large containing over 42,000 date rows. Any assistance greatl... 10 Jul 2008 14:27

My Cell Input is Changed to Different Value by Excel
Hi! I typed in this value in a cell: 525.5, and hit the enter key. Excel changed the value to a date and time: 6/18/1901 12:00 PM. What the heck is going on? Thanks. Jeff, Napa, CA ... 9 Jul 2008 04:28

Microsoft.ACE.OLEDB.12.0 - BUG
Hi, well, this is actually not at all relevant when connecting to ACCESS, only when connecting to EXCEL. I am now deliberatly cross-posting to an excel group, my apologies in advance if anybody feels this to be against "netiquette". regards Sven "Bob Buckland ?:-)" <75214.226(At Beautiful Downtown)compuse... 8 Jul 2008 14:08

Multiple IF values
Trying to assign values to certain text in a column K2 =City I want L2 to show a number reference for that city. If K2 = Columbus then L2 = 1 If K2 = Denver then L2 = 2 I went to this.. and it failed =IF(K2="Toledo",1,0):IF(K2="Columbus",2,0): IF(K2="Cleveland",3,0) Help? ... 8 Jul 2008 14:08

Conditional Format - Due Dates - 2 questions (2nd posting)
I have a spreadsheet that tracks due and past due dates. The default color of the spreadsheet is black. A is the due date column. B is the completed date column The irst furmula in B is =$A1>=$B1 to track items completed before the A1 date, set to blue. Second one is =$A1<$B1 to track items completed aftre ... 8 Jul 2008 14:08