• vlookup in Excel 2007 to 2003

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

    Suresh123455 pointsBadges:
  • Password remover for Excel 2007

    I have forgotten my password for my imp Excel sheet. How would I recover that Excel sheet now?

    Gvk5 pointsBadges:
  • Macro to breakout data into separate tabs

    I have a weekly report that holds line item detail for seven different account numbers. The data is going to vary from week to week and I need vba code that will separate the data by account number into different tabs. Any tips on how to write the code? RWC

    HNAvigator20095 pointsBadges:
  • SUM and IF formula

    Using Sum on a column of currency of 2 decimal positions. Using IF to compare that Sum total to another total. To my knowledge, all cells are defined a 2 decimal postions. Some value entries result in the Sum total having a "1" in the 10 decimal position and some value entries do not result in the...

    LASloan5 pointsBadges:
  • VB6 App with hardcoded SQL to access a Access 2007 DB

    Hi Team, I have a query that I run successfully in native SQL within Access 2007 but if I use this code within VB6 it seems as though it is not using the "From" & "To" dates. It does return values but it amounts to the complete database totals. The extra code added to the production code was...

    Witsend5 pointsBadges:
  • Excel 2007 – how to add a average formula to that cell/s that ignoring 0%’s

    Okay I figured out how to ignore zero %'s for a graph. Now what I'm stuck on is how to add a average formula to that cell/s This is what I had: =IF(SUM(U171,U122,U74,U27)=0,#N/A,(SUM(U171,U122,U74,U27),(AVERAGE(U171,U122,U74,U27)) Thanks,Jared

    Jreifenstein001185 pointsBadges:
  • Excel assigning values to lists

    I have to assign dollar values to each of these job functions. All the values are $100.00 for each function except for Administrative which is 0. The functions are: Administrative, Draft, Revise, Review, Research, Conference, Telephone Conference. I have put them in a drop down menu. How do I...

    pathetic335 pointsBadges:
  • How to fit a lot of text into a cell in Excel 2007?

    Is there a way to add a large amount of text into a cell in Excel 2007? I need to add 1,941 words (10,460 characters) into a single cell in Excel. The cell is set to the maximums of 255 column width and a row height of 409.5, but I still can’t place all of the text within the cell – this with...

    ITKE344,825 pointsBadges:
  • Imbed and Link External Excel Spreadsheet into Visio

    Looking to utilize an external spreadsheet which maintains various information pertaining to our move from one data center to another. Items included are ip address, rack, U, hostname. The question is I want to utilize this spreadsheet as my source. Then within my Visio, I have tabs for each Rack....

    Aguacer08,135 pointsBadges:
  • VLOOKUP in Excel 2007

    I have 2 columns on an excel spread sheet with the following formula; VLOOKUP(D2,$A$2:$B$2090,2,FALSE) if I copy from column one cell A(2thur209) it produces the corresponding name in column B, but if I type the same name it produces #N/A. What is the problem?

    Newkid4735 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:
  • Excel 2007 – gauge, speedometer, or dial charts

    Hi, Does anyone have any idea were I could find some some sample templates on these 3 for: Excel 2007 - gauge, speedometer, or dial charts. Thanks Jared~

    Jreifenstein001185 pointsBadges:
  • Combo box in Microsoft Excel

    How do I link numeric values to word choices in my combo box? I have tried If Then's for if you pick a certain choice it = a certain number, but I'm stuck! Thanks.

    Toriel5 pointsBadges:
  • SAP export to Excel 2007

    When exporting a spreadsheet to Excel 2007, currencies show in the wrong format (ie. 1,882,456.96 shows as 1882456:96). I've tried to format the cell but this does nothing. Also I've verified switching the regional settings but no luck there neither. Help will be truly appreciated, Max.

    Duscher5 pointsBadges:
  • Unable to run macro in Microsoft Excel 2007

    I'm unable to run any macros stored in this workbook but macros stored in the personal file will run. What should I do?

    Rich6245 pointsBadges:
  • Excel Macro Help – .ThemeColor = xlThemeColorDark1

    The spreadsheet I'm working on pulls data from an oracle database and automatically populates cells for which there is no data with "999999." I am attempting to use an excel macro to essentially gray-out all cells that contain this value with the intention of saving users the time it takes to apply...

    Jwahl5 pointsBadges:
  • How to connect to quick 3270 secure screen through VBA macro?

    Hi, I use the following code to connect to quick 3270 macro and it also connect to the screen. But when I run the macro for the first time it works, but does not work when I run the same macro for second time. If I restart the mainframe then the macro runs. Below is the code. Sub getdata() Set...

    Anirudha0075 pointsBadges:
  • Disable saving in Excel 2007

    Hi, I need to get rid of the save option. I only want the sheet able save when the document is closed and it asks if you want to save. I do not want the document to be saved any other time. Here is my document (Office 2007 Only). http://www.savefile.com/files/1848919 It has been made to book out...

    Juel35 pointsBadges:
  • How do I associate an employee # to a name in Excel 2007?

    I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell. Ex: Column A=Employee#, Column B=Employee's name. I want to type in the employee's # in cell A1...

    Weazel5830 pointsBadges:
  • Excel 2007 – How do I ignore zero’s and #DIV/0! for a graph?

    Excel 2007 - How do I ignore zero's and #DIV/0! for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% #DIV/0! 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% On the graph all u will see is the plots from week 1 & 2....

    Jreifenstein001185 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