• Excel 2003 – conditional formatting

    Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date Column C = Due Date -...

    Kelz82740 pointsBadges:
  • Ms Excel Question

    i have entered different students name in column A, Paper name in Column B & their marks in column C. like: john english 90 magi maths 15 john stats 99 john history 35 & i've applied this formula: =if(A2:A66000="John",sum(C2:C66000)) to get the total marks of John in all papers,but it doesnt work....

    Moonzy5 pointsBadges:
  • Can I link items between Outlook, Word, Excel, and Access, through the Calender view?

    Can links be set in Outlook Calender '07 to docs in Word, Excel, Access? I want to be able to go to a set date and access from that view all items pertinent without having to go looking for each item separately. Is possible?

    Notumbo15 pointsBadges:
  • Outlook export

    How can I export email messages to excel or a file?

    MarshaLehan5 pointsBadges:
  • Extract OLEObject from NSF created with Microsoft Office Library Template

    I have created a New xls in my NSF (above specified in title). Now I want to extract that object from the Notes Document. How can I do this. I have used NSFItemInfo and NSFItemInfoNext with item_name as $File. Is it Ok or I need another extra information?

    Sppradip70 pointsBadges:
  • Automatically populate a form based on a match from another worksheet.

    Ok, here goes... I have a very large talent management database that is housed in Excel. This database includes information on performance ratings, work history, education, etc. on every employee in the company. I also have a 'Talent Profile' form (also created in Excel) that I give to HR whenever...

    Jedski2520 pointsBadges:
  • transferring data from iSeries to Excel 2007

    Using the Excel 2007 add-in for the iSeries data transfer, is there a way to transfer into the spreadsheet more then 65,000 rows?

    Popers40 pointsBadges:
  • How to update data using Microsoft Excel VBA?

    I HAVE A CELL "A1=NUMERIC VALUE" & "A2=NAME OF PARTY" WHICH IS UPDATED EVERY MONTH AND I WANT TO SAVE IT WITH "DATA" SHEET WITH EACH PARTY NAME(CELL A2) AND ITS MONTHWISE VALUE(CELL A2).HOW CREATE DATA SHEET WITH MONTHLY COLOUM NAME I.E : DATA SHEET: NAME OF PARTY APRIL08 MAY08 SURENDRA KUMAR...

    Sa2915340 pointsBadges:
  • While generating Excel thru BO

    While Generating Excel thru BO. Sometimes it will partial results

    Satishsurana5 pointsBadges:
  • SSIS and Microsoft Excel

    I have a road block that I need to find a work around for. I work on a system where the Databases reside on a soley database server (SQL 2005). I need to run a stored procedure on a nightly basis and export the results into a template excel file and put out on shares. Sounds simple right? Here's...

    Cathryn35 pointsBadges:
  • Opening and Closing Impress

    Is it possible to Open and Close Open Office Impress from another application. If so how?

    Rjacob5 pointsBadges:
  • How many uses of Microsoft Office?

    Just as the title says, on how many computer/desktops/laptops can you download this on and it work? Like, if I downloaded on my laptop, and two other desktops, would they download and work on all three?

    Turk19075 pointsBadges:
  • Animation within a table in Kiosk Mode

    I am putting a presentation together that I want the user to be able to click choices and go to certain slides. I have this part figured out. However, some of my slides have animation that I use the right arrow button to highlight boxes within a table. (There are almost 50 boxes to highlight on...

    Kezeork5 pointsBadges:
  • Excel 2007 charts

    I have a macro that runs when a cell is updated by a PLC. When this cell changes its value I insert a cell into a column and copy data from another cell and paste it into that new inserted cell. My problem is that my chart that is associated with the data where the cell is inserted dissapears. I...

    JimGlover5 pointsBadges:
  • Blank Merge Fields

    How do I get merge fields in my word document not print when they are blank, or #N/A, or 0?

    Hawkfandeb5 pointsBadges:
  • Using Excel, I past from a table brom a web site and excel puts everything in one cell

    Using Excel 2003, I paste from a table on a web site and excel puts everything in one cell. I have had no problem until today. It seems excel is not recognizing the seporators as it did before. I am using CTR-C and CTR-V to bring the data into my spreadsheet.

    Canthandle5 pointsBadges:
  • Conditional Formatting Excel 2003

    I have three columns, Column 1 = Start Date Column 2 = End Date Column 3 = Close Date I need to place a conditional format or and "IF" statement on columns 2 and 3. Stating if column 2 is after or 1 month from today's date highlight in RED. And column 3 should state if column 3 is less than 3...

    Reyes335 pointsBadges:
  • Open PDF on Web server from AS/400

    Is it possible to open a document (i.e. .PDF)stored on a web server from the AS/400 ?

    Ibsluis15 pointsBadges:
  • outlook error

    Laptop was off for repair. Had to reinstall Office. When I tried to open Outlook I rec'd this message- Failed to register a VB script dll. Reinstall or run regsvr32.exe VBscript dll to self register. The form cache file 'C:\Users\TEST\AppData\Local\Microsoft\FORMS\FRMCACHE.DAT is not valid.Contact...

    Milspouse5 pointsBadges:
  • HELP WITH JOINING 5 TABLES

    I need to join 5 tables and the probelm is that I have imported 5 seperate excel spreadsheets and the first column in all the spreadsheets is the same and I need to combine all that data to see if there are any duplications throughout the 5 spreadsheets and then combine some data that may be the...

    Law1235 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following