Can anyone tell me how to create a list of the common items that are
contained in 4 different columns?
For example:
I would like this:

I have created an inventory table with about 500 rows (one per item).  Now, I
need to add five blank rows after each already entered row.  These 5 new rows
contain a formula that is constant throughout the whole thing.  Is there a
way to do this without manually adding them one ...

Excel file: http://www.twenty5online.com/Help.xls
I'm trying to help my supervisor out with a spreadsheet he's creating.
Basically, what he wants to be able to do is this:
1. Have Excel automatically highlight the yellow cells dynamically from the

I have a workbook of about 11 sheets.
Normally, 2 of the sheets are open at a time - they pull in price and other
data from 5 other sheets that are normally hidden.
If a sheet is normally hidden, is it possible to hyperlink a button that

hi
The below code shows an error in the second line . if give
sheet1.Range("C10").select its working fine but i want to populate the
i value from C1 to C100 cells.

i have a huge two column data, sample of it is:
name date
1 01-SEP-58
3 01-OCT-58

I have a datafeed that comes everyday via email , every day the
feed has slighty different rows,  as it has different updated products
i.e. somedays 999 , 1001 etc.  I need to  run a macro so when
the excel file arrives to count the number of rows and then add the

Morning all
I'm sure there's a simple answer to this but I haven't found it yet.
I have a column (A) of "Total minutes" in time format "hh:mm:ss" and
"cost per minute" column (C) in currency format e.g. €0.30.  All I wan

Hi, first time poster.
What I am trying to do is roll up 4 tabs in a workbook to one tab
consolidated.  The problem is that I have to roll them up in a chart of
accounts format.  So, for example if the account number starts with 61

Hello;
I'm not sure where to put this ?.  Hope someone can provide some insight.  
It may not be something I can accomplish solely w/Excel.
I want to get the foreign exchange rates everyday & store them in a master

Hello Experts,
I am attaching an excel file with what I would like to do and with what
I think is 'half' of the formula.
Basically I have certain agents that manage cases. I get the

Web query is easy to schedule 5 minute refresh, however I want to retain this
5minute data to create a database continuing throughout the trading day to
generate 5 minute intraday price/volume data, my question is how can I move
the data up or down so as not to remove the ...

Having trouble finding reviews of software that allows you to create
reports. using access database.

I've a file with this structure
Code value
0001 dfdf
0002 ddgdfg

I've worksheets where I've made custom colors.
Sometimes, when I email them, open them on different computers, or even
just open them on my computer after working with other .xls files, the
custom color has reverted to it's origional color or something