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 [...]

Answer Question   |  May 20, 2009  5:11 AM
*RANGE, Conditional formatting, Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications

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 data table. What i need is formula that will answer the [...]

Answer Question   |  May 13, 2009  6:59 AM
Conditional formatting, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2003 formulas

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.

Answer Question   |  May 18, 2009  5:51 PM
Microsoft Excel, Pivot tables

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?

Answer Question   |  May 11, 2009  3:27 PM
Excel functions, Microsoft Excel

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 [...]

Answer Question   |  May 12, 2009  11:10 AM
Accented characters, AS/400, Diacritic, Diacritical mark, Microsoft Excel

How can I export data from mainframe to Excel in REXX
i want to export data in PS to excel through rexx code.As i am a beginner in REXX .can any one help me in this .

Answer Question   |  August 12, 2011  6:13 AM
Mainframe, Microsoft Excel, Microsoft Excel import/export, REXX, REXX Procedure, REXX procedure to export data to Excel

Wildcard Characters
I have a formula to search for a code and return results. The problem is that within the code there are wildcard characters. How do I make wildcard characters searchable text?

Answer Question   |  May 8, 2009  2:15 PM
Excel 2007, Microsoft Excel

Object Library Error
I keep getting this error when exporting Crystal Reports Ver. 10.0 to MS Excel 2003: Object Library invalid or contains references to object definitions that could not be found. Can this be fixed?

Answer Question   |  May 15, 2009  3:50 PM
Crystal Reports, Crystal Reports 10, Crystal Reports error messages, Crystal Reports Export, Excel 2003, Microsoft Excel

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 one [...]

Answer Question   |  May 4, 2009  2:27 PM
Crystal Reports, Excel macros, Microsoft Excel

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!!

Answer Question   |  April 30, 2009  5:31 PM
Excel workbooks, Microsoft Excel

Excel 2007 – how to add a average formula to that cell/s that ignoring 0%’s
Ok 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)) Thx Jared

Answer Question   |  May 14, 2009  5:19 PM
Excel 2007, Excel formulas, Microsoft Excel

Excel 2007 Large file issues
I use Excel 2007 to do a fairly large multidepartmental Financial forecast and results package. The file size is currently at 48,000 KB and will continue to grow. I have this file open along with others of its size at the same time during use. Frequently Excel will crash during an autosave, when creating a [...]

Answer Question   |  March 23, 2010  3:38 PM
Excel 2007, Microsoft Excel

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 [...]

Answer Question   |  April 29, 2009  6:49 PM
Excel 2007, Excel formulas, Microsoft Excel

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

Answer Question   |  April 28, 2009  8:38 AM
Exchange 2000, Microsoft Excel, Microsoft Excel import/export, Microsoft Excel macros

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 individual building stats [...]

Answer Question   |  April 28, 2009  6:47 PM
Data management and storage, Excel worksheets, Microsoft Excel

convertion of excel into report generating tool
how to convert excel sheet into oracle report generating tool

Answer Question   |  April 24, 2009  8:00 AM
Microsoft Excel, Oracle Reports

Excel Calendars
I have a schedule and would like to put the current months calendar as well as next months with cells that I can add info to for each day. Currently someone has to update the dates from month to month. Is there a way to have the calender update by just changing the Month and [...]

Answer Question   |  April 23, 2009  5:58 PM
Excel 2007, Excel Calendars, Microsoft Excel

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 is how to get the Values lying in [...]

Answer Question   |  April 23, 2009  4:40 AM
Microsoft Excel, Microsoft Excel macros, VBA, Visual Basic for Applications

ComboBox in Microsoft Excel VBA
HOW TO RUN A MACRO WHEN SAME VALUE IS SELECTED IN THE COMBO BOX IN EXCEL VB?

Answer Question   |  April 24, 2009  8:16 AM
ComboBox, Microsoft Excel, Microsoft Excel ComboBox, Microsoft Excel macros, VBA, Visual Basic for Applications

Creating a list in one Excel cell by referencing several other cells
Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would [...]

Answer Question   |  June 9, 2009  2:46 AM
Concatenate, Microsoft Excel, Microsoft Excel formulas