• Excel linked cells

    How can I link two cells on from two different work sheets so that updating info in one will do so in the other and vice-versa? No matter which cell I update I need it to be mirrored by the other cell.

    JoshuaR5 pointsBadges:
  • Update Access Data Base from Office Live site

    Can I update an Access Data base from a Linked Excel spreadsheet uploaded to an Office Live site ?

    Jc50otr5 pointsBadges:
  • Current Date in Excel Query

    I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input it everytime? Thank you!

    Jameb1220 pointsBadges:
  • how to reference clipart in excel

    Ok, what I want to do might not be possible, but I thought I would ask anyway. I have a simple drop-down box (data-validation) with "yes" and "no" options. Ideally, when someone chooses "yes" I would like a clipart to be entered into the cell. For instance, I would like a checkmark or a thumbs-up...

    Jedski2520 pointsBadges:
  • Rusty and Need Help

    I've been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone....

    Bluize20 pointsBadges:
  • programming

    Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want 'X' and in Place of alphabet i want 'N', do you know how can you we do that in Excel? i wana to change numeric values in 'X' and alphabet in 'N' form, and my friend did already, through...

    0717855 pointsBadges:
  • Designing Table Layout

    Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times...can anyone help?

    CMS5 pointsBadges:
  • Pivot table issue

    Hello, I have created a rather large pivot table and what I am trying to do is on the pivot table itself, as I uncheck something from one of the categories, I want the unchecked items to log a history of what has been unchecked, while the checked items stay. I have already gotten the items that...

    Cevalogistics5 pointsBadges:
  • Creating and importing data into a relational database

    I just started programming six months ago. I have a project to import data into a relational database. I have data in an Excel file that I need to import into a database. The application is recruiting software, for government jobs. I have a list of applicants and the jobs they applied for. First, I...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copy past in excel using VB

    i want to cut data in a colunm H and copy it in column B. i tried to record macro and run it. but i am not getting the values in column B. i am using excel macro and vb code to do this. i understand that the data in colum is cut and the data is not retrived while it paste in column B. Can Any one...

    Krishsrikanth5 pointsBadges:
  • Select documents from a Notes View and paste into Excel

    I'm looking for code to select documents from a particular View and then paste it in a particular template of a Microsoft Excel spreadsheet. Is this possible? And if so, can anyone offer me some sample code?

    Domino Ask The Experts435 pointsBadges:
  • How do I export an Outlook 2007 public folder calendar to Excel?

    With Outlook 2007, I want to export from a calendar in a Public Folder into an Excel format. The Import/Export menu option only allows me to pick as a source for the export, a calendar in my personal folders. How do I export from a Public Folder calendar? This question was submitted by a...

    BrentSheets6,925 pointsBadges:
  • Whats a good tool/software to import (excel, csv) into IBM DB2

    Whats a good tool/software to import (excel, csv) into IBM DB2? Would be great if this tool/software is free or doesn't costs to much. thanks

    Geyes15 pointsBadges:
  • Microsoft Access and Oracle

    Can tables created in Access or Excel be imported into Oracle?

    Micheline foxxe10 pointsBadges:
  • ,temporary files, on win02/03 servers in access(.ldb files) and excel are not deleting when applications are closed

    can someone provide a possible solution

    Wildbull5 pointsBadges:
  • Changing Color in a Cell

    I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading color for...

    Kioh4650 pointsBadges:
  • Exporting large files in Reporting Services 2005

    Reporting Services 2003 uses a lot of memory for the Excel Export, making it impossible for files 15 MB or larger. Is this still an issue in Reporting Services 2005 or above?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Update excel charts auto from as400 data

    I have a user request to create charts in excel using data held on the as400. I can do this in seperate steps but the user wants it as automatic as possible. At the moment : I run a query on the as400 to create data file I transfer using client access I open in excel & then copy data to graph excel...

    Gerrib150 pointsBadges:
  • handling text overflow

    Text that is too long for a cell can be handled in several different ways. What is the difference between: (1) Not giving Excel any instructions about what to do with the text overflow (2) Letting Excel wrap text in a cell (3) Using ALT+ENTER to cause Excel to go to a new line while entering text....

    Brad3386015 pointsBadges:
  • Automated file transfer from AS400 to Word?

    A search400.com reader wrote in with this question: I need to take a spool file (say a Collection Letter) generated from RPGIV. I can copy this spool file to a physical file if needed. I want to automatically import or send this file to Microsoft Word for editing purposes. I have used the 'ADD-INs'...

    AS400 - Ask the Expert485 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