I am trying to hide rows 127 - 216 on sheet2 if cell J13 on sheet1 does
not say "Combo"
I need to do this because all the data in this area only shows up if
"combo" is selected and when I print a report pages 4 and 5 are blank.

In workbook A, I want to have a cell filled with the name of a second .xls
file (which may change) and then access cells in workbook B from the original
workbook A.  

We have problem with a spreadsheet where we use VBA to move inputed data in
cells within a column to
a row. The inputed data looks like, 0,3446325533953 and
0,45324657652432 etc, when moved to the assigned row it only have 3

Excel 2003 has just been installed on my computer and I was trying to use the
advanced filter feature prior to creating a pivot table fromt he filtered
data.  The problem is that advanced filter does not seem to be working at
all.  The list is not filtered based on the criteria.  ...

hi members
how can I insert rows after every fiftth row I have data of more than
6000 rows that means I want to insert 1200 rows in that sequenc
--

I want to fill/copy a formula within a specific range but each time I try to
fill or sopy it changes the range it is supposed to looking in so I am
getting errors.
For example,

I need help with the following "IF" Statement
If cellA IS between 3,000 & 5,000 multiply by 20%

Hi all, I have a cell that NEEDS to be of the following format:
0#### ######
I have set this up under formatting, custom... and when I type a number
like this...

I have data in the following format:
Name           Date           Amount
Johnson       6/1/06         $100
Johnson       6/6/06         $300

Have a worksheet in which I need to know the largest size item in each
column, text coulmns only.

Hi all,
Have an issue.... I have a spreadsheet that on running a macro opens a
word document and fills in bookmarks with info from cells. But if the
buuton is clicked when a cell is empty the I want the macro to abort

Hi, new to the forum, hope you peeps can help me!?
I have a CSV file of user data relating to session times on a server.
The columns are as follows: username, uniqueID, loginTime, logoutTime.
What I want to be able to do is calculate for each user:

I have a problem with data validation. My validation is dependant on two
seperate cells. I have created two lists, the first is a list of beam types,
the second is a list of beam sizes. Now what i want to be able to do is allow
the user to select a beam type and then select a ...

I inherited a spreadsheet that uses whether or not a cell is boldfaced to
tell the reader something.  I need to create mailing labels that only
reference the boldfaced cells.  Is that possible?  Or should I take the time
to redesign the project?

I've to do Lookup for a range of values. These values are stored in different
files, which are stored in a cell for that row. So, I need VLOOKUP to pick
the value of the Table_Array from the cell instead of it being fixed.
Thanks