• 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:
  • Excel 2002

    I can open an excel doc, but can not add anything to it without inserting my 25 digit product key, which I do, but says it is the wrong key. It is a Publisher 2002 version, operating on a Windows Vista any suggestions?

    Sprinkleclan55 pointsBadges:
  • Crystal Reports 9 export to Excel

    i am using crystal repo 7 with VB and exporting to excel its ok for layout but after crystal 9 version its export property change how to keep contant or same as 7 version

    17132220 pointsBadges:
  • File Name question

    I have a macro I use to pull data from 2 worksheets. the problem I have is that everytime I run this macro it is on 2 diff files and the file names are diff than when I originally created the macro & my macro keeps crapping out because it is looking for the original file name I used. is it possible...

    Estan125 pointsBadges:
  • linking cells

    I have an Excel spreadsheet that has 350 rows with 31 columns of information and I need to print each row separately. I only need the information from 23 of the columns to be printed on each page. I created a new spreadsheet listing the 23 column names and then in the cell underneath it, I linked...

    Teicneoir220 pointsBadges:
  • Saving Query results into Excel format

    How can I save query results into .xls format directly from Microsoft SQL server Management studio?

    Preetg5 pointsBadges:
  • Export from Access to Excel shifts decimal position randomly

    I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one...

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