When I set up a short cut key (ctrl+r) of macro at workstation A it works,
but when I do another macro at another workstation (say workstation B) with
the same short cut key (ctrl+r), and I copy the content of macro from
workstation B, then paste to workstation A; the short cut ...

I have a large spreadsheet of Names, addesses,etc. I have seen many
duplicate entries fo some reason.
I would  like to know if there is a way to find the duplicates quickly
either highlighted or in color preferably.

How do I load a formula into a column from a macro?
I tried:
ActiveSheet.Cells(6, 6) = "=SUM(H:H)"
But it doesn't work.....

Is there a way to (data) sort columns so that multiple values are recognized?
I have a column labeled lawsuit type where I classify cases (.i.e. fraud,
discrimination).  Some lawsuits fall into multiples categories (both fraud
and discrimination).  Right now it's just sorting in ...

Hi everyone,
I have an invoice as one sheet and an inventory list as another sheet in the
same workbook. I would like to be able to select items from the inventory
list  and have that info. (about 3 columns from 8) sent directly to the

Is there a way to set a reminder so when a date in the spreadshee
column is a week old it will notify me
--
EmpireNikk

Is it possible to auto filter data, and use it as input to a Pivot
table?  When I run a test where I first auto filter, I initially had
20000 rows, and the auto filter reduced it to 12000 rows.  But when I
go to crearte a pivot table on the filtered data, I am back to a total

I gotta say that I am profoundly disappointed with Office 2007. I'm still
trying to understand the ribbon... (it seems to basically be just an
"exploded" menu bar)... but in essense, this is nowhere near the
revolutionary release MS marketing is contending.

Morning all,
Hope someone can help me out with this.  I'm looking to make a type of
report but I dont know what it would be called.
Basically, I want to have a master page with about 5 categories, when

This might be a stupid question but...
How do i remove redundant or incoorect data?
Also to find trends would you use charts or somthing else?

Good Morning,
I have an Excell workbook that other individuals access and they need to put
a response at the bottom.  However, when they attempt to copy their response
from a word document, it either won't accept it as the cells aren't the same,

I am working on a excel spreadsheet. It contains text dat and numeric
data. what I am looking for is that I need to convert that numeric data
into 0. I mean there are cells which contains values like 234, 22, 12
etc and they blank cells in between them. So is there a way by writing

I want to automatically calculate a difference from and average. However when
the average changes, I don't want the previously calcuated differences to
change. Is there anyway to accomplish this?
For Example:

I have the following formula:
=IF(VLOOKUP(A2,HUB.xls!interserve,2,FALSE),(VLOOKUP(A2,HUB.xls!interserve,24,FALSE)-14),"")
What I'm trying to do is run a VLOOKUP in the file HUB.xls first looks
for a specific ID number. If this ID number is there, I then want Excel

I would like to load an Excel spreadsheet directly into a single table in
Oracle. Both the spreadsheet and the table have the same ordering of columns
and have compatable data.
I am aware that a way to achieve this would be to convert the .xls file into