I have limited Excel experience so I need some help. A friend of mine wants me to create a form
using Excel. He is a horse trainer. To simplify things, I want to create a main form that would
include fields for Horse's name, Owner(s) names and contact info, Vet, Races, etc. I can ...

I use an Access dtabase with a reporting feature. I can export to Excell from
Access. I have created the template that I wish to use, but when I try to
export to excell I do not see the xlt. only the xls.
Do I also need to create a function in the Access database to download what ...

Let us say we have data stored vertically in a column ($A2:$A6). Now
is there a feature by which I can transpose that data into a single
row; meaning get data in a row like A$2:E$2?
--deostroll

Using a macro to update values that changed;
In a workbook (PRICELIST) I keep multiple sets of three columns holding data;
Interesting now is the second and third column which hold product and price.
A separate workbook (PRODUCT MANAGMENT) holds the products and prices for

I have an excel sheet with data in which parties ID in column 'C' and
amount, date and other columns etc.
I want a macro solution which would 'generate partywise breakup' in
'sub-total' like format in another single sheet, datewise ascending

How can create an absolute reference on a group of cells

I'm new to the VBA side of Excel.  Is there an Event built in for something
like AfterDataRefresh, or AfterSQL call or something?  I still haven't
figured out the best way to find everything available.
thx - Russ

I have xl 2003 and my simple xsheet opens with a message that it has a link.  
I do Edit Link, Break Links, and it flat doesn't work.  It won't break.  I've
tried using MS Delete Links add-in and that doesn't work either.  Any
suggestions?

I am using Office XP's Excel and this is probably a stupid question but
I cannot find the answer on my own.
I am creating a line chart from data in Excel where the X axis is a
series of dates.  Yet using the Chart Wizard all I can get the X to show

I would like to run a macro that replaces all text that is not 'member' or
'centre' or 'customer support' with 'other'. Can someone please help? I could
do a search and replace, however there are about 20 other options that it
would be a long macro, and I imagine it would be ...

Dear users,
I have already a macro running for activecell actvated by ctrl + f. To
ensure my colleagues, that the macro did its job, I would like to
change the color of the cell for 1 or 2 seconds. Can anybody assists?

Below is my macro that works 'perfectly', cross-platform on both Windows
Excel97 and Mac OS 9, Excel 98, except...
My problem is that I am using '6 edited individual macros', rather than just
'a single macro' for 6 workbooks that call the macro.

I'd like to prevent a user from entering commas in any of the cells of
a spreadsheet. Is this possible?
Thanks.

In Excel2002 or newer versions
Is it possible to have destination cells to respect/follow the format of
referenced cells?
If yes HOW? If no WHY?

Hi, I'm having a really annoying problem. When I create autoshapes in
Excel 2002 (XP), when I scroll down the page, and then back up, the
colour is distorted and ruined to look at.
It prints fine, but it is very annoying, and bad to look at. It's like