• Macro using Visual Basic

    Using Visual Basic, I need to choose XYZ information in a cell, in Excel, and another cell must give me ABC predetermined information. How should I do that?

    JoyStrassacapa25 pointsBadges:
  • Saving chart colors in excel 2003

    When I set chart colors in an Excel 2003 spreadsheet, save and reopen the spreadsheet, the color reverts to previous colors. I have tried creating a macro but this do not work. Can someone please advise me how to do this task?

    Kattydavis10 pointsBadges:
  • In Excel how to autofill a cell that references a list?

    I have defined a list. Now I am at the drop down on another sheet.  Instead of scrolling to the item in the list...  (a very long list), I would like to be able to start typing a few letters, and the lists shortens to just that initial input.  Much like a combo box can operate in VB.net. Any...

    Rdn5 pointsBadges:
  • vlookup

    how can I convert then match two lists of numbers?   One list has thousands of 7 digit numbers.   The other list is even longer, but contains all of the numbers in the first list, looking at the first 7 digits of each.   The difference is, the numbers have an additional digit on the end.

    Jkg5 pointsBadges:
  • What are Excel internal limit for size and formula complexities/

    MS Excel 2003 and 2007 crash when handling oversized spreadsheets. The RAM memory is 4 gig and has plenty of memory. The machine is running Windows XP Pro. The spreadsheets have many calculations and formulas and have been set to Manual. Also have tried the 'control-end' on each sheet to no avail....

    Gaiusd5 pointsBadges:
  • Excel 03 opens as Read Only always

    We have a user that is only able to open Excel 03 files in Read Only. No other MS Office does this to her. It even happens to Excel files she has created and files that she receives in emails. Any ideas would be helpful since we are at a loss. Windows XP Pro SP2, MS Office w/Outlook 03. Thanks

    Littlejuanito7420 pointsBadges:
  • Problems oprning Excel File

    I have been working with an Excel 2003 workbook since January 2008 and from last week began having difficulty opening the file. Whenever I attempt to open it, I get an error window with the following messages shown in bold below: [Excel found unreadable content in 'filename.xls'. Do you want to...

    EB35 pointsBadges:
  • Excel .xla slow to save

    I have a custom toolbar saved as an .xla.  Works great.  It has always taken about 1 - 2 min. to save the .xla.  But about two weeks ago the save time increased significantly. It now takes over 12 mins. to save.  Any ideas.  I haven't added much in the last month.  Tried rebooting machine. ...

    Smf170 pointsBadges:
  • Error message on startup of Excel 2003 workbook

    Could anyone tell me what the following error message means and how i could fix it? Cannot find XLQUERY.XLA!Register.DClick, which has been assigned to run each time [file name]key is opened. Continuing could cause errors. Cancel opening [file name]key?

    Cjones055 pointsBadges:
  • Excel 2003 Macros with Org Chart Parent

    Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the data below. Thank you. COL  ...

    Vanillathunderrr5 pointsBadges:
  • Oracle Forms 6i – Export to Excel

    Hi All, I have an application on Oracle forms 6i, which is having 1 form to download reports in excel format. It works fine with excel 2003 but when require to work with excel 2010, it doesn't work. Please help me, please send your answer at - sachin81jain@yahoo.com

    Sachinjain5 pointsBadges:
  • Converting Oracle Report 6i into Excel

    the problem is in report the data is correct but when i try to convert into excell the dupicate rows are beuing formesd..i also did a page protect variation but report changes but not the converted file. if i have 50 records on page 1 then in report it shws 50 rows only but in xcel it shows 55 rows...

    Programmerjan35 pointsBadges:
  • Unlocking VBA project using VBA code

    Can i use vba code to unlock my x-cel vba project protected by password? I need to unprotect my project to add some code and then reprotect it.

    Yves69520 pointsBadges:
  • Message Alert Box in Excel 2003

    I have a two files, one is the consolidated time monitoring and the other file is the individual time monitoring. The individual time monitoring file has 30 sheets which is the name of each agent and in shared mode. On that file, agents are responsible to provide/indicate the things that they've...

    Eron09135 pointsBadges:
  • Change fonts in drop down box created with autofilter in Excel 2003

    1. Is there a way to change the font size of the an auto filter drop down box?

    Mmppmm10 pointsBadges:
  • reformatting a multi-tab spreadsheet and access 2003

    Hi,    I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access 2003...

    Cwv19495 pointsBadges:
  • VBA Excel 2003 Copy and Paste

    I would like to know how am i going to copy a certain range (A1:E500) in File A and paste it in a different file (File B). Then copy a new range in other sheet of File A then paste it in File B without overlapping the data I copied from the first range. Thank you so much in advance!

    Eron09135 pointsBadges:
  • Edit-Find Excel 2003

    I prepared an Excel 2003 file containing about 10 spreadsheets for a company whose name appeared in the spreadsheets. The sheets contain confidential information about the company the file was sent to. I now wish to send this file to others having deleted the name of the original company for...

    RobSoros5 pointsBadges:
  • Excel 2007 freeze pane problem

    Dear Sir, Is there any method in Excel 2007 to enabling freeze pane option in protected Sheet of Excel 2003. Regards Furqan Ahmed

    Mobilink115 pointsBadges:
  • Pulling information from one spreadsheet into another spreadsheet.

    We have two spreadsheets created and spreadsheet b has referenced totals from certain columns from spreadsheet a. The problem is that the spreadsheets are maintaned by 2 different people. And throughout the day spreadsheet a gets new information added to it, how can this information be brought into...

    Jacketfan5 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