• Import text from another excel workbook

    I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to...

    AenE15 pointsBadges:
  • Creating a list in one Excel cell by referencing several other cells

    Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would go through tab one and...

    Adventuredev55 pointsBadges:
  • Year over year pivot table

    Similar to your example except I want to show monthly columns with two separate years as rows in the pivot table below each customer, then insert an additional row between each customer for the % change like this                 Jan     Feb     Mar Smith & Co 2013        ...

    TonyX105 pointsBadges:
  • Can’t open IFS doc

    I have an excell spread sheet on the IFS, I have a drive mapped. I can see the spreadsheet (it's small). When I click on it to open it will sit there saying it's downloading but then I get the error "Can't Open File". It has worked in the past this just started happening. Thanks

    Johnd0155 pointsBadges:
  • INFOPRINT SERVER PDF conversion and printing issue.

    Hi Folks, Hopefully someone can help me. I am trying to implement the infoprint server to convert to PDF bring in a dynamic image with the AFPRSC and print to an infoprint printer. The conversion works nice and I can see the PDF in the IFS and it brings in the images in nicely however when I send...

    Paul66650 pointsBadges:
  • Cell color coding

    I am using a spreadsheet designed by someone else and it has some formatting gin place that when a date is entered if it is within a certain period the cell goes green if not red and so on. I need to add some columns and apply the same formatting however for some reason I cant see the formula used...

    Mas85 pointsBadges:
  • Inserting pre-written parapgraph/sentences, phrases etc into a document

    I saw a Word file which did the following. There was a customized toolbar which popped up. You would place a cursor over the area you want the paragraph inserted, you click on a code letter/number and the paragraph would insrt into the desired location. I feel I'm word savy, i need to know where I...

    Drdreich5 pointsBadges:
  • How to use databases made in Access or Excel in SQL

    How can I use databases made in Access or Excel in SQL? I'm trying to import readymade databases in SQL.

    Dragan1525 pointsBadges:
  • Printing a PDF File

    When I print a PDF file can the PDF file control the number of copies I print and does it know how many copies I print?

    Notatechie10 pointsBadges:
  • Convert PDF to Excel

    How to convert PDF to Excel?

    LDS5 pointsBadges:
  • How to write an abstract on presentation software?

    How can I write an abstract on presentation software?

    abuyastunt15 pointsBadges:
  • Import from Excel to Oracle 9i

    How can I import data from Excel to Oracle 9i?

    Binty25 pointsBadges:
  • Excel report from RPG or SQL

    How do I produce an excel report via RPG or SQL inside an RPG program?

    Taborly0820 pointsBadges:
  • excel macro formated to highlight current date

    I have a calendar in an excel workbook that I would like to develop a macro that could be formated to highligt the current date. I have my dates formated as the serial date. When I write my macro it highlights the same "number" "=DAY(TODAY())" in every month.

    Jlcford15 pointsBadges:
  • What is photoshop?

    Can someone tell me what Adobe Photoshop is?

    sushmadasari5 pointsBadges:
  • Excel 2000 cannot open .ods file

    I have a client using Excel 2000, and he is unable to open an Open Office Spreadsheet in his email attachments. I have set the file association, and tested the actual file to make sure there is no corruption. No matter what, this file will not open on his computer - a message comes up saying that...

    AndreaF9,295 pointsBadges:
  • How to transfer Oracle table data to .CSV file by using PL/SQL coding

    How do I transfer Oracle table data to .CSV file by using PL/SQL coding?

    Tarick215 pointsBadges:
  • Data Conversion

    How to convert PDF files to Excel Files

    Aumarve5 pointsBadges:
  • Printing to PDF tool

    Is there a tool that I can print a PDF?

    MollySue5 pointsBadges:
  • Microsoft Excel code for save name and check it exists

    Hi sir, I need one code sir that will create one Excel file to save name and mail ID and then check that it  already exists by using VB.NET and Excel.

    saranyaumasankar25 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following