• Duplicate data in Excel sheet

    Hi all, I have made an excel sheet and in one column I have data (DB table column names). I want to see if duplicate data exists or not. If there is then rectify it. I am using Excel 2003. I also have searched around net but yet I didn't find any useful answer.  Thanks,

    hunshabbir71,945 pointsBadges:
  • Excel 2003 – Conditional Formatting Help

    Hi, I am working with a tracking schedule for my job, and I am trying to implement conditional 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:
  • How can I transfer more than 16384 records into Excel 2003

    Hi All, I am trying to transfer a table with more than 20,000 records from Access 2003 to Excel 2003, The code I'm using within VB goes like this: Private Sub Allstock_excel_Click() Dim filename As String filename = "D:\Automotive_Rapore\Archives\AllstockReport\Allstock_" & Format(Now,...

    Kentster5 pointsBadges:
  • Excel question

    I have made some forms to use as proposals to sent to customers. I want to be able to send these as a document and not a spreadsheet. I need the formulas in the spreadsheet however to complete the proposal on my end. The pages print ok but I don't want to send an entire spreadsheet. Can this be...

    Alexworley5 pointsBadges:
  • coloring rows “if” true

    I have a profit & loss spreadsheet that I use to input expected expenses and then log the invoices when they are paid and I always highlight the row when I input the invoice number and invoice amount. Is there a way I can use conditional formatting or a function to automatically color the row if...

    Tstychalski5 pointsBadges:
  • 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:
  • 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:
  • 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:
  • 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:
  • 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:
  • 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 2003 docs now won’t open in Excel 2007

    I created som docs using Excel 2003. New computer has Excel 2007 installed and now when I open the docs they are unreadable. Any help would be appreciated.

    Anniedun5 pointsBadges:
  • How to repair corrupt MS Excel 2003 (XLS) File?

    I have important MS Excel file data and unfortunately got corrupt due to virus attacks, so my crucial Excel sheet got lost, how to repair corrupt MS Excel 2003 (XLS) File? If have any solution please assist me.

    henrychandler5 pointsBadges:
  • vlookup in Excel 2007 to 2003

    Is it possible to vlookup in 2007 excel file to 2003 excel file

    Suresh123455 pointsBadges:
  • Qmf for Windows 8.1 fp18 – date datatype from db2 z/os 8 format error in excel 2003

    When I import a DB2 z/OS query result  containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example...

    Erredi5 pointsBadges:
  • Automatic date

    How can you set up a cell to activate the current time when another cell has data entered into it? Just want to track what time DATA was entered in the other cell.

    Bispo120 pointsBadges:
  • EXCEL 2003 and VLOOKUP help in calculating percentage in third cell

    Hi all, I have three cells in an Excel 2003 worksheet. Cell one is a drop down list containing: 01/07/2009 – 30/06/2010 01/01/2009 – 31/12/2009 Cell 2 is a dollar amount which is manually entered Cell 3 will calculate a dollar percentage of Cell 2 dependent on which date range is chosen in Cell...

    Ianmax4975 pointsBadges:
  • Created Public Folders for Excel spreadsheets

    I have created a public folder to store Excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes. Will all changes be saved?

    Chenzo5 pointsBadges:
  • Transfer of data from AS/400 DDS Described file to Excel spreadsheet

    I have a critical problem in AS/400 data fetch query in MS Excel (Petch SP2 loaded). I have created several Excel Sheets (in MS Office 2003) for fetching the data from AS400 using MS Office Query option under Data-->> Refresh Menu. Those excel sheets are using by so many different users on...

    Skm200520 pointsBadges:
  • Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?

    Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...

    Kaylee5 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