• 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:
  • How to use Excel to manage inventory

    I'm using an Excel workbook to manage a fulfillment inventory. It contains three worksheets. Worksheet 1 includes the current inventory of all the products available for fulfillment. Worksheet 3 contains a list of the packing lists and quantity of the products (by part number) that were sent out...

    Horqua5 pointsBadges:
  • Problems with tranferring flat file from mainframe to Outlook as CSV file

    I am trying to e-mail a plain text comma delimited flat file from the mainfram to Outlook. I have the coding working to transfer the file but when the file arrives in outlook the first character on each line is an '&'. When EXCEL trys to open the file it generates an error message that this is an...

    Rickb19745 pointsBadges:
  • Excel Form Macro

    Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...

    Dinosaur995 pointsBadges:
  • Copy and paste in Excel using Visual Basic scripting?

    First of all - Thank you.... I receive info in Excel worksheet "A" with columns of variable length which I want to cut and paste into Excel worksheet "B". Worksheet "A" info starts at B:13 and can range in length from 1 to 200 rows or more. I would like to copy this variable length information then...

    Bmac5 pointsBadges:
  • EXCEL find-copy-paste

    Hello! Using VBA for first time, so everything is toughed for me.. The problem is: we need to find on the first sheet named SD in second column all cells contianing word 'drilling', then for each cell copy row which contains that cell and paste it in other sheet or book (doesn't matter). Please...

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