I have a following problem:
- Two processes, which are recorded on two different sheets
- Some of the designs need to be worked on once, twice or several times
before they are finished goods.

Here's something weird I can't figure out.  The problem is that I need a cell
to look at >1 dynamic range where the values in those ranges match
dynamic/static values.  The dynamic thing eliminates the D* functions (which
seem to need static values like "Hat" rather than "A1").

How can I set-up a header that will appear on all the worksheets in a file

I need to create a macro so that when I select a cell and apply the macro it
will tab diliminate the contents, and arrange them in a B3, B4, B5 order as
oppose to a B3, C3, D3 order.
I can't figure out how to make it go down the column and not accross the row.

Please help, I am attempting to create a lottery information,
generator and check sheet in Excel and have hit a wall. I need to copy
the values of some cells over to another part of the spreadsheet and
then have them compare with another set of data that holds the past

I want to design a connection which will navigate a user from a contents page
to specific worksheets to input into fields

I could use a little help getting around the error I am getting when
trying to hide a combobox with a checkbox.  Basically, what I am trying
to do is unhide/hide rows and the rows have comboboxes in them.  If I
choose a checkbox, and still have the focus set in the combobox I am

I made this macro and it works (see: Sub eentjestest()). If there's a
cell that has no color, the cell value will be 1. But I also want to
query on borders, so if the cell has borders then the cell must get the
value 1. Does anybody know how to solve this?

I import text from various data sources. Is there a function (or if anyone
has a macro) that will allow me to search the worksheet/workbook for a
specific text and print the number of times that text appears? The text may
not necessarily be in the same location at all times. It ...

Good morning
I have a worksheet with data in column A, column B and a date in column C.
In column D, I have to enter a formula which will automatically enter all
the information from the cells in A, B and C into one cell.  For instance, A1

I'm using a worksheet where I have 7 columns, of the 7, six of the columns
have scores where I'm using the formula =sum(a1:j1)-max(a1:j1)-min(a1:j1) to
eliminate the high and low and put the total of the remaining four in the 7th
column.  My question is, how can I format the ...

i need some help with deleting Rows in excel using a do loop
my program looks like this
Sub Cleanup()
Dim r1 As Range

How can you use colors as a result in a formula, i.e. color a cell red when
30 days from due date, color green when task accomplished.

The the Guru's:
What I need is to create a cross section using a sort of HLookUp and VLookUp
function. HLookUp to find a Employee name on a specific row in column "A",
then use the VLookUp to pick up specific data for the employee four (5) rows

I am creating summary reports that compare one financial period to another.  
The Budget, Prior Period and Current year are in tables and there is a column
for each month.  To do this I currently have the below if statement where I
am pulling in the months sales from the table.  ...