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

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

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

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

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

Microsoft Excel macro to access other applications

Hi, Could you please help me to get informations from other applications to excel using 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...

convertion of excel into report generating tool

how to convert excel sheet into oracle report generating tool

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 1st date?

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

ComboBox in Microsoft Excel VBA

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

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 go through tab one and...

Export Crystal Reports to Microsoft Excel format

how can I export crystal report to an excel file

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.

How do I change a single cell size in a spreadsheet

I have a spreadsheet and i have set column widths. I would like to change one cell in that spreadsheet without changing the width of all of the rest of the sheet. Is this possible? Also, is there a way to set the page sizes seperately i.e. page 1 legal, page 2 letter

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 ""?

Excel Macro to extract substrings from a comma-separated string.

How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

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

Horizontal to vertical

how do you change a horizontal excel 2003 spreadsheet with qty breaks to a vertical speadsheet with quantitiy break or is there a marco

EXCEL 2003 - CONDITIONAL FORMATTING

Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column L = Start Date Column W = Due Date...