excel 2000

Hi folks, I'm running Excel 2000 with a legacy spreadsheet which has a single worksheet. Each row contains the details of a given task performed by a particular farm vehicle. The row includes the day. month and year that each job was performed (in separate columns), along with a brief job...

I got a simple scatter chart. Three data columns A - Store number B - Sales % C - Sales Chart shows X - sales Y - Sales % data points are Sales % How to label the data points in the chart with the store number and not their values? I'm using old Excel 2000

Hi Everyone, I was using openoffice calc and having problems so I decided to use the version of EXEL 2000 I have. Well it does not support SUMIFS. I have been trying unsuccessfully to setup my multiple critera formula using SUMIF and SUMPRODUT, but no success. Below is the code i was using in...

Ok guys and gals. My brain is fried. Firstly, let me say I do not know VBA. I know most formulas. I have a rather intricate spreedsheet and I have 99.9% of the formulas finished. So here is my finial delima for today: (E13) is the manual input Year in (YYYY) format (E14) Has a dropdown of...

Excel 2000 <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead> A B C D E F </thead><tbody> 1 RD_NO OLD_DISTRICT NEW_DISTRICT 2 LVA300 6 =VLOOKUP(A2,$E$2:$F$129,2,FALSE)=B2 LVB100 4 3 LVA301 6 =VLOOKUP(A3,$E$2:$F$129,2,FALSE) LVB101 4 4 LVB100 5...

I am having trouble with the INDEX/LARGE function in this sheet: Excel 2000ABCDEFGHIJK2District 0District 1District 2District 3District 4District 5District 6District 7District...

Hi, I create a combo box using the following: If CheckExists("cmbBaseD") = False Then With ActiveSheet .OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _ DisplayAsIcon:=False, Left:=159.75, Top:=80.25, Width:=75.75...

I have an type mismatch error that occurs on the fifth line of the code. Set rs = db.OpenRecordset("Header_New", dbOpenTable). I don't know enough about OpenRecordset command but from what I gathered from Microsoft the syntax is correct, but I may be wrong. Is there a specific reference that I...

I am trying to figure out how to connect to an Access database that is on a network drive using vba in Excel. I have this working fine if the network drive is already mapped however some of the people that will be using the Excel front end do not have read or write access to the network drive so...

Hi guys, I've used some VBA coding to conditionaly format some cells in my spreadsheet (in Excel 2000), it all seems to work fine, however, when i sent the spreadsheet to a colleague (who is running 2003) it doesnt seem to work. Im assuming that the only reason its not working is because of...

Hello Not too sure if this is possible, but looking for help with the following formula. =IF(AND(Training_Plan_2011.12!H9,"COM 1"),(Training_Plan_2011.12!A9,"7-Mar"),"Training_Plan_2011.12!I9","") I'm working across spreadsheets and basically trying to get excel to input the value of a...

Isolating non-numeric data in an IF statement <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am trying to run, what I would think is a fairly simply formula, though I am having trouble finding any information on-line. <o:p></o:p> If I have a range of...

I am looking for a ONE Formula to use with conditional formatting copied and pasted in the cells of B3:G19 to search the range I3:I19 and color the cell if the cell location matches a value in the ‘example list’ (I3:I19). <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...

Reverse Column and Row Look-up <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> We have been working all day on a very large cataloging file. <o:p></o:p> We want excel to point to the ROW and COLUMN location by searching a RANGE. <o:p></o:p> EXAMPLE...

...this may hav been covered before so i will appreciate if sme 1 can direct me to it or jus lemme hav it here so i have 2 excel work sheets, they both have 10,000+ records. one of the sheets has been supplied to me by a medical company, n their listing is by names and cert# . our records list...

Hi All, I urgently need assistance. I have created an excel workbook that contains 4 worksheets. Each worksheet contains candidate data with fields such as Candidate name, ref number, location, job title etc. I am very new to this all and with the help of Google have managed to create a data...

When I delete all the data items from a Pivot table in Excel 2000 I get the following error message: "Excel exe has generated errors and will be closed by Windows. You will need to restart the Program. An error log has been created." I am using Windows 2000 with Excel 2000, when I use the same...

Hey all, I'm a newbie here, desparately looking for some help. My boss at work wants me to use the chart function on some excel files to make line charts in Excel 2000. My problems begin with the format of the information, and don't end there. The information is spread out among this little...