• Excel VBA – Cell value not being displayed

    when i display all the values there is a cell that dosnt display it's result,but when u put the mouse on it in the comment box it appears

    Skh805 pointsBadges:
  • Importing to Excel one record appear on more than one line..

    I am using crystal reports to make an excel file. I have different information for several people that needs to be put on this file. Each persons information needs to appear on one row instead of multiple rows. How do I manipulate crystal reports to show this information correctly?

    Action205 pointsBadges:
  • VBA format a cell based on range contents

    I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. 'assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As Worksheet Set wsOT = _...

    VbaNewb1315 pointsBadges:
  • Raw Data not in Pivot

    I have a large pivot table looking to a raw data worksheet. All the data in raw data is not showing in the pivot table.

    Ttucker10 pointsBadges:
  • Conditional formatting in Microsoft Excel 2003

    Basically I have 2 columns the first column has years in it & the second has random letters. Now, going down the 1st column it reads: 2007,2007,2007,2007,2007,2008,2008,2008,2009,2009,2009,2009 And going down the Second Column it reads: A,B,A,B,B,B,A,B,A,A,A,B Note: This is just a segment of the...

    Bmutton5 pointsBadges:
  • How to insert symbols in AS/400

    In Excel , when we try Insert->Symbol there appears a dialog box where it has all the funny symbols and one of our users requested a symbol which has a A and a bar on top of it(Latin Capital letter A with Macron) on iSeries which i fancied is not possible . Please could some one suggest if its...

    harisudhan211,005 pointsBadges:
  • Extracting max value from 3 columns of data in exel

    My warehouse system contains length, width, and height calculations but the longest side isn't always in the correct column (length). Does anyone know how to extract the max, median, and miminum measurement across 3 columns of data?

    JTWSGC5 pointsBadges:
  • Macro to Open Crystal Reports

    I have an excel spreadsheet that I've used to create a crystal report. The excel file has multiple employee id's on it. The crystal report has a parameter that uses the employee id to only show that employee's information. I'm trying to set up a macro to loop through the employee ID column, pass...

    Craigins665 pointsBadges:
  • Can you view an older version of a spreadsheet?

    I accidentally saved a new spreadsheet over an existing spreadsheet, and I was wondering if there was a way to view an old version or retrieve the version I saved over. I'm panicking!!

    Bluebloomie5 pointsBadges:
  • Excel 2007 – How do I ignore zero %’s for a graph?

    Excel 2007 - How do I ignore zero %'s for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 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. But then you will...

    Jreifenstein001185 pointsBadges:
  • Microsoft Excel macro to access other applications

    Hi, Could you please help me to get informations from other applications to excel using macros?

    Karthik123455 pointsBadges:
  • Share Utility Records?

    I maintain utility records for several different buildings. I would like to share individual records with their supervisor. Presently, the records are stored on one excel page. I can't seem to divide up that one page into an email for each account. What would be the best program to use to store...

    OBI Girl85 pointsBadges:
  • convertion of excel into report generating tool

    how to convert excel sheet into oracle report generating tool

    Ar5 pointsBadges:
  • Microsoft Excel to VBA

    We are working on a spreadsheet that we need to run with VBA. I need a field to hold "". when running it in VBA it gives me 4 to 8 "". How do I get it to just give me 2 ""?

    Chilipepperz35 pointsBadges:
  • ComboBox in Microsoft Excel VBA

    HOW TO RUN A MACRO WHEN SAME VALUE IS SELECTED IN THE COMBO BOX IN EXCEL VB?

    Narmadha5 pointsBadges:
  • Picking values in the intersection of row and column values

    In row 1(column 2-column11) i have location"<NAMES>"(all different) and in cloumn1 i have customer codes, and the values at an intersection of particular customer code & location are hard coded. I m giving the picking values for customer codes and locations from user defined data. The problem...

    Gahlan5 pointsBadges:
  • VBA EXCEL 2003 table coding

    Trying to write VBA code taking daily averages from datalogger (144 values/day). Its placing the averages every 144 lines apart in excel sheet. Looking for coding to condense averages into table.

    Bellyflop5 pointsBadges:
  • Excel custom format, weekday & date line break query….

    I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is nessacery for this data to be...

    Dangerchef35 pointsBadges:
  • How to Create “Are you sure you want to ….” MsgBox

    I am creating a userform at the bottom of which there are various commands including "Save". When you click on this I ahve written in a series of checks to make sure that all the fields are filled in correctly but after that I want an "Are you sure you want to save" box with the options Yes and...

    Dontgetit105 pointsBadges:
  • vba recorder issue

    When I run excel 2007 and try to record a macro, it will not record any commands for inserting a wordart or editting the text of the wordart if one is already created on the spreadsheet. I am at a loss to determine the right commands without the recorder, and I can't figure out why it will record...

    Lostinspace20005 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