I have worksheet that has certain information about our manufacturing operation. I have another worksheet where I would like to extract certain data from the...

Hi everyone, I posted a similar question the other day and it was answered, but now my formula is getting more complicated and no amount of playing around...

We have several different logos for each of our companies. Based on which plant is selected from a pull down table, I would like to have that logo...

S.O.S, help needed badly…the following macro: For Each Worksheet In ActiveWorkbook.Worksheets i = i + 1 If i ActiveWorkbook.Worksheets.Count Then...

I am doing a spreadsheet where in one column (column A) has a heading and I need to split it into 3 thinner columns with their own names. How do I do this?

Hi! I'm totally new to macros and I don't get checkboxes to work at all.. What I'm trying to do is add a checkbox(actually multiple checkboxes) and have...

Is it possible to hide everything that's "not" currently selected? Lets say: "Top rows of a table, and rows 25 through 50", for instance would remain visible. ...

Hey everyone: using Excel 2000. I have a spreadsheet like such (each # is in a different cell), starting on A1: 1 2 3 4 1 5 6 3 2 7 4 3 1...

I use a Vista computer with Excel. Most of my worksheets are in compatability mode. I have a few documents that require landscape page orientation and I've...

I am trying to copying a range of cells eg. 10 rows/1 column down repeatedly on the same spreadsheet about 50 times. Is there a macro I can use to caopy the...

Morning all. I have a speadsheet with data on it, and I'm setting it up to place in a database (DB)-- I've removed all of the formatting, etc... just leaving...

=MAX(IF((Data!A2:A2500=2008)*(Data!G2:G2500="U & E"),Data!C2:C2500)) I would like to add a filter (Data!A2:A2500=2008)*(Data!G2:G2500="U & E") and...

I have a worksheet with several tables within a sheet. Each table is dependent on responses from the previous table and new data received. One of the...

Hello Friends, Thanks to everybody for your continued help and guidance. I tried to find this particular problem in the group but could not find it so far. It...

Here is the formula I am trying to make work: =IF(B14+B1525,1,IF(B14+B15=2540,2,IF(B14+B15=4075,3,IF(B14+B15=75,5)))) B14 and B15 values change, and I...

if((X)*(Y),A,B); what is the role of *.

Hi all, I have a work book that contains contact names and email addresses on one sheet. Clicking on the cell containing the email address will then open a...

Oops, my bad, ignore that. -- __________________________________ HTH Bob "Bob Phillips" wrote in message news:... ...

I have inherited a spreadsheet with a formula that does not work. Instead of returning the earliest order date it returns the first order date. I would like...