Ok. Here is what I have to do. Lets assume that I have 2 workbooks
BookA and BookB.. The BookA contains 20 sheets and BookB contains 3
sheets.
What I need to do is take each sheet from BookA and copy it as the

I'm trying to build a filter list for spam blocking. I have foreight IP
lists from ARIN.net. I have broken down the list into 8 columns: StartA,
StartB, StartC, StartD, EndA, EndB, EndC and EndD to reflect the starting
and ending IP address structure of the block I want to filter ...

I am trying to create pivot tables from existing spreadsheets that track
staff labor hours.  Yet, because these spreadsheets' cells of hours (in
effect, a single 'record') reference both the columns (individual staff
person) and rows (the tasks), MS Excel cannot create pivot ...

Hi gurus -
Okay, in my spreadsheet I have monthly subtotals in say, (this month),
cells B67 and B70. Next month, as I add data, the subtotals will be in
cells B74 and B77. In another cell, I would like a formula that lets me

I have a spreadsheet with multiple dates for multiple products and
prices in addition to other data in several colums.  I would like to
pick the latest ie. most recent price for each product and also display
the additional data ie. all the data in the row.

I have just installed latest updates for office 2003 and now find that when I
attempt to use the save as command the application hangs up and prompts me to
send a report to microsoft when I terminate a non-responding program.  Any
ideas as to what is wrong?

Please help me import data from 2 different excel files.
I have 2 files with heading Employee Name, Employee Number and Contact
Details.
I want similar data to be imported in third file with similar headings.

I'm embedding a Corel Draw graphic (logo) in an worksheet.  The
worksheet prints out two 'forms' per page each with a logo (and other
data) and there are up to 50 pages.  The logo is about 150KB so that
makes the file 15MB if I 'paste' each logo into the cell.  Is there

Can anyone recommend a really good Excel reference book?  In addition
to the Microsoft guides, I have purchased several books and find them
either too basic to be of help when the going gets tough, or a little
too hard to understand (usually because they use terms and operators

I was trying to extend the Conditional Formatting option so that based on
the condition I specify it changes the formatting for the entire row that
the cell is in, NOT just the single cell.
Can anyone help with this?

I tried to change the folder that excell uses to another folder
and now when i open excell it cycles thru all my excell files
and opens them but withe different error msgs like
html import errors

I want to create a pivot table that summarizes expences in different
categories. To do this I use a drop-down list containing these
categories, something like this:
category    expence               amount

Hi there, I'm having trouble finding a way to keep track of the hours
I've trained for my, hopefully successful, marathon. What I want to be
able to to is type in exactly what is on my watch i.e 1.09.25 and at
the end of the week it'll tell me how many hours that week I've

Hi,I'm trying to merge data from numerous worksheets, with varying
numbers of rows, but the same column headings, into the one worksheet.
i've been cutting and pasting to get the desired results but it takes
at least 15 minutes per workbook.

My name is Rohan Sewgobind.  I recently attended the Excel User
conference in Atlantic City and would like to take a moment to thank
all of the presenters for their useful tips and examples.  
Now the question