• Deleting all formulas in a worksheet when unprotected in VBA code

    I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...

    Barnoldswick5 pointsBadges:
  • importing an EXCEL tab

    while importing an EXCEL tab with the import wizard, ACCESS 2003 changes a text field with only numbers that exceeds the long integer format to scientific notation. Is there a possibility the numbers do appear?

    GIT02110 pointsBadges:
  • Macro determining end effective dates

    I am using Excel 2003. I am creating a data-entry spreadsheet that contains supplier costs for components. For each component (Record), it has a begin date for when the price goes into effect and an end date. Since I want a history of this item and the dates that it increased or changed, there will...

    Jhowells285 pointsBadges:
  • Designing a report in SQL from an Excel worksheet

    I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?

    SQL Server Ask the Experts2,585 pointsBadges:
  • External references in excel gives error while mailing

    I had an excel file having external reference. When I email this file to someone else, it shows #REF! in the columns having external reference

    Kapilrewari5 pointsBadges:
  • Convert Number value in text string

    I am using Microsoft Excel 2007.I want automatic conversion of a number value into relative text string.It means if I have "687" into one cell, then it should be converted into "Six hundred and eighty seven" into next cell.Pl. guide me for this.

    Makkes5 pointsBadges:
  • Auto Sort in Excel

    I have the worksheet to Sort in decending order on column L when the workbook is opened. I have a title in Row One, and Header in Row 2, The header in row 2 has autofilter turned on

    FJF5 pointsBadges:
  • Excel – Automatically Publish graphs to Intranet

    I want to publish updated graphs to my intranet automaticlly. ie open excel, refresh data (from as400)then save,publish&close (running from the scheduler ) I have my Downloaded vb express & looked at vb sites etc… & managed to create a project which publishes the page to the intranet correctly...

    Gerrib150 pointsBadges:
  • finding words within other words with an Excel macro

    column B has 2 letter words, the next 3 then 4 and so forth. I am looking to find the words in each column to the right to find all of theentrie that contain it and change the color of only the 2 or 3 or 4... letters in the new word for all words in each of the colomns to the right. Example: AA...

    Brayleen5 pointsBadges:
  • SQL query ORACLE report “Active Users”

    I have problems analysing the standard Oracle report "Active Users". I want to get my users into excel but the report lay out sucks. How can i get this report directly from the database?

    Jkort5 pointsBadges:
  • cell entry that changes

    I am a new user to Excel so this is probably a common problem with an easy answer, but I can't figure it out. When I enter a number (200)in an individual cell and then click on another cell....the number changes (to 220)in the cell I just completed. I try to format the individual "changing" cell...

    Onesoileddove15 pointsBadges:
  • Excel macro

    I would like the user to be able to hover the mouse over a picture which then would enlarge to some defined size and then return when the mouse is moved off of the object.

    JH3935 pointsBadges:
  • Is vlookup the correct formula to use for my task?

    This is the formula that I am trying to write: When the cell row values in columns A and B, are equal to the cell row values in colums E and F are the same, I would like that information to appear side by side in separate colums for comparison. For any company data that does not match with vendor...

    Ginaque5 pointsBadges:
  • Perform equation in field during mail merge

    I am performing a mail merge in a Word document, using an Excel spreadsheet. Some of the fields represent percentages (format=0.45). I don't know how to get the resulting merge to show a percentage as 45% without replacing data in the % columns in excel. Is there a way to take the merge field and...

    Nsorth5 pointsBadges:
  • oracle form:export to excel

    I have an oracle form,i need the code of a function that exports a given SQL query into Excel sheet on a button click action.

    Itbassem5 pointsBadges:
  • Excel Function Help

    I am designing a spreadsheet to keep track of various data. I have a list of birthdays (month and day in separate columns) and I would like to pull the person's name that corresponds to the particular month. I have attempted to us the lookup function for this, but if there is more than one person...

    Trakaszcie5 pointsBadges:
  • Excel Challenge

    Let's say that I have an Excel spreadsheet that contains a long list in column A. How might I go about taking every 40 items in column A and moving it to its own column? For example, A1:A40 remains in column A; A41:80 gets moved to column B and so on. I'm not looking for a thought process but...

    Wrobinson5,625 pointsBadges:
  • Help in creating a macro

    I am creating an associate scorecard. I have an excel file with top two filter, month and the name. Based on the month and associate name, I will pull the performance data (Joining date, emp id, AHT, CSAT etc) for metrics from another excel file using vlookup. (NO WORK is required here) What am I...

    Simmi5 pointsBadges:
  • MS Office Excel 2007 cannot be open by MS Office Excel 2003 (even after installing compatibility pack)

    Cannot open the EXCEL file using MS Office EXCEL 2003 (after installing the Compatibility pack) that was saved by MS Office EXCEL 2007. The error message: This file is not in a recognizable format. If you know the file is from another program which is incompatible with Microsoft Office EXCEL, click...

    Phlim35 pointsBadges:
  • Excel 2007 data – sorting source workbook

    I want to create a link to data in a second workbook. My problem is when the source workbook is sorted, the links are misaligned. I don't think absolute/relative references are the issue. How do I create a link such that no matter where external reference in the source workbook workbook moves to,...

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