excel 2003

Hello everyone ! :) I'm currently stuck because excel 2003 only has 3 criterias for conditional formatting... and I need about 22?.. :( What I'm trying to do is I'm trying to set for example Apples to be all in colour red and Bananas to be all in Green and Strawberries to be all in Pink and...

Hello. This is my fist posting on this forum, and first posting on any forum for that matter. I have been trying for some time to export the value in my access field into an excel cell. The user will dblclick a hyperlink, which will open the corresponding file, as well open an excel template...

I hoping someone can help, I have a template within the 2003 Excel Workbook, I need some help to duplicate the worksheet template based on the number of days working. I already have a cell calculation in (c2) to capture the results between the start date and end date. Also I would like the...

I have a Word document that had a bunch of Word Tables with formulas that link to other tables in the document. I've converted these tables into Excel Objects in the Word Document but can't seem to figure out how to get values from one Excel Object to another. For example, let's say that I have...

When I view this tutorial page, I found the following: Use Trace Precedents Choose a formula and click Trace Precedents. It is on the Formulas ribbon in Excel 2007 and the Tools - Formula Auditing menu in Excel 97-2003. Excel will draw blue arrows to show all the cells that flow into this cell...

Hi, From my VBA code I import some data from several wotkbooks into one destination sheet. All columns except 2 contain text, the other 2 contain integers and doubles. To import I simply use copy -> paste special values but some of the cells that should have double values gets translated as...

Hello, I wanted to know if it was possible for me to be able to copy a whole row into a different sheet based on a column value. For example, if B6 = CLOSE, the whole row would be coppied to the sheet name CLOSE. If B6 = OCCUPIED it would be copied to sheet name OCCUPIED. I also need if W7 = to...

Using Excel 2003 and cannot copy a worksheet and am getting this error: File not found: C\Document\Temp\VB4B.tmp Any suggestions for how to avoid the error would be greatly appreciated

I have a number of staff recording there case notes on individual workbooks in their named folder. Labels along the top = Client ID (number) Date (date) Action (Text) Staff (Text) Basically they complete this everytime they work with a client to keep notes. I want to be able to merge each...

Help!! I have a rather complex (to me) scenario which I just cannot work out the best way to deal with this... any suggestions or samples would be really appreciated!! I have a workbook with two worksheets, Sheet1 and Sheet 2. Based on the data entered in the 2nd column on Sheet1, I'd like a...

Hey folks, been trying to puzzle my way through this one but I'm tying myself up in knots trying to work it out!! A little help would be appreciated :) I have a named cell (which I have called Country) on Sheet1, on cell A1. This cell contains text. I would like to take this text value, and...

I have 2 tables consisting of six quarters of data, the first table contains bank names and the second adjacent table contains the values associated with each bank. Each quarter of data is sorted in ascending order according to corresponding values in values table. I have a drop down box that...

Forgive me, maybe this is just obvious, I've only recently discovered the Name Manager. I avoided upgrading to the ribboned version of Excel as long as possible but got drug kicking and screaming into it... In the Name Manager, I see a #Ref! error for a named range (A name I never created BTW)...

<TBODY> Hi, I need to write a macro that will fill in a row depending on one cell's value ie if Saturday or Sunday Highlight row blue I also need to highlight cells if they return certain values S - red H, AM, PM - green At the moment I can do either or but can not work out how to get both...

Hola a todos, Tengo una duda en excel 2003, la cual es probable que se solucione con una fórmula matricial. Tengo una columna A con varias fechas: <tbody> A B C 28/02/2010 Enero 0 29/07/2011 Febrero 1 30/07/2012 Julio 3 31/07/2010 Agosto 2 01/08/2011 Octubre 0...

I have installed Office 2007 in addition to Office 2003. Mostly, I'd like to open XLS files in 2003 and XLSX files in 2007 so I edited the dft pgms under the registered file types for XLS to use OFFICE11/EXCEL.EXE (instead of OFFiCE12/EXCEL.EXE). This is now working. In addition, I have the...

Hi, Using Excel 2003 This code tries to filter a pivot table using VBA: I get an error "Unable to set the visible property of the pivotiten class" when trying to set pivItem.Visible = true Why? I declare pivItem as PivotItem and machine is a string For Each pivItem In...

I am using Excel 2003 on a Desktop PC and would like to create a formula which will average a percent in a cell even if the percent or the formula is moved to a different location in the worksheet. The spread sheet will need to be rearranged. I understand that I can use Absolutes to keep the...

Hello, I'm using Windows XP with MS Excel 2003. I have a pivot table representing a survey. Let's say I've built the survey outside of excel and I've imported the response data into Excel. One of the questions in the survey is "ratings" and the possible valid responses for it is: "Excellent"...

Hey there, I work for a pulp and paper mill and we have "toolbox meetings" everyday. Its an Excel worksheet that I made in Excel 2007, has a simple calendar on it with hyperlinks referring to tabs corresponding to the dates on the calendar. The file is saved as a 1997 - 2003 format (.xls) and...