I am trying to find a way of importing data from several different excel
files into different sheets of the same excel file (in a specific format).  
Then, I am planning to consolidate these sheets into one.  The data that is
going to be imported will be refreshed often. Please ...

i have some infomation (numbers) in other file (not excel) that file can't
be copied. i would like to get those numbers into my excel file.
eg: In  that file:
     ganga     orders    55

After finally getting some add-ins into my Excel (Office2003) surprisingly
some of the default settings have changed. One of the most annoying changes
is that I cannot undo the delete action after pressing the delete button on
the keyboard. Does anyone know how to fix this ...

Hi - I am not sure if this should be posted in programing or not
I know that an if function can only hold 7 veriables so how can I get around
the following situation.
I have a macro which shows me which cell is being changed so contains

On some of my worksheets the trace precedent buttons are gray and can't be
used.
How to I restore the functionality of these buttons? On my prior version of
Excel, 2003, it said to use an auditing command. I don't know what was meant

I am have workbook A and want to link worksheet 1 from workbook B.
I try various syntax and Excel seems not like the syntax.
can you share your thoughts?
Thanks,

I have a spread sheet that has a safety stock quantity(Colum D4) and a
quantity on handColum C4). I would like to have the next colum (E4) state: if
quantity on hand is less than D4 then = C4-D4, but if C4 is equal or greater
than D4 then return with 0.

I want to subtract cells located in two different workhetts, and place the
answer in the 3rd. Ho can I

I have a table that looks like this (2 rows, with 18 numbers each)
32,15,19,4,21,2,25,17,34,6,27,13,36,11,30,8,23,26
10,5,24,16,33,1,20,14,31,9,22,18,29,7,28,12,35,3
(each number is in it's own cell).  The table is located in cells I4:AR5.

How would you include an existing logo in a worksheet?

Thanks for your answer re: deleting multiple names.  i will download the link
and try it out.  
i appreciate this forum's response to some of my queries, however, when the
link to the response appears in my Outlook inbox, i can't access the link.  

When I add a new custom menu or toolbar  in an Excel 2003 workbook it also
appears on every other workbook that I open or create.  Is that the default?  
Is there some setting that i can change so the menu/toolbar appears only on
the workbook that i created it on and does not ...

All,
Currently I'm trying to calculate values based on the following (and having
zero luck):  I have a sheet with multiple part numbers and global locations,
and the associated quantities.  So it might read:

I have the following code below. This one I got from Dave Paterson.
It works very well.
I have used this code in UserForm1 (commandbutton1), so when pressed it
closes the form after deleting duplicates. I have added a vbYesNo to