I have a large number of dde link address that I am inputting which need the
address to increment sequentially.  I can't get Excel to increment the
address.  And, I don't want to type them all in.  I found if I remove the =
mark at the beginning of the dde link, Excel will ...

The title bar on a work sheet is missing the maximize, minimize and close
options. I cannot drag the worksheet or maximize it in any way.
I have a screen shot i can email if the description is insuffient.
Has anyone seen this before, and is there a way to fix it?

I have a long list of data (2000+ rows) where I need to insert a blank row
between each line. Is there an easy way to do this so it affects the entire
sheet? Thanks

how do i get this logic to work.  if x>30 and ends with .00 then (basically i
want it to give me the result of 24.00 etc but not 24.21

Experts,
I need to copy data from once excel file to other based on string
comparison.  For example consider two workboooks.
1. Source file

I have to incorporate this in a IF statement or whatever is simple. Does
anybody have a simple solution for this?
Cell A1 can have 5 values A,B,C,D or E
Cell B2 can have 5 values V, W, X, Y or Z

I have a huge series of Surveying shots (P,N,E,Z,D) and I would liket o pull
every tenth shot out and into a separate sheet. Any advice?

I am looking ahead to the day I will have reached my network drive allowed
capacity, and forced to offload all my data to a removable disk (CD or DVD).
Trouble is, my Excel files contain external references to files (mostly text
& other Excel files) on the network drive .  When I ...

Links: I would like to link from an excel-sourced pdf to a section with a
word-sourced pdf. I had assumed that the standard excel interdocument linking
command would work from the excel source to a Word bookmark target:

I have a formula that won't let me enter in any more if statements. Can you
help
This is what I have:
=IF(D19=P7,V7,IF(D19=P8,V8,IF(D19=P9,V9,IF(D19=P10,V10,""))))

Not sure if this is the function for the job but I need to have SUMIF
compare values in multiple ranges/columns and add if the values match
in those columns
e.g.

I have a workbook with a time sheet for each team member by month.  Each
sheet contains two columns where the team member will:
Choose a Task = Column A6:A100 (multiple tasks within one sheet)
Choose a Subtask = Column B6:B100 (multiple sub-tasks within one sheet)

Let me see if I can explain this,,,,,I want to
count the number of orders that show as SHIP but I only want to count them
once if the order number in column A appears more than once...... so I want
to be able to count the number of SHIPS in column B but only count them once

Is there a shortcut to removing the hyperlinks in a column so that there is
only text?

Alright, I have a user form that I have been building and it has the
following code within..
Private Sub UserForm_Initialize()
cboName.Value = ""